Springfield

SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2026-04-14 09:00:00' AND b.end_date >= '2026-04-14 09:00:00' AND b.store_id in ('10','32')

SELECT * 
	FROM tb_mfg_promo.dbo.tb_pkg a with (nolock)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id) 
	WHERE 
	b.main_id is not NULL 
	and a.start_date<= '04/14/2026 23:59:00' and a.end_date >= '04/14/2026'
	
	and a.site='sportsman'

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)
	where site is NULL

SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(CASE WHEN qq.of9 IS NULL OR qq.of9 = '' THEN 0 ELSE c.price / qq.of9 END) as round
	
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
	
	
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and c.store_id in ('10', 32)
	
	
	
	
	 and a.brand='springfield'
	
	group by a.styles_web_taxonomy_id

select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
			,   max(qoh) as qoh
			,	max(qc) as qc
			,	max(qs) as qs
			,	max(of18) as of18
			,	max(of17) as of17
			,	max(of15) as of15
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproductsspringfield
		where
		 style_id is not null
            
				and brand='SPRINGFIELD'
			


group by Style_id order by
min_price

select * from grandgetproductsspringfield
		where
		 picture_id is not null
            
			
				and brand='SPRINGFIELD'
			


order by

min_price

select * from tb_mfg_promo.dbo.tb_brands with (nolock) where brand = 'springfield'

select distinct (dept) as dept from getproducts1 where brand='SPRINGFIELD' group by dept

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 792 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='California Guns' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='California Handguns' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='California Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 17 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='AR Parts and Accessories' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Gun Parts' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Gun Storage' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Holsters' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Magazine Parts' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Magazines' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Optics' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Police Trade & Surplus' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 18 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='Firearms' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 795 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Pistols with Color' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Rifles with Color' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 29 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='Law Enforcement' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 850 and c.style_id in (198749,50329,104381,104382,172232,294644,50263,50262,147935,196862,295106,301383,217977,200055,50330,204620,225853,247017,200052,50320,181951,202856,205887,217978,219973,198750,204020,204028,50264,50314,50317,50318,106365,116781,150827,150828,168826,204030,217980,227800,247013,50224,50324,50331,104299,204025,116780,204023,247012,289801,50319,50459,70309,178889,200045,200056,204021,204027,218010,251533,251534,360631,360632,360633,360637,150830,168818,200049,247019,50325,114206,119401,178601,273164,247022,178597,264571,286928,336465,168820,50236,50315,50316,50326,50327,50328,104298,104300,104301,117784,128522,158185,158186,161144,161934,168815,168816,168817,168819,168822,168824,168827,168836,181811,181812,181948,192164,200047,200053,202869,209199,209200,227801,247015,247016,247020,247021,267495,267496,278937,297477,360618,360629,360638,360639,360641,204029,204031,178598,178600,204022,232289,232290,282958,282959,282960,293567,293568,360624,360626,360642,50261,114207,121523,121524,150831,168832,168833,168834,200048,204024,360635,360636,200054,202868,232291,184301,360643,150829,360616,168835,50237,293571,360634,274444,332293,168821,293572,293573,283655,291107,275793,283657,120478,291819,298750,352673,291818,356777,291820,198748,297478,358381,344094,344107,356778,215411,242371,247652,291817,343982,358257,118861,147044,164345,225269,228611,242413,288063,307900,319842,352468,225339,225356,228584,242401,242412,247650,221039,285783,290524,290552,305594,332313,360739,110707,312391,221040,277878,285149,287910,292994,297365,319852,326855,337386,342912,323748,323751,76990,213797,221038,268271,277920,280174,280175,281299,281300,281412,285153,285206,285832,285886,287923,288098,290517,290536,290641,290643,290672,294904,296463,298691,299038,299208,305637,307890,309587,309589,325339,329311,330977,330978,331101,333044,334122,337824,338643,338649,340675,342959,343111,345066,349809,353923,353924,354440,354445,356049,359750,361891,262817,262818,192091,290564,290646,290675,291042,293420,294944,299054,299256,307678,307703,333618,337368,340712,346896,348334,348724,348901,352496,353921,356050,262342,283885,283908,283931,283934,283937,283940,283945,285878,285941,290610,290615,298724,298954,299008,305106,324470,338814,345062,345069,345149,346994,346998,348087,348660,352120,361876,294628,279872,122101,192087,192092,283886,283888,283896,283921,285965,287996,289748,290589,294624,294625,294629,294631,296607,301168,301169,320023,330970,331243,336870,340639,340645,342944,343308,348088,348903,355949,356048,359738,360276,360742,360743,360852,360853,361887,310223,320021,331087,331095,331099,360717,50344,192088,213798,262859,262860,283906,294623,294626,294630,299080,301166,334967,336765,338815,347135,361833,279875,50334,50341,50423,50435,50447,202873,209208,50337,50364,50426,50446,151734,151738,168475,168476,175310,189649,197560,198108,198109,205998,217540,222281,249221,249888,255625,272642,282819,285340,285398,285876,290566,290666,291972,297377,298994,299399,301165,304989,307797,311628,325315,330958,331083,331090,331094,340713,355122,356655,360740,361588,362031,50408,245832,262835,50379,50358,50362,50403,50412,50437,156138,173848,179361,197561,206720,214440,221056,222009,262819,50445,50367,50371,50454,151736,163556,168477,196818,198110,202872,202874,205395,272640,272641,301454,326049,331091,331093,342908,228084,250427,131065,131067,131482,131828,172120,205975,246342,262839,279873,50375,150119,150283,151699,151701,151735,162501,168266,168267,168458,168459,168460,169439,170772,171972,172119,172139,176117,182490,184358,198111,198114,198115,198116,198117,198122,198123,198129,198131,202867,205974,208894,212895,212898,212899,212900,214456,214457,222008,222978,263453,263454,263455,263456,263458,263461,263463,263465,285202,285390,285508,285522,293418,293419,294934,311859,331097,340760,262821,262822,126950,136426,151737,182494,189650,189741,189834,192028,192861,200995,203423,214450,228085,279878,50415,116810,138359,141727,152751,155727,168463,168464,168514,168881,168888,170727,173130,175576,198120,198121,198133,198135,208895,208896,225764,282820,301485,251602,50419,50448,131234,133945,150282,150284,155725,155726,162502,168455,168456,168457,168462,168478,168976,172122,172128,172146,172147,182496,192000,203431,212894,212901,214453,282270,251441,86654,168466,168467,179363,179366,195469,205015,210470,251603,279880,279882,50332,50414,65065,117366,131560,153439,155728,168461,168470,168474,168978,172319,173131,175575,175605,189835,189836,192862,194285,210473,212896,212897,222007,225257,246335,246338,255626,263410,263459,263460,263462,263464,263466,264685,264686,281247,286306,289015,293048,293049,293050,301486,305068,359414,212022,216029,262827,279864,279866,50460,262826,272643,84133,98569,126951,138364,143155,173039,214497,225250,225254,225765,225766,282118,282119,279883,285716,68694,168479,170111,170445,182508,202871,212906,213351,227675,227856,251119,282115,288432,288435,329393,262833,279870,279871,299107,299108,293472,330858,66719,101046,138596,147928,147929,168468,168469,179367,179368,205396,250060,297294,279867,131922,168465,172320,214451,245838,301260,110944,262823,262824,50461,168471,179362,200736,202776,202853,208948,245834,263411,264120,278227,282116,282120,284692,292055,297285,297291,340508,353010,293481,330860,279879,87303,90903,132171,225252,225255,287664,299109,357670,262840,325899,299110,330873,175577,179373,179374,323727,333253,65347,103736,103737,179371,210904,214435,214442,214444,214446,250056,266609,274470,282121,282122,282123,297283,297288,303302,334959,334961,340505,349882,356660,353693,357674,357675,84091,168473,282117,288436,340509,135177,138627,179372,209138,214445,214447,220091,225840,245836,245837,251445,271901,281144,282114,284893,287773,288437,288667,297284,297286,297290,303300,316784,323725,326279,333785,334964,340507,354319,354896,356602,358864,107821,172118,210472,218080,110388,250683,269387,91741,197559,205399,253489,288433,288434,288837,290468,292885,292888,311427,316429,323729,334962,334963,340503,330262,109029,219779,269907,283200,287774,298215,309880,319901,319902,319903,333755,334960,337137,356662,311428,214452,245835,251120,292887,323728,343338,282008,250178,262850,262852,262861,279881,108601,195475,334934,334936,334965,357583,287665,279893,357243,117533,202854,202855,281049,211651,214454,225842,323726,324476,357578,330924,333553,251432,183929,50251,50253,219972,220613,220614,220686,316783,324730,349818,357579,357580,357581,251437,279888,279889,109112,279892,279894,262843,266762,189648,212902,219904,250054,262867,266625,117986,251217,262879,330869,333472,214455,222010,222014,225841,266610,271902,333259,341118,357582,357584,207093,218083,212903,309879,282007,262870,273595,311242,311549,350558,175578,274472,280535,251435,260823,279897,279899,69945,262845,50287,97929,133433,143198,154808,154814,154815,197129,168472,183931,195471,198112,200304,210471,211652,222011,272666,279189,279195,279197,279524,262844,262848,210467,245844,245845,256943,262883,273596,50250,202875,202879,311243,202880,273860,202876,202877,202881,214792,214793,214794,147643,50252,198941,198942,214795,214796,214797,246121,264122,267634,280575,198937,198938,198943,251438,251630,256614,273861,198939,262882,222793,251436,251608,262885,279901,206926,262841,50295,168256,168257,168258,168706,262866,50288,172110,196182,208690,222725,262886,279199,279203,279206,279207,281433,288223,304941,202883,338596,279896,264121,332270,202882,262878,262880,262864,198944,202888,212905,214459,214460,50266,50268,50289,50265,50290,198113,198940,279204,279205,279224,250882,189652,212904,222013,50286,189647,189651,267143,267975,218084,232277,335517,189128,189653,189740,222012,250883,262081,279184,294996,334966,335624,287655,298636,189420,262893,335625,335626,336619,137461,50284,357587,50271,50294,189422,204604,222728,298416,301463,303047,303049,201480,303048,333486,214461,298204,301465,74961,104885,122651,108225,189655,222731,275999,288675,325981,338311,338465,359417,250680,255512,189460,189654,189831,288672,288674,50270,279902,247634,262887,285296,323730,204606,193059,342712,154813,214462,214464,263055,273401,279200,285003,309357,337062,357588,189656,200737,214458,80052,273409,298195,225767,250070,267467,336430,283818,283819,262874,262877,357648,85638,218081,152554,222730,222954,331735,50256,50258,189830,218533,245839,251439,279196,279522,282994,282995,301527,337061,338547,262903,65992,222726,222727,262873,328678,329096,305161,262904,245971,245973,245974,319954,319955,357585,359415,279906,50255,143752,50254,189657,202885,202887,269402,274193,334968,334969,250678,105632,331894,331895,152545,154812,189658,202889,202891,280338,284637,320707,320710,350818,351833,351836,351837,125401,262905,262902,178881,107768,349079,349080,152543,202105,152544,50257,50259,152553,210474,210475,307677,311239,311240,357586,279905,262891,262899,262901,205287,250679,260982,262906,152551,161631,50246,280025,303846,303847,50222,50242,279904,178665,210469,256319,301499,301500,50220,279884,303818,303820,303821,192084,192085,65991,262892,358034,202890,207023,300891,303837,303838,303844,303845,296300,296301,299439,301498,280024,50245,50221,50244,201824,202106,202886,213019,274194,152548,161632,201826,222467,256295,200728,298583,298584,301495,262897,301497,168128,178664,293414,200726,276356,293415,301496,340254,340255,360479,202892,201829,50223,169391,202893,50219,256296,293416,245841,245842,256297,256324,50248,50249,316338,176256,256314,256315,172109,50307,86771,50309,86572,123691,140041,146947)

select distinct typ from getproducts1 where dept='Springfield Armory' and brand='SPRINGFIELD' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='911 Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Bolt-Action Rifle Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Factory Magazines' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='M1A Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='SA-35 Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='SAINT Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Springfield 1911A1' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Springfield 9mm Hellcat Guns' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Springfield XD Mod.2 Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Springfield XD-E Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='Springfield XDM Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='XD Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='XDS Mod.2 Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Springfield Armory' and typ='XDS Series' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 198749 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 198749 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=198749

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 198749 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=198749  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=198749 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 50329 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 50329 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=50329

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 50329 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50329  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=50329 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 104381 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 104381 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=104381

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 104381 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=104381  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=104381 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 104382 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 104382 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=104382

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 104382 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=104382  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=104382 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 172232 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 172232 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=172232

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 172232 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=172232  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=172232 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 294644 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 294644 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=294644

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 294644 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=294644  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=294644 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 50263 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 50263 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=50263

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 50263 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50263  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=50263 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 50262 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 50262 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=50262

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 50262 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50262  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=50262 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 147935 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 147935 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=147935

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 147935 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=147935  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=147935 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 196862 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 196862 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=196862

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 196862 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=196862  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=196862 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 295106 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 295106 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=295106

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 295106 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=295106  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=295106 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 301383 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 301383 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=301383

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 301383 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=301383  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=301383 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 217977 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 217977 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:38' and
end_date >= 'Apr 14, 2026 09:23:38'
and store_id=10 and style_id=217977

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 217977 
and (a.start_date<= 'Apr 14, 2026 09:23:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=217977  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=217977 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 200055 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 200055 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:39' and
end_date >= 'Apr 14, 2026 09:23:39'
and store_id=10 and style_id=200055

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 200055 
and (a.start_date<= 'Apr 14, 2026 09:23:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=200055  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=200055 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 50330 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 50330 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:39' and
end_date >= 'Apr 14, 2026 09:23:39'
and store_id=10 and style_id=50330

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 50330 
and (a.start_date<= 'Apr 14, 2026 09:23:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50330  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=50330 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 204620 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 204620 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:39' and
end_date >= 'Apr 14, 2026 09:23:39'
and store_id=10 and style_id=204620

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 204620 
and (a.start_date<= 'Apr 14, 2026 09:23:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=204620  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=204620 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 225853 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 225853 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:39' and
end_date >= 'Apr 14, 2026 09:23:39'
and store_id=10 and style_id=225853

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 225853 
and (a.start_date<= 'Apr 14, 2026 09:23:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=225853  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=225853 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold

			from tb_skus a with (nolock)

			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 

			where a.style_id = 247017 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 247017 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:23:39' and
end_date >= 'Apr 14, 2026 09:23:39'
and store_id=10 and style_id=247017

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 247017 
and (a.start_date<= 'Apr 14, 2026 09:23:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:23:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=247017  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=247017 and status='A' and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOSS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
baseurl=https://www.sportsmansoutdoorsuperstore.com/sezzle/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
[email protected]
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
privatekay=sz_pr_nMBvrWcNk9cNGP9sN695umNINohQkV4r
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
publickey=sz_pub_T20udXXUkabHIADEGrGe3pgtZjwms0K6
qoh_store=10
safety_stock=0
[email protected]
secureurl=https://www.sportsmansoutdoorsuperstore.com/
sezzleapiurl=https://gateway.sezzle.com
sezzletenderid=66
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/brand/springfield/order_by/min_price
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/brand/springfield/order_by/min_price
PATH_TRANSLATED=E:\inetpub\wwwroot\category.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=22877096
cftoken=c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57
hitcount=1
lastvisit={ts '2026-04-14 09:23:36'}
timecreated={ts '2026-04-14 09:23:36'}
urltoken=CFID=22877096&CFTOKEN=c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57

Cookie Variables:
CFID=22877096
CFTOKEN=c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
S_U_F345=Y
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=22877096
cftoken=c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57
cs=/category.cfm/brand/springfield/order_by/min_price
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22877096_c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57
strarray=Array (0)
urltoken=CFID=22877096&CFTOKEN=c0fcc4d37712758d-799D3B00-ED20-0083-DD96FCFB2BB42D57

URL Parameters:
CLEARANCE=
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=springfield
WHATSNEW=
brand=springfield
order_by=min_price