PFG FISH FLAG SIGNATURE 110 CAP

No 1998261

Description
Specs
Reviews
Live Chat

Raise the fish flag high

Protect yourself from the rays with UPF 50 sun protection in this adjustable, high-crown hat. With a secure, adjustable-fit design, this fishing-inspired hat is made with anglers in mind. Keep the sun out of your face while you line up your perfect cast, and enjoy the temperature-regulating mesh that makes sure your fishing trip is about fishing, not discomfort. Quality made with durable materials, you'll be waving your fish flag on this excellent ball cap for years to come.

Shell: 91% Polyester, 9% Elastane Stretch Woven
Shell Back: 100% Polyester
Omni-Shade™ UPF 50 sun protection (rating does not apply to mesh portion)
Flexfit® 110 Adjustable
Hook and loop back closure
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Protect yourself from the rays with UPF 50 sun protection in this adjustable, high-crown hat. With a secure, adjustable-fit design, this fishing-inspired hat is made with anglers in mind. Keep the sun out of your face while you line up your perfect cast, and enjoy the temperature-regulating mesh that makes sure your fishing trip is about fishing, not discomfort. Quality made with durable materials, you'll be waving your fish flag on this excellent ball cap for years to come.
Specs
- Shell: 91% Polyester, 9% Elastane Stretch Woven
- Shell Back: 100% Polyester
- Omni-Shade™ UPF 50 sun protection (rating does not apply to mesh portion)
- Flexfit® 110 Adjustable
- Hook and loop back closure
- Imported
Reviews

No Reviews Yet!
Live Chat

$35.00

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CARBON	121928	[empty string]	[empty string]	0	15	0	0	CARBON	75	Y	[empty string]	980448	[empty string]	209548
2	CITY_GREY	121929	[empty string]	[empty string]	0	11	0	0	CITY_GREY	60	Y	[empty string]	980449	[empty string]	209548
3	ELECTRIC_TURQ	121930	[empty string]	[empty string]	0	8	0	0	ELECTRIC_TURQ	27	Y	[empty string]	980450	[empty string]	209548

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,14,6,5,9,8,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) > 0 ) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,14,6,5,9,8,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	209548

struct
INTERNALLISTPRICE	35
INTERNALMARKDOWN	false
INTERNALPRICE	35
REG	35
SALE	35
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CARBON	121928	[empty string]	[empty string]	0	15	0	0	CARBON	75	Y	[empty string]	980448	[empty string]	209548
2	CITY_GREY	121929	[empty string]	[empty string]	0	11	0	0	CITY_GREY	60	Y	[empty string]	980449	[empty string]	209548
3	ELECTRIC_TURQ	121930	[empty string]	[empty string]	0	8	0	0	ELECTRIC_TURQ	27	Y	[empty string]	980450	[empty string]	209548

array
1	209548

struct
INTERNALLISTPRICE	35
INTERNALMARKDOWN	false
INTERNALPRICE	35
REG	35
SALE	35
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CARBON	121928	[empty string]	[empty string]	0	15	0	0	CARBON	75	Y	[empty string]	980448	[empty string]	209548
2	CITY_GREY	121929	[empty string]	[empty string]	0	11	0	0	CITY_GREY	60	Y	[empty string]	980449	[empty string]	209548
3	ELECTRIC_TURQ	121930	[empty string]	[empty string]	0	8	0	0	ELECTRIC_TURQ	27	Y	[empty string]	980450	[empty string]	209548