Savage

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 06:00:00' AND b.end_date >= '2026-04-14 06: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='savage'
	
	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 grandgetproductssavage
		where
		 style_id is not null
            
				and brand='SAVAGE'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproductssavage
		where
		 picture_id is not null
            
			
				and brand='SAVAGE'
			


order by

min_price

select distinct (dept) as dept from getproducts1 where brand='SAVAGE' 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='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 (261885,46376,348166,336690,338432,46420,261882,338426,338442,348167,359873,336670,210101,261945,336680,338431,46454,138322,168369,288905,336664,336666,338439,181143,188834,262009,288910,288914,305549,338423,338424,338425,338427,338428,340127,348469,46208,46209,46256,46258,46307,46336,46338,46339,46340,46341,46342,46346,46347,46361,46362,46363,46364,46366,46367,46368,46369,46372,46378,46383,46385,46392,46400,46404,46407,46409,46411,46421,46422,46423,46424,46430,46435,46445,46449,46450,46451,46452,46453,46456,66862,67362,67867,69778,69862,75180,75555,75674,75706,76486,78931,79609,80488,85100,87203,88569,89123,89436,93495,93710,94150,96386,98114,98118,98122,98127,98129,98195,98312,98542,98893,99263,99394,99692,100276,100445,100446,100864,100866,100872,102036,102040,102326,102327,103992,104766,106504,108302,108446,108816,109069,109084,109085,110148,113145,114238,114274,114275,114276,114413,114449,114541,114606,114607,114770,115075,115076,115309,115346,115349,115351,115380,115531,115943,115945,116046,116135,116201,116266,116267,116552,116648,116709,117031,117340,118075,118310,118893,118895,118955,118989,119342,119540,119578,120676,120718,120732,121604,121804,121915,122372,122499,122501,122502,122503,122518,122520,122677,122709,122710,122712,122947,122948,122949,123809,124068,124277,126080,126372,126373,126945,127999,129592,133839,133908,135326,135395,135396,135397,135398,135399,135400,135401,135402,138118,138136,138271,138272,138273,138274,138275,138276,138277,138286,138289,138294,138316,138317,138318,138445,140105,140107,140134,141288,141290,144806,144807,144899,147109,147780,147781,147880,152067,152149,152150,152151,152152,152154,154880,154881,154882,154884,154887,154888,154890,154891,154895,154896,154898,154900,154902,154904,154909,154911,154913,154920,154922,154923,154924,154925,154926,155120,155121,155122,155123,155124,155125,155126,156045,156143,158240,158371,161068,161085,161101,161241,165019,165265,165266,165267,165268,165269,168707,168713,168715,168716,168717,168718,168796,168947,168983,169710,169711,169712,169713,169714,170381,173041,173044,173045,173046,173052,173053,173054,173093,173286,173902,173903,175654,175655,175656,175884,175885,175886,181144,181150,181152,181157,181653,182314,184267,184551,188154,188157,191684,192156,192157,192159,192160,192161,192162,193330,193338,193356,193357,193464,193465,193466,193467,193468,193469,193470,193471,193472,193474,193476,193479,193480,193481,193482,193483,193484,193485,194358,194359,194360,196117,199756,199757,199758,199760,199761,199762,199763,199764,200478,200843,200845,200847,201372,204701,204702,204703,204704,204705,205106,205501,205680,205681,205682,205684,205685,205686,205687,205688,205689,205690,205691,205727,205728,205729,205730,205731,205732,205733,205734,205735,205736,205737,205738,205739,205740,205741,205838,206006,207980,207981,207982,207983,207984,207987,207988,207989,207990,207991,207992,207994,207995,207996,207997,207998,207999,208000,208001,209458,209695,210102,210104,210105,210106,210148,210149,210150,210151,211324,211325,212642,215423,217150,217151,217154,217155,217156,217158,217232,217236,217239,217240,217293,217301,217302,217303,217304,217305,217306,217307,217310,217311,217312,217314,217315,217316,217317,219839,219983,220597,227244,227569,227571,227575,227579,227583,227586,227591,227594,227600,227603,227604,227606,227609,227610,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227936,227937,242374,246929,246930,246931,246932,246933,247181,247184,247185,247187,247188,247189,247190,247191,247192,247193,247194,247195,247196,247197,247198,247199,247200,247201,247202,247203,247204,247206,247208,247209,247210,247211,247212,247213,247214,247218,247219,247220,247221,247222,247223,247224,247225,247226,247227,247561,248409,248410,248417,251116,251117,251567,251569,251570,251571,251572,251573,251574,253258,253259,253260,253262,253264,253367,253518,253519,253520,253533,253534,253535,253599,253600,253603,253604,253605,253606,253607,253989,253990,253991,253992,253993,253994,254103,254104,254480,254483,254485,254486,254487,254488,254489,254491,254493,254494,254496,254497,254498,254499,254500,254501,254504,255291,255292,255295,255297,255483,255605,256418,256419,256420,256421,256422,257118,260604,261509,261806,261807,261808,261809,261810,261818,261820,261821,261876,261880,261881,261884,261946,261947,261948,261960,261964,261967,261969,261970,261971,261972,261975,262010,262011,262013,262014,262015,262922,264017,264018,264019,264020,264043,264645,266212,266213,266697,267742,267763,267767,267769,268500,268501,268504,268525,268527,268528,268530,268538,268542,268543,268545,268546,268548,268549,268550,268552,268557,268558,268559,268560,268561,268562,268568,268569,268570,268573,268574,268576,268577,268579,268580,268582,268583,268584,268585,268587,268589,268590,268591,268592,268593,268594,268595,268596,268602,268649,273470,273565,276672,278717,278718,278719,278720,278721,278722,278723,278727,278728,278729,280139,281066,283237,283240,283858,285366,285447,285529,286236,287055,287056,287958,288183,288184,288916,289023,289100,289388,289423,289687,289693,290100,290102,290108,290123,290473,290503,291713,291860,292005,293019,293042,293043,296374,296452,297300,297301,298824,298929,299141,299149,304799,304800,304801,304802,304803,304804,304805,304915,304916,305544,305545,305546,305547,305552,305553,310333,310339,312248,316719,316741,326342,326343,328583,330671,331052,332640,332645,332650,332664,332764,332765,334178,334917,335169,335208,335209,335212,335213,335222,335623,336205,336661,336672,336674,336675,336677,336678,336683,336687,336692,336696,337713,337715,337720,337722,337788,337980,338063,338429,338430,338433,338443,338445,338446,338449,338450,338452,338706,340784,341111,341142,341143,341144,341145,341153,341156,341157,341158,341159,341160,341161,341162,341163,341164,341165,341166,341167,341168,341169,341170,341171,341172,341173,341174,341175,341176,341177,341178,341179,341180,341181,341182,341183,341184,341185,341186,341187,341188,341189,341190,341191,341192,341193,341195,341196,341197,341198,341199,341200,341201,341202,341203,341204,341205,341206,341207,341208,341209,341210,341211,341212,341214,341215,341216,341217,341218,341219,341220,341221,341222,341224,341225,341226,341227,341228,341229,341230,341231,341232,341233,341234,341235,341236,341237,341238,341239,341240,341241,341242,341243,341244,341245,341246,341247,341248,341249,341251,341252,341253,341254,341255,341256,341257,341258,341259,341260,341261,341262,341263,341264,341265,341266,341267,341268,341269,341270,341271,341272,341273,341274,341275,341276,341277,341278,341279,341280,341281,341282,341283,341284,341285,341286,341287,341288,341289,341290,341291,341292,341293,341294,341295,341296,341297,341298,341299,341300,341301,341302,341303,341304,341305,341306,341307,341308,341309,341310,341312,341313,341314,341315,341316,341317,341318,341319,341344,341373,341374,341375,341376,341381,341382,341383,341384,341386,341389,341390,341391,341392,341393,341394,341400,341408,341409,341410,341411,341412,341413,341414,341415,341416,341417,341418,341419,341421,342189,343735,343737,343973,344008,344067,345002,346916,347185,348340,348341,348342,348343,348344,348346,348347,348348,348349,348350,348351,348352,348353,348354,348355,348356,348357,348358,348359,348360,348361,348362,348363,348364,348365,348366,348367,348368,348369,348370,348371,348372,348373,348374,348375,348376,348377,348378,348379,348380,348381,348382,348384,348385,348386,348387,348388,348389,348390,348391,348392,348393,348394,348395,348396,348397,348398,348399,348400,348401,348402,348403,348404,348405,348406,348407,348408,348409,348410,348411,348412,348414,348415,348416,348417,348418,348419,348420,348421,348422,348423,348424,348425,348426,348427,348428,348429,348430,348431,348432,348433,348434,348435,348436,348437,348438,348439,348440,348441,348442,348443,348444,348445,348446,348447,348448,348449,348450,348451,348452,348453,348454,348455,348456,348457,348458,348459,348460,348461,348462,348463,348464,348465,348466,348468,348470,348471,348472,348473,348474,348475,348476,348477,348478,348479,348480,348957,349220,351854,351890,352033,352659,352660,358358,358423,359802,361559,361927,341194)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='SAVAGE' 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='Bipods & Tripods' 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='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, 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 (261885,46376,348166,336690,338432,46420,261882,338426,338442,348167,359873,336670,210101,261945,336680,338431,46454,138322,168369,288905,336664,336666,338439,181143,188834,262009,288910,288914,305549,338423,338424,338425,338427,338428,340127,348469,46208,46209,46256,46258,46307,46336,46338,46339,46340,46341,46342,46346,46347,46361,46362,46363,46364,46366,46367,46368,46369,46372,46378,46383,46385,46392,46400,46404,46407,46409,46411,46421,46422,46423,46424,46430,46435,46445,46449,46450,46451,46452,46453,46456,66862,67362,67867,69778,69862,75180,75555,75674,75706,76486,78931,79609,80488,85100,87203,88569,89123,89436,93495,93710,94150,96386,98114,98118,98122,98127,98129,98195,98312,98542,98893,99263,99394,99692,100276,100445,100446,100864,100866,100872,102036,102040,102326,102327,103992,104766,106504,108302,108446,108816,109069,109084,109085,110148,113145,114238,114274,114275,114276,114413,114449,114541,114606,114607,114770,115075,115076,115309,115346,115349,115351,115380,115531,115943,115945,116046,116135,116201,116266,116267,116552,116648,116709,117031,117340,118075,118310,118893,118895,118955,118989,119342,119540,119578,120676,120718,120732,121604,121804,121915,122372,122499,122501,122502,122503,122518,122520,122677,122709,122710,122712,122947,122948,122949,123809,124068,124277,126080,126372,126373,126945,127999,129592,133839,133908,135326,135395,135396,135397,135398,135399,135400,135401,135402,138118,138136,138271,138272,138273,138274,138275,138276,138277,138286,138289,138294,138316,138317,138318,138445,140105,140107,140134,141288,141290,144806,144807,144899,147109,147780,147781,147880,152067,152149,152150,152151,152152,152154,154880,154881,154882,154884,154887,154888,154890,154891,154895,154896,154898,154900,154902,154904,154909,154911,154913,154920,154922,154923,154924,154925,154926,155120,155121,155122,155123,155124,155125,155126,156045,156143,158240,158371,161068,161085,161101,161241,165019,165265,165266,165267,165268,165269,168707,168713,168715,168716,168717,168718,168796,168947,168983,169710,169711,169712,169713,169714,170381,173041,173044,173045,173046,173052,173053,173054,173093,173286,173902,173903,175654,175655,175656,175884,175885,175886,181144,181150,181152,181157,181653,182314,184267,184551,188154,188157,191684,192156,192157,192159,192160,192161,192162,193330,193338,193356,193357,193464,193465,193466,193467,193468,193469,193470,193471,193472,193474,193476,193479,193480,193481,193482,193483,193484,193485,194358,194359,194360,196117,199756,199757,199758,199760,199761,199762,199763,199764,200478,200843,200845,200847,201372,204701,204702,204703,204704,204705,205106,205501,205680,205681,205682,205684,205685,205686,205687,205688,205689,205690,205691,205727,205728,205729,205730,205731,205732,205733,205734,205735,205736,205737,205738,205739,205740,205741,205838,206006,207980,207981,207982,207983,207984,207987,207988,207989,207990,207991,207992,207994,207995,207996,207997,207998,207999,208000,208001,209458,209695,210102,210104,210105,210106,210148,210149,210150,210151,211324,211325,212642,215423,217150,217151,217154,217155,217156,217158,217232,217236,217239,217240,217293,217301,217302,217303,217304,217305,217306,217307,217310,217311,217312,217314,217315,217316,217317,219839,219983,220597,227244,227569,227571,227575,227579,227583,227586,227591,227594,227600,227603,227604,227606,227609,227610,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227936,227937,242374,246929,246930,246931,246932,246933,247181,247184,247185,247187,247188,247189,247190,247191,247192,247193,247194,247195,247196,247197,247198,247199,247200,247201,247202,247203,247204,247206,247208,247209,247210,247211,247212,247213,247214,247218,247219,247220,247221,247222,247223,247224,247225,247226,247227,247561,248409,248410,248417,251116,251117,251567,251569,251570,251571,251572,251573,251574,253258,253259,253260,253262,253264,253367,253518,253519,253520,253533,253534,253535,253599,253600,253603,253604,253605,253606,253607,253989,253990,253991,253992,253993,253994,254103,254104,254480,254483,254485,254486,254487,254488,254489,254491,254493,254494,254496,254497,254498,254499,254500,254501,254504,255291,255292,255295,255297,255483,255605,256418,256419,256420,256421,256422,257118,260604,261509,261806,261807,261808,261809,261810,261818,261820,261821,261876,261880,261881,261884,261946,261947,261948,261960,261964,261967,261969,261970,261971,261972,261975,262010,262011,262013,262014,262015,262922,264017,264018,264019,264020,264043,264645,266212,266213,266697,267742,267763,267767,267769,268500,268501,268504,268525,268527,268528,268530,268538,268542,268543,268545,268546,268548,268549,268550,268552,268557,268558,268559,268560,268561,268562,268568,268569,268570,268573,268574,268576,268577,268579,268580,268582,268583,268584,268585,268587,268589,268590,268591,268592,268593,268594,268595,268596,268602,268649,273470,273565,276672,278717,278718,278719,278720,278721,278722,278723,278727,278728,278729,280139,281066,283237,283240,283858,285366,285447,285529,286236,287055,287056,287958,288183,288184,288916,289023,289100,289388,289423,289687,289693,290100,290102,290108,290123,290473,290503,291713,291860,292005,293019,293042,293043,296374,296452,297300,297301,298824,298929,299141,299149,304799,304800,304801,304802,304803,304804,304805,304915,304916,305544,305545,305546,305547,305552,305553,310333,310339,312248,316719,316741,326342,326343,328583,330671,331052,332640,332645,332650,332664,332764,332765,334178,334917,335169,335208,335209,335212,335213,335222,335623,336205,336661,336672,336674,336675,336677,336678,336683,336687,336692,336696,337713,337715,337720,337722,337788,337980,338063,338429,338430,338433,338443,338445,338446,338449,338450,338452,338706,340784,341111,341142,341143,341144,341145,341153,341156,341157,341158,341159,341160,341161,341162,341163,341164,341165,341166,341167,341168,341169,341170,341171,341172,341173,341174,341175,341176,341177,341178,341179,341180,341181,341182,341183,341184,341185,341186,341187,341188,341189,341190,341191,341192,341193,341195,341196,341197,341198,341199,341200,341201,341202,341203,341204,341205,341206,341207,341208,341209,341210,341211,341212,341214,341215,341216,341217,341218,341219,341220,341221,341222,341224,341225,341226,341227,341228,341229,341230,341231,341232,341233,341234,341235,341236,341237,341238,341239,341240,341241,341242,341243,341244,341245,341246,341247,341248,341249,341251,341252,341253,341254,341255,341256,341257,341258,341259,341260,341261,341262,341263,341264,341265,341266,341267,341268,341269,341270,341271,341272,341273,341274,341275,341276,341277,341278,341279,341280,341281,341282,341283,341284,341285,341286,341287,341288,341289,341290,341291,341292,341293,341294,341295,341296,341297,341298,341299,341300,341301,341302,341303,341304,341305,341306,341307,341308,341309,341310,341312,341313,341314,341315,341316,341317,341318,341319,341344,341373,341374,341375,341376,341381,341382,341383,341384,341386,341389,341390,341391,341392,341393,341394,341400,341408,341409,341410,341411,341412,341413,341414,341415,341416,341417,341418,341419,341421,342189,343735,343737,343973,344008,344067,345002,346916,347185,348340,348341,348342,348343,348344,348346,348347,348348,348349,348350,348351,348352,348353,348354,348355,348356,348357,348358,348359,348360,348361,348362,348363,348364,348365,348366,348367,348368,348369,348370,348371,348372,348373,348374,348375,348376,348377,348378,348379,348380,348381,348382,348384,348385,348386,348387,348388,348389,348390,348391,348392,348393,348394,348395,348396,348397,348398,348399,348400,348401,348402,348403,348404,348405,348406,348407,348408,348409,348410,348411,348412,348414,348415,348416,348417,348418,348419,348420,348421,348422,348423,348424,348425,348426,348427,348428,348429,348430,348431,348432,348433,348434,348435,348436,348437,348438,348439,348440,348441,348442,348443,348444,348445,348446,348447,348448,348449,348450,348451,348452,348453,348454,348455,348456,348457,348458,348459,348460,348461,348462,348463,348464,348465,348466,348468,348470,348471,348472,348473,348474,348475,348476,348477,348478,348479,348480,348957,349220,351854,351890,352033,352659,352660,358358,358423,359802,361559,361927,341194)

select distinct typ from getproducts1 where dept='Firearms' and brand='SAVAGE' 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 (261885,46376,348166,336690,338432,46420,261882,338426,338442,348167,359873,336670,210101,261945,336680,338431,46454,138322,168369,288905,336664,336666,338439,181143,188834,262009,288910,288914,305549,338423,338424,338425,338427,338428,340127,348469,46208,46209,46256,46258,46307,46336,46338,46339,46340,46341,46342,46346,46347,46361,46362,46363,46364,46366,46367,46368,46369,46372,46378,46383,46385,46392,46400,46404,46407,46409,46411,46421,46422,46423,46424,46430,46435,46445,46449,46450,46451,46452,46453,46456,66862,67362,67867,69778,69862,75180,75555,75674,75706,76486,78931,79609,80488,85100,87203,88569,89123,89436,93495,93710,94150,96386,98114,98118,98122,98127,98129,98195,98312,98542,98893,99263,99394,99692,100276,100445,100446,100864,100866,100872,102036,102040,102326,102327,103992,104766,106504,108302,108446,108816,109069,109084,109085,110148,113145,114238,114274,114275,114276,114413,114449,114541,114606,114607,114770,115075,115076,115309,115346,115349,115351,115380,115531,115943,115945,116046,116135,116201,116266,116267,116552,116648,116709,117031,117340,118075,118310,118893,118895,118955,118989,119342,119540,119578,120676,120718,120732,121604,121804,121915,122372,122499,122501,122502,122503,122518,122520,122677,122709,122710,122712,122947,122948,122949,123809,124068,124277,126080,126372,126373,126945,127999,129592,133839,133908,135326,135395,135396,135397,135398,135399,135400,135401,135402,138118,138136,138271,138272,138273,138274,138275,138276,138277,138286,138289,138294,138316,138317,138318,138445,140105,140107,140134,141288,141290,144806,144807,144899,147109,147780,147781,147880,152067,152149,152150,152151,152152,152154,154880,154881,154882,154884,154887,154888,154890,154891,154895,154896,154898,154900,154902,154904,154909,154911,154913,154920,154922,154923,154924,154925,154926,155120,155121,155122,155123,155124,155125,155126,156045,156143,158240,158371,161068,161085,161101,161241,165019,165265,165266,165267,165268,165269,168707,168713,168715,168716,168717,168718,168796,168947,168983,169710,169711,169712,169713,169714,170381,173041,173044,173045,173046,173052,173053,173054,173093,173286,173902,173903,175654,175655,175656,175884,175885,175886,181144,181150,181152,181157,181653,182314,184267,184551,188154,188157,191684,192156,192157,192159,192160,192161,192162,193330,193338,193356,193357,193464,193465,193466,193467,193468,193469,193470,193471,193472,193474,193476,193479,193480,193481,193482,193483,193484,193485,194358,194359,194360,196117,199756,199757,199758,199760,199761,199762,199763,199764,200478,200843,200845,200847,201372,204701,204702,204703,204704,204705,205106,205501,205680,205681,205682,205684,205685,205686,205687,205688,205689,205690,205691,205727,205728,205729,205730,205731,205732,205733,205734,205735,205736,205737,205738,205739,205740,205741,205838,206006,207980,207981,207982,207983,207984,207987,207988,207989,207990,207991,207992,207994,207995,207996,207997,207998,207999,208000,208001,209458,209695,210102,210104,210105,210106,210148,210149,210150,210151,211324,211325,212642,215423,217150,217151,217154,217155,217156,217158,217232,217236,217239,217240,217293,217301,217302,217303,217304,217305,217306,217307,217310,217311,217312,217314,217315,217316,217317,219839,219983,220597,227244,227569,227571,227575,227579,227583,227586,227591,227594,227600,227603,227604,227606,227609,227610,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227936,227937,242374,246929,246930,246931,246932,246933,247181,247184,247185,247187,247188,247189,247190,247191,247192,247193,247194,247195,247196,247197,247198,247199,247200,247201,247202,247203,247204,247206,247208,247209,247210,247211,247212,247213,247214,247218,247219,247220,247221,247222,247223,247224,247225,247226,247227,247561,248409,248410,248417,251116,251117,251567,251569,251570,251571,251572,251573,251574,253258,253259,253260,253262,253264,253367,253518,253519,253520,253533,253534,253535,253599,253600,253603,253604,253605,253606,253607,253989,253990,253991,253992,253993,253994,254103,254104,254480,254483,254485,254486,254487,254488,254489,254491,254493,254494,254496,254497,254498,254499,254500,254501,254504,255291,255292,255295,255297,255483,255605,256418,256419,256420,256421,256422,257118,260604,261509,261806,261807,261808,261809,261810,261818,261820,261821,261876,261880,261881,261884,261946,261947,261948,261960,261964,261967,261969,261970,261971,261972,261975,262010,262011,262013,262014,262015,262922,264017,264018,264019,264020,264043,264645,266212,266213,266697,267742,267763,267767,267769,268500,268501,268504,268525,268527,268528,268530,268538,268542,268543,268545,268546,268548,268549,268550,268552,268557,268558,268559,268560,268561,268562,268568,268569,268570,268573,268574,268576,268577,268579,268580,268582,268583,268584,268585,268587,268589,268590,268591,268592,268593,268594,268595,268596,268602,268649,273470,273565,276672,278717,278718,278719,278720,278721,278722,278723,278727,278728,278729,280139,281066,283237,283240,283858,285366,285447,285529,286236,287055,287056,287958,288183,288184,288916,289023,289100,289388,289423,289687,289693,290100,290102,290108,290123,290473,290503,291713,291860,292005,293019,293042,293043,296374,296452,297300,297301,298824,298929,299141,299149,304799,304800,304801,304802,304803,304804,304805,304915,304916,305544,305545,305546,305547,305552,305553,310333,310339,312248,316719,316741,326342,326343,328583,330671,331052,332640,332645,332650,332664,332764,332765,334178,334917,335169,335208,335209,335212,335213,335222,335623,336205,336661,336672,336674,336675,336677,336678,336683,336687,336692,336696,337713,337715,337720,337722,337788,337980,338063,338429,338430,338433,338443,338445,338446,338449,338450,338452,338706,340784,341111,341142,341143,341144,341145,341153,341156,341157,341158,341159,341160,341161,341162,341163,341164,341165,341166,341167,341168,341169,341170,341171,341172,341173,341174,341175,341176,341177,341178,341179,341180,341181,341182,341183,341184,341185,341186,341187,341188,341189,341190,341191,341192,341193,341195,341196,341197,341198,341199,341200,341201,341202,341203,341204,341205,341206,341207,341208,341209,341210,341211,341212,341214,341215,341216,341217,341218,341219,341220,341221,341222,341224,341225,341226,341227,341228,341229,341230,341231,341232,341233,341234,341235,341236,341237,341238,341239,341240,341241,341242,341243,341244,341245,341246,341247,341248,341249,341251,341252,341253,341254,341255,341256,341257,341258,341259,341260,341261,341262,341263,341264,341265,341266,341267,341268,341269,341270,341271,341272,341273,341274,341275,341276,341277,341278,341279,341280,341281,341282,341283,341284,341285,341286,341287,341288,341289,341290,341291,341292,341293,341294,341295,341296,341297,341298,341299,341300,341301,341302,341303,341304,341305,341306,341307,341308,341309,341310,341312,341313,341314,341315,341316,341317,341318,341319,341344,341373,341374,341375,341376,341381,341382,341383,341384,341386,341389,341390,341391,341392,341393,341394,341400,341408,341409,341410,341411,341412,341413,341414,341415,341416,341417,341418,341419,341421,342189,343735,343737,343973,344008,344067,345002,346916,347185,348340,348341,348342,348343,348344,348346,348347,348348,348349,348350,348351,348352,348353,348354,348355,348356,348357,348358,348359,348360,348361,348362,348363,348364,348365,348366,348367,348368,348369,348370,348371,348372,348373,348374,348375,348376,348377,348378,348379,348380,348381,348382,348384,348385,348386,348387,348388,348389,348390,348391,348392,348393,348394,348395,348396,348397,348398,348399,348400,348401,348402,348403,348404,348405,348406,348407,348408,348409,348410,348411,348412,348414,348415,348416,348417,348418,348419,348420,348421,348422,348423,348424,348425,348426,348427,348428,348429,348430,348431,348432,348433,348434,348435,348436,348437,348438,348439,348440,348441,348442,348443,348444,348445,348446,348447,348448,348449,348450,348451,348452,348453,348454,348455,348456,348457,348458,348459,348460,348461,348462,348463,348464,348465,348466,348468,348470,348471,348472,348473,348474,348475,348476,348477,348478,348479,348480,348957,349220,351854,351890,352033,352659,352660,358358,358423,359802,361559,361927,341194)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='SAVAGE' 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='Rifles 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='Shotguns 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='Hunting' 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 = 2398 and c.style_id in (261885,46376,348166,336690,338432,46420,261882,338426,338442,348167,359873,336670,210101,261945,336680,338431,46454,138322,168369,288905,336664,336666,338439,181143,188834,262009,288910,288914,305549,338423,338424,338425,338427,338428,340127,348469,46208,46209,46256,46258,46307,46336,46338,46339,46340,46341,46342,46346,46347,46361,46362,46363,46364,46366,46367,46368,46369,46372,46378,46383,46385,46392,46400,46404,46407,46409,46411,46421,46422,46423,46424,46430,46435,46445,46449,46450,46451,46452,46453,46456,66862,67362,67867,69778,69862,75180,75555,75674,75706,76486,78931,79609,80488,85100,87203,88569,89123,89436,93495,93710,94150,96386,98114,98118,98122,98127,98129,98195,98312,98542,98893,99263,99394,99692,100276,100445,100446,100864,100866,100872,102036,102040,102326,102327,103992,104766,106504,108302,108446,108816,109069,109084,109085,110148,113145,114238,114274,114275,114276,114413,114449,114541,114606,114607,114770,115075,115076,115309,115346,115349,115351,115380,115531,115943,115945,116046,116135,116201,116266,116267,116552,116648,116709,117031,117340,118075,118310,118893,118895,118955,118989,119342,119540,119578,120676,120718,120732,121604,121804,121915,122372,122499,122501,122502,122503,122518,122520,122677,122709,122710,122712,122947,122948,122949,123809,124068,124277,126080,126372,126373,126945,127999,129592,133839,133908,135326,135395,135396,135397,135398,135399,135400,135401,135402,138118,138136,138271,138272,138273,138274,138275,138276,138277,138286,138289,138294,138316,138317,138318,138445,140105,140107,140134,141288,141290,144806,144807,144899,147109,147780,147781,147880,152067,152149,152150,152151,152152,152154,154880,154881,154882,154884,154887,154888,154890,154891,154895,154896,154898,154900,154902,154904,154909,154911,154913,154920,154922,154923,154924,154925,154926,155120,155121,155122,155123,155124,155125,155126,156045,156143,158240,158371,161068,161085,161101,161241,165019,165265,165266,165267,165268,165269,168707,168713,168715,168716,168717,168718,168796,168947,168983,169710,169711,169712,169713,169714,170381,173041,173044,173045,173046,173052,173053,173054,173093,173286,173902,173903,175654,175655,175656,175884,175885,175886,181144,181150,181152,181157,181653,182314,184267,184551,188154,188157,191684,192156,192157,192159,192160,192161,192162,193330,193338,193356,193357,193464,193465,193466,193467,193468,193469,193470,193471,193472,193474,193476,193479,193480,193481,193482,193483,193484,193485,194358,194359,194360,196117,199756,199757,199758,199760,199761,199762,199763,199764,200478,200843,200845,200847,201372,204701,204702,204703,204704,204705,205106,205501,205680,205681,205682,205684,205685,205686,205687,205688,205689,205690,205691,205727,205728,205729,205730,205731,205732,205733,205734,205735,205736,205737,205738,205739,205740,205741,205838,206006,207980,207981,207982,207983,207984,207987,207988,207989,207990,207991,207992,207994,207995,207996,207997,207998,207999,208000,208001,209458,209695,210102,210104,210105,210106,210148,210149,210150,210151,211324,211325,212642,215423,217150,217151,217154,217155,217156,217158,217232,217236,217239,217240,217293,217301,217302,217303,217304,217305,217306,217307,217310,217311,217312,217314,217315,217316,217317,219839,219983,220597,227244,227569,227571,227575,227579,227583,227586,227591,227594,227600,227603,227604,227606,227609,227610,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227936,227937,242374,246929,246930,246931,246932,246933,247181,247184,247185,247187,247188,247189,247190,247191,247192,247193,247194,247195,247196,247197,247198,247199,247200,247201,247202,247203,247204,247206,247208,247209,247210,247211,247212,247213,247214,247218,247219,247220,247221,247222,247223,247224,247225,247226,247227,247561,248409,248410,248417,251116,251117,251567,251569,251570,251571,251572,251573,251574,253258,253259,253260,253262,253264,253367,253518,253519,253520,253533,253534,253535,253599,253600,253603,253604,253605,253606,253607,253989,253990,253991,253992,253993,253994,254103,254104,254480,254483,254485,254486,254487,254488,254489,254491,254493,254494,254496,254497,254498,254499,254500,254501,254504,255291,255292,255295,255297,255483,255605,256418,256419,256420,256421,256422,257118,260604,261509,261806,261807,261808,261809,261810,261818,261820,261821,261876,261880,261881,261884,261946,261947,261948,261960,261964,261967,261969,261970,261971,261972,261975,262010,262011,262013,262014,262015,262922,264017,264018,264019,264020,264043,264645,266212,266213,266697,267742,267763,267767,267769,268500,268501,268504,268525,268527,268528,268530,268538,268542,268543,268545,268546,268548,268549,268550,268552,268557,268558,268559,268560,268561,268562,268568,268569,268570,268573,268574,268576,268577,268579,268580,268582,268583,268584,268585,268587,268589,268590,268591,268592,268593,268594,268595,268596,268602,268649,273470,273565,276672,278717,278718,278719,278720,278721,278722,278723,278727,278728,278729,280139,281066,283237,283240,283858,285366,285447,285529,286236,287055,287056,287958,288183,288184,288916,289023,289100,289388,289423,289687,289693,290100,290102,290108,290123,290473,290503,291713,291860,292005,293019,293042,293043,296374,296452,297300,297301,298824,298929,299141,299149,304799,304800,304801,304802,304803,304804,304805,304915,304916,305544,305545,305546,305547,305552,305553,310333,310339,312248,316719,316741,326342,326343,328583,330671,331052,332640,332645,332650,332664,332764,332765,334178,334917,335169,335208,335209,335212,335213,335222,335623,336205,336661,336672,336674,336675,336677,336678,336683,336687,336692,336696,337713,337715,337720,337722,337788,337980,338063,338429,338430,338433,338443,338445,338446,338449,338450,338452,338706,340784,341111,341142,341143,341144,341145,341153,341156,341157,341158,341159,341160,341161,341162,341163,341164,341165,341166,341167,341168,341169,341170,341171,341172,341173,341174,341175,341176,341177,341178,341179,341180,341181,341182,341183,341184,341185,341186,341187,341188,341189,341190,341191,341192,341193,341195,341196,341197,341198,341199,341200,341201,341202,341203,341204,341205,341206,341207,341208,341209,341210,341211,341212,341214,341215,341216,341217,341218,341219,341220,341221,341222,341224,341225,341226,341227,341228,341229,341230,341231,341232,341233,341234,341235,341236,341237,341238,341239,341240,341241,341242,341243,341244,341245,341246,341247,341248,341249,341251,341252,341253,341254,341255,341256,341257,341258,341259,341260,341261,341262,341263,341264,341265,341266,341267,341268,341269,341270,341271,341272,341273,341274,341275,341276,341277,341278,341279,341280,341281,341282,341283,341284,341285,341286,341287,341288,341289,341290,341291,341292,341293,341294,341295,341296,341297,341298,341299,341300,341301,341302,341303,341304,341305,341306,341307,341308,341309,341310,341312,341313,341314,341315,341316,341317,341318,341319,341344,341373,341374,341375,341376,341381,341382,341383,341384,341386,341389,341390,341391,341392,341393,341394,341400,341408,341409,341410,341411,341412,341413,341414,341415,341416,341417,341418,341419,341421,342189,343735,343737,343973,344008,344067,345002,346916,347185,348340,348341,348342,348343,348344,348346,348347,348348,348349,348350,348351,348352,348353,348354,348355,348356,348357,348358,348359,348360,348361,348362,348363,348364,348365,348366,348367,348368,348369,348370,348371,348372,348373,348374,348375,348376,348377,348378,348379,348380,348381,348382,348384,348385,348386,348387,348388,348389,348390,348391,348392,348393,348394,348395,348396,348397,348398,348399,348400,348401,348402,348403,348404,348405,348406,348407,348408,348409,348410,348411,348412,348414,348415,348416,348417,348418,348419,348420,348421,348422,348423,348424,348425,348426,348427,348428,348429,348430,348431,348432,348433,348434,348435,348436,348437,348438,348439,348440,348441,348442,348443,348444,348445,348446,348447,348448,348449,348450,348451,348452,348453,348454,348455,348456,348457,348458,348459,348460,348461,348462,348463,348464,348465,348466,348468,348470,348471,348472,348473,348474,348475,348476,348477,348478,348479,348480,348957,349220,351854,351890,352033,352659,352660,358358,358423,359802,361559,361927,341194)

select distinct typ from getproducts1 where dept='Hunting' and brand='SAVAGE' 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='Hunting' and typ='Black Powder' 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='Savage Arms' 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 = 1053 and c.style_id in (261885,46376,348166,336690,338432,46420,261882,338426,338442,348167,359873,336670,210101,261945,336680,338431,46454,138322,168369,288905,336664,336666,338439,181143,188834,262009,288910,288914,305549,338423,338424,338425,338427,338428,340127,348469,46208,46209,46256,46258,46307,46336,46338,46339,46340,46341,46342,46346,46347,46361,46362,46363,46364,46366,46367,46368,46369,46372,46378,46383,46385,46392,46400,46404,46407,46409,46411,46421,46422,46423,46424,46430,46435,46445,46449,46450,46451,46452,46453,46456,66862,67362,67867,69778,69862,75180,75555,75674,75706,76486,78931,79609,80488,85100,87203,88569,89123,89436,93495,93710,94150,96386,98114,98118,98122,98127,98129,98195,98312,98542,98893,99263,99394,99692,100276,100445,100446,100864,100866,100872,102036,102040,102326,102327,103992,104766,106504,108302,108446,108816,109069,109084,109085,110148,113145,114238,114274,114275,114276,114413,114449,114541,114606,114607,114770,115075,115076,115309,115346,115349,115351,115380,115531,115943,115945,116046,116135,116201,116266,116267,116552,116648,116709,117031,117340,118075,118310,118893,118895,118955,118989,119342,119540,119578,120676,120718,120732,121604,121804,121915,122372,122499,122501,122502,122503,122518,122520,122677,122709,122710,122712,122947,122948,122949,123809,124068,124277,126080,126372,126373,126945,127999,129592,133839,133908,135326,135395,135396,135397,135398,135399,135400,135401,135402,138118,138136,138271,138272,138273,138274,138275,138276,138277,138286,138289,138294,138316,138317,138318,138445,140105,140107,140134,141288,141290,144806,144807,144899,147109,147780,147781,147880,152067,152149,152150,152151,152152,152154,154880,154881,154882,154884,154887,154888,154890,154891,154895,154896,154898,154900,154902,154904,154909,154911,154913,154920,154922,154923,154924,154925,154926,155120,155121,155122,155123,155124,155125,155126,156045,156143,158240,158371,161068,161085,161101,161241,165019,165265,165266,165267,165268,165269,168707,168713,168715,168716,168717,168718,168796,168947,168983,169710,169711,169712,169713,169714,170381,173041,173044,173045,173046,173052,173053,173054,173093,173286,173902,173903,175654,175655,175656,175884,175885,175886,181144,181150,181152,181157,181653,182314,184267,184551,188154,188157,191684,192156,192157,192159,192160,192161,192162,193330,193338,193356,193357,193464,193465,193466,193467,193468,193469,193470,193471,193472,193474,193476,193479,193480,193481,193482,193483,193484,193485,194358,194359,194360,196117,199756,199757,199758,199760,199761,199762,199763,199764,200478,200843,200845,200847,201372,204701,204702,204703,204704,204705,205106,205501,205680,205681,205682,205684,205685,205686,205687,205688,205689,205690,205691,205727,205728,205729,205730,205731,205732,205733,205734,205735,205736,205737,205738,205739,205740,205741,205838,206006,207980,207981,207982,207983,207984,207987,207988,207989,207990,207991,207992,207994,207995,207996,207997,207998,207999,208000,208001,209458,209695,210102,210104,210105,210106,210148,210149,210150,210151,211324,211325,212642,215423,217150,217151,217154,217155,217156,217158,217232,217236,217239,217240,217293,217301,217302,217303,217304,217305,217306,217307,217310,217311,217312,217314,217315,217316,217317,219839,219983,220597,227244,227569,227571,227575,227579,227583,227586,227591,227594,227600,227603,227604,227606,227609,227610,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227936,227937,242374,246929,246930,246931,246932,246933,247181,247184,247185,247187,247188,247189,247190,247191,247192,247193,247194,247195,247196,247197,247198,247199,247200,247201,247202,247203,247204,247206,247208,247209,247210,247211,247212,247213,247214,247218,247219,247220,247221,247222,247223,247224,247225,247226,247227,247561,248409,248410,248417,251116,251117,251567,251569,251570,251571,251572,251573,251574,253258,253259,253260,253262,253264,253367,253518,253519,253520,253533,253534,253535,253599,253600,253603,253604,253605,253606,253607,253989,253990,253991,253992,253993,253994,254103,254104,254480,254483,254485,254486,254487,254488,254489,254491,254493,254494,254496,254497,254498,254499,254500,254501,254504,255291,255292,255295,255297,255483,255605,256418,256419,256420,256421,256422,257118,260604,261509,261806,261807,261808,261809,261810,261818,261820,261821,261876,261880,261881,261884,261946,261947,261948,261960,261964,261967,261969,261970,261971,261972,261975,262010,262011,262013,262014,262015,262922,264017,264018,264019,264020,264043,264645,266212,266213,266697,267742,267763,267767,267769,268500,268501,268504,268525,268527,268528,268530,268538,268542,268543,268545,268546,268548,268549,268550,268552,268557,268558,268559,268560,268561,268562,268568,268569,268570,268573,268574,268576,268577,268579,268580,268582,268583,268584,268585,268587,268589,268590,268591,268592,268593,268594,268595,268596,268602,268649,273470,273565,276672,278717,278718,278719,278720,278721,278722,278723,278727,278728,278729,280139,281066,283237,283240,283858,285366,285447,285529,286236,287055,287056,287958,288183,288184,288916,289023,289100,289388,289423,289687,289693,290100,290102,290108,290123,290473,290503,291713,291860,292005,293019,293042,293043,296374,296452,297300,297301,298824,298929,299141,299149,304799,304800,304801,304802,304803,304804,304805,304915,304916,305544,305545,305546,305547,305552,305553,310333,310339,312248,316719,316741,326342,326343,328583,330671,331052,332640,332645,332650,332664,332764,332765,334178,334917,335169,335208,335209,335212,335213,335222,335623,336205,336661,336672,336674,336675,336677,336678,336683,336687,336692,336696,337713,337715,337720,337722,337788,337980,338063,338429,338430,338433,338443,338445,338446,338449,338450,338452,338706,340784,341111,341142,341143,341144,341145,341153,341156,341157,341158,341159,341160,341161,341162,341163,341164,341165,341166,341167,341168,341169,341170,341171,341172,341173,341174,341175,341176,341177,341178,341179,341180,341181,341182,341183,341184,341185,341186,341187,341188,341189,341190,341191,341192,341193,341195,341196,341197,341198,341199,341200,341201,341202,341203,341204,341205,341206,341207,341208,341209,341210,341211,341212,341214,341215,341216,341217,341218,341219,341220,341221,341222,341224,341225,341226,341227,341228,341229,341230,341231,341232,341233,341234,341235,341236,341237,341238,341239,341240,341241,341242,341243,341244,341245,341246,341247,341248,341249,341251,341252,341253,341254,341255,341256,341257,341258,341259,341260,341261,341262,341263,341264,341265,341266,341267,341268,341269,341270,341271,341272,341273,341274,341275,341276,341277,341278,341279,341280,341281,341282,341283,341284,341285,341286,341287,341288,341289,341290,341291,341292,341293,341294,341295,341296,341297,341298,341299,341300,341301,341302,341303,341304,341305,341306,341307,341308,341309,341310,341312,341313,341314,341315,341316,341317,341318,341319,341344,341373,341374,341375,341376,341381,341382,341383,341384,341386,341389,341390,341391,341392,341393,341394,341400,341408,341409,341410,341411,341412,341413,341414,341415,341416,341417,341418,341419,341421,342189,343735,343737,343973,344008,344067,345002,346916,347185,348340,348341,348342,348343,348344,348346,348347,348348,348349,348350,348351,348352,348353,348354,348355,348356,348357,348358,348359,348360,348361,348362,348363,348364,348365,348366,348367,348368,348369,348370,348371,348372,348373,348374,348375,348376,348377,348378,348379,348380,348381,348382,348384,348385,348386,348387,348388,348389,348390,348391,348392,348393,348394,348395,348396,348397,348398,348399,348400,348401,348402,348403,348404,348405,348406,348407,348408,348409,348410,348411,348412,348414,348415,348416,348417,348418,348419,348420,348421,348422,348423,348424,348425,348426,348427,348428,348429,348430,348431,348432,348433,348434,348435,348436,348437,348438,348439,348440,348441,348442,348443,348444,348445,348446,348447,348448,348449,348450,348451,348452,348453,348454,348455,348456,348457,348458,348459,348460,348461,348462,348463,348464,348465,348466,348468,348470,348471,348472,348473,348474,348475,348476,348477,348478,348479,348480,348957,349220,351854,351890,352033,352659,352660,358358,358423,359802,361559,361927,341194)

select distinct typ from getproducts1 where dept='Savage Arms' and brand='SAVAGE' 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='Savage Arms' and typ='Axis 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='Savage Arms' and typ='Centerfire 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='Savage Arms' and typ='MSR 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='Savage Arms' and typ='Model 42 Combination Gun' 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='Savage Arms' and typ='Rimfire Repeater 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='Savage Arms' and typ='Rimfire Single-Shot 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='Savage Arms' and typ='Shotguns' 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='Savage Arms' and typ='Stance Series' and subtyp_1='EMPTY' and site = 'sportsman'

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

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

			from tb_skus a with (nolock)

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

			where a.style_id = 348478 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 = 348478 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 * from tb_product_reviews with (nolock) where style_id=348478  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=348478 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 = 348479 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 = 348479 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 * from tb_product_reviews with (nolock) where style_id=348479  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=348479 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 = 348480 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 = 348480 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 * from tb_product_reviews with (nolock) where style_id=348480  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=348480 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 = 348957 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 = 348957 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 06:15:37' and
end_date >= 'Apr 14, 2026 06:15:37'
and store_id=10 and style_id=348957

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 = 348957 
and (a.start_date<= 'Apr 14, 2026 06:15:37' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:37'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=348957  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=348957 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 = 349220 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 = 349220 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 06:15:37' and
end_date >= 'Apr 14, 2026 06:15:37'
and store_id=10 and style_id=349220

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 = 349220 
and (a.start_date<= 'Apr 14, 2026 06:15:37' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:37'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=349220  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=349220 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 = 351854 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 = 351854 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 06:15:37' and
end_date >= 'Apr 14, 2026 06:15:37'
and store_id=10 and style_id=351854

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 = 351854 
and (a.start_date<= 'Apr 14, 2026 06:15:37' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:37'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=351854  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=351854 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 = 351890 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 = 351890 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 06:15:37' and
end_date >= 'Apr 14, 2026 06:15:37'
and store_id=10 and style_id=351890

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 = 351890 
and (a.start_date<= 'Apr 14, 2026 06:15:37' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:37'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=351890  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=351890 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 = 352033 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 = 352033 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 06:15:37' and
end_date >= 'Apr 14, 2026 06:15:37'
and store_id=10 and style_id=352033

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 = 352033 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=352033  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=352033 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 = 352659 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 = 352659 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=352659

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 = 352659 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=352659  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=352659 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 = 352660 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 = 352660 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=352660

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 = 352660 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=352660  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=352660 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 = 358358 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 = 358358 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=358358

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 = 358358 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=358358  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=358358 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 = 358423 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 = 358423 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=358423

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 = 358423 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=358423  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=358423 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 = 359802 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 = 359802 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=359802

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 = 359802 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=359802  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=359802 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 = 361559 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 = 361559 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 06:15:38' and
end_date >= 'Apr 14, 2026 06:15:38'
and store_id=10 and style_id=361559

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 = 361559 
and (a.start_date<= 'Apr 14, 2026 06:15:38' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:38'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=361559  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=361559 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 = 361927 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 = 361927 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 06:15:39' and
end_date >= 'Apr 14, 2026 06:15:39'
and store_id=10 and style_id=361927

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 = 361927 
and (a.start_date<= 'Apr 14, 2026 06:15:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=361927  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=361927 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 = 341194 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 = 341194 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 06:15:39' and
end_date >= 'Apr 14, 2026 06:15:39'
and store_id=10 and style_id=341194

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 = 341194 
and (a.start_date<= 'Apr 14, 2026 06:15:39' or a.active = 1)
and a.end_date >= 'Apr 14, 2026 06:15:39'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=341194  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=341194 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/66/brand/savage
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/66/brand/savage
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=22873326
cftoken=c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313
hitcount=1
lastvisit={ts '2026-04-14 06:15:33'}
timecreated={ts '2026-04-14 06:15:33'}
urltoken=CFID=22873326&CFTOKEN=c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313

Cookie Variables:
CFID=22873326
CFTOKEN=c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313
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=22873326
cftoken=c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313
cs=/category.cfm/CurrentPage/66/brand/savage
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22873326_c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313
strarray=Array (0)
urltoken=CFID=22873326&CFTOKEN=c9ee747e0053ade6-72E3A177-D4D3-F4CF-357DA085641D0313

URL Parameters:
CLEARANCE=
CurrentPage=66
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=savage
WHATSNEW=
brand=savage