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

 	available desc, non_invt desc

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

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

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

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

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

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

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 *
			FROM tb_mfg_promo.dbo.tb_mfg_promos 
			WHERE brand='springfield' and (start_date<= '04/14/2026 23:59:00' or active=1) and end_date >= '04/14/2026'

select distinct style_id, min(min_price) as min_price,max(max_price) as max_price, max(style) as style,	max(web_style) as web_style,	max(web_desc) as web_desc,	max(web_description) as web_description,max(picture_id) as picture_id,  max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of2) as of2,max(of6) as of6, max(of9) as of9,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price,max(round) as round
from grandgetproductsspringfield where style_id is not null and available>0 
group by Style_id 
order by qc asc, sold desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Apr 14, 2026 09:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
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:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=227801

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 = 227801 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=70309

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 = 70309 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=267495

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 = 267495 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=50325

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 = 50325 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=218010

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 = 218010 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS where bulk_id = ? and site is NULL

select distinct style_id,max(styles_web_taxonomy_id) as styles_web_taxonomy_id, min(min_price) as min_price,max(max_price) as max_price, max(style) as style,	max(web_style) as web_style,	max(web_desc) as web_desc,	max(web_description) as web_description,max(picture_id) as picture_id,  max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of2) as of2,max(of6) as of6, max(of9) as of9,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price,max(round) as round
from grandgetproductsspringfield where style_id is not null and available>0 

and style_id not in (?,?,?,?,?,?)

group by Style_id 
order by styles_web_taxonomy_id desc

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

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 = 359417 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=361891

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 = 361891 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=361876

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 = 361876 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=361833

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 = 361833 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=362031

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 = 362031 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=359415

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 = 359415 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS where bulk_id = ? and site is NULL

select a.spec_value_id, max(a.spec_value) as spec_value, max(a.spec_img) as spec_img, max(a.spec_desc) as spec_desc, max(c.brand) as brand
		from 
			tb_mfg_promo.dbo.item_spec_values a WITH (NOLOCK)
				INNER JOIN tb_mfg_promo.dbo.item_specs b with (NOLOCK) ON (a.spec_value_id = b.spec_value_id)
				INNER JOIN tb_styles c with (NOLOCK) ON (b.style_id = c.style_id)
		where c.brand = 'springfield' and a.spec_img is not NULL
		group by a.spec_value_id
		order by spec_value asc

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 = 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
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:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
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 = 357578 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 = 357578 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=357578

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 = 357578 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=357578  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=357578 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 = 357579 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 = 357579 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=357579

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 = 357579 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=357579  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=357579 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 = 336465 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 = 336465 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=336465

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 = 336465 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336465  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=336465 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 = 357580 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 = 357580 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:27:31' and
end_date >= 'Apr 14, 2026 09:27:31'
and store_id=10 and style_id=357580

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 = 357580 
and (a.start_date<= 'Apr 14, 2026 09:27:31' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:31'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=357580  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=357580 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 = 357583 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 = 357583 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=357583

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 = 357583 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=357583  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=357583 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 = 50318 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 = 50318 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=50318

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 = 50318 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50318  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=50318 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 = 289801 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 = 289801 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=289801

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 = 289801 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=289801  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=289801 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 = 50314 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 = 50314 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=50314

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 = 50314 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50314  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=50314 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 = 70309 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 = 70309 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=70309

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 = 70309 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=70309  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=70309 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 = 128522 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 = 128522 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=128522

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 = 128522 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=128522  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=128522 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
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:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
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 = 251534 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 = 251534 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=251534

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 = 251534 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=251534  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=251534 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 = 50319 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 = 50319 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=50319

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 = 50319 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50319  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=50319 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 = 168818 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 = 168818 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=168818

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 = 168818 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=168818  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=168818 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 = 200047 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 = 200047 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=200047

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 = 200047 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=200047  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=200047 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 = 50459 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 = 50459 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=50459

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 = 50459 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=50459  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=50459 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 = 204031 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 = 204031 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:27:32' and
end_date >= 'Apr 14, 2026 09:27:32'
and store_id=10 and style_id=204031

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 = 204031 
and (a.start_date<= 'Apr 14, 2026 09:27:32' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 09:27:32'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=204031  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=204031 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/CurrentPage/1/brand/springfield
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=/CurrentPage/1/brand/springfield
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=22877181
cftoken=8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66
hitcount=1
lastvisit={ts '2026-04-14 09:27:30'}
timecreated={ts '2026-04-14 09:27:30'}
urltoken=CFID=22877181&CFTOKEN=8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66

Cookie Variables:
CFID=22877181
CFTOKEN=8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66
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=22877181
cftoken=8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66
cs=/category.cfm/CurrentPage/1/brand/springfield
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22877181_8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66
strarray=Array (0)
urltoken=CFID=22877181&CFTOKEN=8376195c4d2307f7-79C0E9FE-06C9-BFE2-ECB12DA16BBE6D66

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