Browning

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-13 17:00:00' AND b.end_date >= '2026-04-13 17: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/13/2026 23:59:00' and a.end_date >= '04/13/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='browning firearms'
	
	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 grandgetproductsbrowningfirearms
		where
		 style_id is not null
            
				and brand='BROWNING FIREARMS'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproductsbrowningfirearms
		where
		 picture_id is not null
            
			
				and brand='BROWNING FIREARMS'
			


order by

min_price

select distinct (dept) as dept from getproducts1 where brand='BROWNING FIREARMS' 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 (356301,356302,276932,276943,262658,302534,356303,247082,360474,10164,133911,189940,262662,360441,360472,360526,360527,360531,262721,262723,262731,276929,276946,360475,360476,164409,178616,197983,205465,206199,262706,262717,276911,276969,287543,302500,321597,321668,321670,321782,360395,360401,360403,360473,360528,360529,360530,360532,215137,9142,9149,9169,10060,10066,10068,10073,10111,10127,10152,10154,10167,10258,10260,10303,10308,10315,10316,10317,78325,94151,94338,94383,99404,99983,107171,109823,109933,110114,110581,111410,112141,113169,116148,118001,118285,118876,118972,119180,121715,121820,122660,122819,122939,124799,124801,125169,125558,125603,125604,126268,128391,129299,130047,130416,131506,132077,132413,132753,132754,133627,134423,136049,137587,138119,138135,138367,138554,138555,138556,138558,138559,138563,138567,138575,138576,138577,138581,138585,138586,144995,148694,150556,153338,154531,155320,155321,155322,155708,157813,158273,158994,159068,161355,161379,161739,163181,163274,163275,164359,164402,164403,164405,164410,170408,170532,171945,171946,173060,173577,175950,176314,176317,178596,178740,178877,178994,179127,179691,183921,183922,189941,189942,189943,189944,189945,189947,189949,189951,189953,190102,192469,193307,195865,196823,197143,197144,197145,197146,197147,197148,197149,197150,197151,197152,197153,197935,197984,197985,197986,198223,198224,198225,200324,200325,200327,200352,200353,201237,201903,202133,202364,203356,203474,203475,203476,203979,204229,204865,204965,205186,205187,205231,205233,205721,205722,205723,205724,205725,205726,206060,206061,206588,206590,207326,207400,207401,207600,207651,207652,207653,207654,207662,207664,207665,207667,207668,207669,207672,207673,208114,208116,208117,213020,213272,213273,213274,213275,213280,213281,213283,213285,213286,213287,213288,213289,213290,213291,213292,215113,215114,215115,215116,215117,215118,215119,215120,215121,215122,215123,215124,215125,215126,215127,215128,215129,215130,215131,215132,215133,215134,215135,215136,215138,215139,215140,215141,215142,215144,215145,215146,215147,215148,215149,215150,215151,215152,215153,215154,215155,220321,220748,220933,220941,220956,222171,222606,233350,233396,233403,233407,233408,233409,233410,233411,233412,233413,233416,233418,233449,233450,233451,233453,233712,233713,233714,245283,247076,247078,247079,247080,247081,247086,247088,247090,247093,247094,247095,247096,247098,247101,247110,247114,247117,247120,247122,247228,247229,247230,247231,247232,247233,247234,247235,247236,247237,251143,251144,251145,251146,251609,251610,251651,251674,253985,254964,260537,260979,261004,261005,262602,262603,262604,262605,262606,262607,262608,262609,262610,262611,262612,262613,262614,262615,262616,262617,262618,262619,262620,262621,262623,262624,262632,262634,262636,262637,262638,262639,262641,262644,262645,262647,262652,262655,262656,262657,262659,262660,262661,262663,262664,262665,262666,262667,262668,262669,262670,262671,262672,262673,262674,262675,262676,262677,262678,262683,262684,262685,262686,262687,262688,262689,262690,262691,262692,262693,262694,262695,262696,262697,262699,262700,262701,262702,262704,262705,262707,262709,262710,262711,262712,262713,262714,262715,262718,262719,262720,262722,262725,262726,262727,262728,262729,262730,262734,262735,262748,262938,268638,269457,270870,271968,271969,272851,272852,272914,272915,276889,276899,276900,276906,276907,276908,276909,276913,276915,276916,276918,276919,276923,276925,276927,276930,276935,276937,276939,276940,276942,276944,276945,276949,276951,276953,276956,276957,276958,276959,276961,276962,276963,276964,276965,276966,276967,276968,277519,278390,280261,280525,280747,280835,281075,281604,281614,281846,283961,283962,283963,283964,283965,283966,283967,285226,285542,286220,286231,286239,286247,287502,287503,287504,287505,287506,287510,287511,287516,287517,287518,287520,287522,287523,287524,287526,287527,287528,287529,287530,287531,287532,287533,287535,287537,287539,287541,287546,289235,289410,289435,289842,290477,291077,292282,300609,301722,302498,302499,302501,302502,302503,302504,302505,302506,302507,302508,302509,302510,302511,302512,302513,302514,302515,302516,302517,302518,302519,302520,302522,302523,302524,302525,302526,302527,302528,302529,302530,302532,302533,303682,304907,304911,304922,309542,321481,321482,321483,321503,321504,321517,321518,321521,321522,321524,321525,321529,321530,321531,321532,321533,321534,321535,321536,321540,321541,321542,321543,321544,321545,321546,321548,321549,321550,321551,321552,321553,321556,321559,321561,321562,321564,321566,321568,321569,321572,321573,321574,321575,321576,321577,321578,321579,321580,321581,321583,321585,321587,321589,321591,321592,321593,321595,321598,321601,321602,321603,321613,321615,321618,321620,321621,321622,321625,321626,321627,321628,321654,321658,321659,321664,321672,321676,321677,321682,321683,321684,321685,321686,321688,321692,321694,321696,321697,321698,321701,321702,321707,321708,321709,321711,321712,321713,321717,321720,321721,321723,321725,321726,321732,321733,321734,321735,321736,321737,321738,321740,321741,321746,321754,321756,321758,321765,321767,321768,321769,321770,321772,321774,321775,321776,321777,321779,321793,321799,321835,321847,321848,321849,321850,321851,321852,321863,321876,321879,321885,321886,321890,321891,321893,321894,321895,321896,321923,321934,321941,321953,321995,322013,322014,322020,322023,322028,322030,322031,322032,322033,322034,322035,322036,322038,322039,322040,322041,322042,322043,322044,322045,322046,322047,322048,322049,322050,322051,322052,322053,322054,322055,322056,322057,322058,322059,322060,322061,322062,322063,322064,322065,322066,322067,322068,322069,322070,322071,322072,322073,322074,322090,322091,322092,322094,322097,322098,322099,322100,322101,322102,322103,322104,322105,322106,322107,322116,322118,322119,322120,322354,322428,323589,324717,326339,330354,330723,330724,330727,330729,332873,332904,336263,339140,339142,339143,352475,354415,356020,262716,276947)

select distinct typ from getproducts1 where dept='California Guns' and brand='BROWNING FIREARMS' 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, 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 (356301,356302,276932,276943,262658,302534,356303,247082,360474,10164,133911,189940,262662,360441,360472,360526,360527,360531,262721,262723,262731,276929,276946,360475,360476,164409,178616,197983,205465,206199,262706,262717,276911,276969,287543,302500,321597,321668,321670,321782,360395,360401,360403,360473,360528,360529,360530,360532,215137,9142,9149,9169,10060,10066,10068,10073,10111,10127,10152,10154,10167,10258,10260,10303,10308,10315,10316,10317,78325,94151,94338,94383,99404,99983,107171,109823,109933,110114,110581,111410,112141,113169,116148,118001,118285,118876,118972,119180,121715,121820,122660,122819,122939,124799,124801,125169,125558,125603,125604,126268,128391,129299,130047,130416,131506,132077,132413,132753,132754,133627,134423,136049,137587,138119,138135,138367,138554,138555,138556,138558,138559,138563,138567,138575,138576,138577,138581,138585,138586,144995,148694,150556,153338,154531,155320,155321,155322,155708,157813,158273,158994,159068,161355,161379,161739,163181,163274,163275,164359,164402,164403,164405,164410,170408,170532,171945,171946,173060,173577,175950,176314,176317,178596,178740,178877,178994,179127,179691,183921,183922,189941,189942,189943,189944,189945,189947,189949,189951,189953,190102,192469,193307,195865,196823,197143,197144,197145,197146,197147,197148,197149,197150,197151,197152,197153,197935,197984,197985,197986,198223,198224,198225,200324,200325,200327,200352,200353,201237,201903,202133,202364,203356,203474,203475,203476,203979,204229,204865,204965,205186,205187,205231,205233,205721,205722,205723,205724,205725,205726,206060,206061,206588,206590,207326,207400,207401,207600,207651,207652,207653,207654,207662,207664,207665,207667,207668,207669,207672,207673,208114,208116,208117,213020,213272,213273,213274,213275,213280,213281,213283,213285,213286,213287,213288,213289,213290,213291,213292,215113,215114,215115,215116,215117,215118,215119,215120,215121,215122,215123,215124,215125,215126,215127,215128,215129,215130,215131,215132,215133,215134,215135,215136,215138,215139,215140,215141,215142,215144,215145,215146,215147,215148,215149,215150,215151,215152,215153,215154,215155,220321,220748,220933,220941,220956,222171,222606,233350,233396,233403,233407,233408,233409,233410,233411,233412,233413,233416,233418,233449,233450,233451,233453,233712,233713,233714,245283,247076,247078,247079,247080,247081,247086,247088,247090,247093,247094,247095,247096,247098,247101,247110,247114,247117,247120,247122,247228,247229,247230,247231,247232,247233,247234,247235,247236,247237,251143,251144,251145,251146,251609,251610,251651,251674,253985,254964,260537,260979,261004,261005,262602,262603,262604,262605,262606,262607,262608,262609,262610,262611,262612,262613,262614,262615,262616,262617,262618,262619,262620,262621,262623,262624,262632,262634,262636,262637,262638,262639,262641,262644,262645,262647,262652,262655,262656,262657,262659,262660,262661,262663,262664,262665,262666,262667,262668,262669,262670,262671,262672,262673,262674,262675,262676,262677,262678,262683,262684,262685,262686,262687,262688,262689,262690,262691,262692,262693,262694,262695,262696,262697,262699,262700,262701,262702,262704,262705,262707,262709,262710,262711,262712,262713,262714,262715,262718,262719,262720,262722,262725,262726,262727,262728,262729,262730,262734,262735,262748,262938,268638,269457,270870,271968,271969,272851,272852,272914,272915,276889,276899,276900,276906,276907,276908,276909,276913,276915,276916,276918,276919,276923,276925,276927,276930,276935,276937,276939,276940,276942,276944,276945,276949,276951,276953,276956,276957,276958,276959,276961,276962,276963,276964,276965,276966,276967,276968,277519,278390,280261,280525,280747,280835,281075,281604,281614,281846,283961,283962,283963,283964,283965,283966,283967,285226,285542,286220,286231,286239,286247,287502,287503,287504,287505,287506,287510,287511,287516,287517,287518,287520,287522,287523,287524,287526,287527,287528,287529,287530,287531,287532,287533,287535,287537,287539,287541,287546,289235,289410,289435,289842,290477,291077,292282,300609,301722,302498,302499,302501,302502,302503,302504,302505,302506,302507,302508,302509,302510,302511,302512,302513,302514,302515,302516,302517,302518,302519,302520,302522,302523,302524,302525,302526,302527,302528,302529,302530,302532,302533,303682,304907,304911,304922,309542,321481,321482,321483,321503,321504,321517,321518,321521,321522,321524,321525,321529,321530,321531,321532,321533,321534,321535,321536,321540,321541,321542,321543,321544,321545,321546,321548,321549,321550,321551,321552,321553,321556,321559,321561,321562,321564,321566,321568,321569,321572,321573,321574,321575,321576,321577,321578,321579,321580,321581,321583,321585,321587,321589,321591,321592,321593,321595,321598,321601,321602,321603,321613,321615,321618,321620,321621,321622,321625,321626,321627,321628,321654,321658,321659,321664,321672,321676,321677,321682,321683,321684,321685,321686,321688,321692,321694,321696,321697,321698,321701,321702,321707,321708,321709,321711,321712,321713,321717,321720,321721,321723,321725,321726,321732,321733,321734,321735,321736,321737,321738,321740,321741,321746,321754,321756,321758,321765,321767,321768,321769,321770,321772,321774,321775,321776,321777,321779,321793,321799,321835,321847,321848,321849,321850,321851,321852,321863,321876,321879,321885,321886,321890,321891,321893,321894,321895,321896,321923,321934,321941,321953,321995,322013,322014,322020,322023,322028,322030,322031,322032,322033,322034,322035,322036,322038,322039,322040,322041,322042,322043,322044,322045,322046,322047,322048,322049,322050,322051,322052,322053,322054,322055,322056,322057,322058,322059,322060,322061,322062,322063,322064,322065,322066,322067,322068,322069,322070,322071,322072,322073,322074,322090,322091,322092,322094,322097,322098,322099,322100,322101,322102,322103,322104,322105,322106,322107,322116,322118,322119,322120,322354,322428,323589,324717,326339,330354,330723,330724,330727,330729,332873,332904,336263,339140,339142,339143,352475,354415,356020,262716,276947)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='BROWNING FIREARMS' 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='Magazines' 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 (356301,356302,276932,276943,262658,302534,356303,247082,360474,10164,133911,189940,262662,360441,360472,360526,360527,360531,262721,262723,262731,276929,276946,360475,360476,164409,178616,197983,205465,206199,262706,262717,276911,276969,287543,302500,321597,321668,321670,321782,360395,360401,360403,360473,360528,360529,360530,360532,215137,9142,9149,9169,10060,10066,10068,10073,10111,10127,10152,10154,10167,10258,10260,10303,10308,10315,10316,10317,78325,94151,94338,94383,99404,99983,107171,109823,109933,110114,110581,111410,112141,113169,116148,118001,118285,118876,118972,119180,121715,121820,122660,122819,122939,124799,124801,125169,125558,125603,125604,126268,128391,129299,130047,130416,131506,132077,132413,132753,132754,133627,134423,136049,137587,138119,138135,138367,138554,138555,138556,138558,138559,138563,138567,138575,138576,138577,138581,138585,138586,144995,148694,150556,153338,154531,155320,155321,155322,155708,157813,158273,158994,159068,161355,161379,161739,163181,163274,163275,164359,164402,164403,164405,164410,170408,170532,171945,171946,173060,173577,175950,176314,176317,178596,178740,178877,178994,179127,179691,183921,183922,189941,189942,189943,189944,189945,189947,189949,189951,189953,190102,192469,193307,195865,196823,197143,197144,197145,197146,197147,197148,197149,197150,197151,197152,197153,197935,197984,197985,197986,198223,198224,198225,200324,200325,200327,200352,200353,201237,201903,202133,202364,203356,203474,203475,203476,203979,204229,204865,204965,205186,205187,205231,205233,205721,205722,205723,205724,205725,205726,206060,206061,206588,206590,207326,207400,207401,207600,207651,207652,207653,207654,207662,207664,207665,207667,207668,207669,207672,207673,208114,208116,208117,213020,213272,213273,213274,213275,213280,213281,213283,213285,213286,213287,213288,213289,213290,213291,213292,215113,215114,215115,215116,215117,215118,215119,215120,215121,215122,215123,215124,215125,215126,215127,215128,215129,215130,215131,215132,215133,215134,215135,215136,215138,215139,215140,215141,215142,215144,215145,215146,215147,215148,215149,215150,215151,215152,215153,215154,215155,220321,220748,220933,220941,220956,222171,222606,233350,233396,233403,233407,233408,233409,233410,233411,233412,233413,233416,233418,233449,233450,233451,233453,233712,233713,233714,245283,247076,247078,247079,247080,247081,247086,247088,247090,247093,247094,247095,247096,247098,247101,247110,247114,247117,247120,247122,247228,247229,247230,247231,247232,247233,247234,247235,247236,247237,251143,251144,251145,251146,251609,251610,251651,251674,253985,254964,260537,260979,261004,261005,262602,262603,262604,262605,262606,262607,262608,262609,262610,262611,262612,262613,262614,262615,262616,262617,262618,262619,262620,262621,262623,262624,262632,262634,262636,262637,262638,262639,262641,262644,262645,262647,262652,262655,262656,262657,262659,262660,262661,262663,262664,262665,262666,262667,262668,262669,262670,262671,262672,262673,262674,262675,262676,262677,262678,262683,262684,262685,262686,262687,262688,262689,262690,262691,262692,262693,262694,262695,262696,262697,262699,262700,262701,262702,262704,262705,262707,262709,262710,262711,262712,262713,262714,262715,262718,262719,262720,262722,262725,262726,262727,262728,262729,262730,262734,262735,262748,262938,268638,269457,270870,271968,271969,272851,272852,272914,272915,276889,276899,276900,276906,276907,276908,276909,276913,276915,276916,276918,276919,276923,276925,276927,276930,276935,276937,276939,276940,276942,276944,276945,276949,276951,276953,276956,276957,276958,276959,276961,276962,276963,276964,276965,276966,276967,276968,277519,278390,280261,280525,280747,280835,281075,281604,281614,281846,283961,283962,283963,283964,283965,283966,283967,285226,285542,286220,286231,286239,286247,287502,287503,287504,287505,287506,287510,287511,287516,287517,287518,287520,287522,287523,287524,287526,287527,287528,287529,287530,287531,287532,287533,287535,287537,287539,287541,287546,289235,289410,289435,289842,290477,291077,292282,300609,301722,302498,302499,302501,302502,302503,302504,302505,302506,302507,302508,302509,302510,302511,302512,302513,302514,302515,302516,302517,302518,302519,302520,302522,302523,302524,302525,302526,302527,302528,302529,302530,302532,302533,303682,304907,304911,304922,309542,321481,321482,321483,321503,321504,321517,321518,321521,321522,321524,321525,321529,321530,321531,321532,321533,321534,321535,321536,321540,321541,321542,321543,321544,321545,321546,321548,321549,321550,321551,321552,321553,321556,321559,321561,321562,321564,321566,321568,321569,321572,321573,321574,321575,321576,321577,321578,321579,321580,321581,321583,321585,321587,321589,321591,321592,321593,321595,321598,321601,321602,321603,321613,321615,321618,321620,321621,321622,321625,321626,321627,321628,321654,321658,321659,321664,321672,321676,321677,321682,321683,321684,321685,321686,321688,321692,321694,321696,321697,321698,321701,321702,321707,321708,321709,321711,321712,321713,321717,321720,321721,321723,321725,321726,321732,321733,321734,321735,321736,321737,321738,321740,321741,321746,321754,321756,321758,321765,321767,321768,321769,321770,321772,321774,321775,321776,321777,321779,321793,321799,321835,321847,321848,321849,321850,321851,321852,321863,321876,321879,321885,321886,321890,321891,321893,321894,321895,321896,321923,321934,321941,321953,321995,322013,322014,322020,322023,322028,322030,322031,322032,322033,322034,322035,322036,322038,322039,322040,322041,322042,322043,322044,322045,322046,322047,322048,322049,322050,322051,322052,322053,322054,322055,322056,322057,322058,322059,322060,322061,322062,322063,322064,322065,322066,322067,322068,322069,322070,322071,322072,322073,322074,322090,322091,322092,322094,322097,322098,322099,322100,322101,322102,322103,322104,322105,322106,322107,322116,322118,322119,322120,322354,322428,323589,324717,326339,330354,330723,330724,330727,330729,332873,332904,336263,339140,339142,339143,352475,354415,356020,262716,276947)

select distinct typ from getproducts1 where dept='Firearms' and brand='BROWNING FIREARMS' 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='Firearms' and typ='Blemished 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='Firearms' and typ='Bolt Action 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='Firearms' and typ='Handgun Semi-Auto' 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='Firearms' and typ='Lever Action' 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='Firearms' and typ='Semi-Auto 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='Firearms' 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='Firearms' and typ='Used Guns' 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='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 (356301,356302,276932,276943,262658,302534,356303,247082,360474,10164,133911,189940,262662,360441,360472,360526,360527,360531,262721,262723,262731,276929,276946,360475,360476,164409,178616,197983,205465,206199,262706,262717,276911,276969,287543,302500,321597,321668,321670,321782,360395,360401,360403,360473,360528,360529,360530,360532,215137,9142,9149,9169,10060,10066,10068,10073,10111,10127,10152,10154,10167,10258,10260,10303,10308,10315,10316,10317,78325,94151,94338,94383,99404,99983,107171,109823,109933,110114,110581,111410,112141,113169,116148,118001,118285,118876,118972,119180,121715,121820,122660,122819,122939,124799,124801,125169,125558,125603,125604,126268,128391,129299,130047,130416,131506,132077,132413,132753,132754,133627,134423,136049,137587,138119,138135,138367,138554,138555,138556,138558,138559,138563,138567,138575,138576,138577,138581,138585,138586,144995,148694,150556,153338,154531,155320,155321,155322,155708,157813,158273,158994,159068,161355,161379,161739,163181,163274,163275,164359,164402,164403,164405,164410,170408,170532,171945,171946,173060,173577,175950,176314,176317,178596,178740,178877,178994,179127,179691,183921,183922,189941,189942,189943,189944,189945,189947,189949,189951,189953,190102,192469,193307,195865,196823,197143,197144,197145,197146,197147,197148,197149,197150,197151,197152,197153,197935,197984,197985,197986,198223,198224,198225,200324,200325,200327,200352,200353,201237,201903,202133,202364,203356,203474,203475,203476,203979,204229,204865,204965,205186,205187,205231,205233,205721,205722,205723,205724,205725,205726,206060,206061,206588,206590,207326,207400,207401,207600,207651,207652,207653,207654,207662,207664,207665,207667,207668,207669,207672,207673,208114,208116,208117,213020,213272,213273,213274,213275,213280,213281,213283,213285,213286,213287,213288,213289,213290,213291,213292,215113,215114,215115,215116,215117,215118,215119,215120,215121,215122,215123,215124,215125,215126,215127,215128,215129,215130,215131,215132,215133,215134,215135,215136,215138,215139,215140,215141,215142,215144,215145,215146,215147,215148,215149,215150,215151,215152,215153,215154,215155,220321,220748,220933,220941,220956,222171,222606,233350,233396,233403,233407,233408,233409,233410,233411,233412,233413,233416,233418,233449,233450,233451,233453,233712,233713,233714,245283,247076,247078,247079,247080,247081,247086,247088,247090,247093,247094,247095,247096,247098,247101,247110,247114,247117,247120,247122,247228,247229,247230,247231,247232,247233,247234,247235,247236,247237,251143,251144,251145,251146,251609,251610,251651,251674,253985,254964,260537,260979,261004,261005,262602,262603,262604,262605,262606,262607,262608,262609,262610,262611,262612,262613,262614,262615,262616,262617,262618,262619,262620,262621,262623,262624,262632,262634,262636,262637,262638,262639,262641,262644,262645,262647,262652,262655,262656,262657,262659,262660,262661,262663,262664,262665,262666,262667,262668,262669,262670,262671,262672,262673,262674,262675,262676,262677,262678,262683,262684,262685,262686,262687,262688,262689,262690,262691,262692,262693,262694,262695,262696,262697,262699,262700,262701,262702,262704,262705,262707,262709,262710,262711,262712,262713,262714,262715,262718,262719,262720,262722,262725,262726,262727,262728,262729,262730,262734,262735,262748,262938,268638,269457,270870,271968,271969,272851,272852,272914,272915,276889,276899,276900,276906,276907,276908,276909,276913,276915,276916,276918,276919,276923,276925,276927,276930,276935,276937,276939,276940,276942,276944,276945,276949,276951,276953,276956,276957,276958,276959,276961,276962,276963,276964,276965,276966,276967,276968,277519,278390,280261,280525,280747,280835,281075,281604,281614,281846,283961,283962,283963,283964,283965,283966,283967,285226,285542,286220,286231,286239,286247,287502,287503,287504,287505,287506,287510,287511,287516,287517,287518,287520,287522,287523,287524,287526,287527,287528,287529,287530,287531,287532,287533,287535,287537,287539,287541,287546,289235,289410,289435,289842,290477,291077,292282,300609,301722,302498,302499,302501,302502,302503,302504,302505,302506,302507,302508,302509,302510,302511,302512,302513,302514,302515,302516,302517,302518,302519,302520,302522,302523,302524,302525,302526,302527,302528,302529,302530,302532,302533,303682,304907,304911,304922,309542,321481,321482,321483,321503,321504,321517,321518,321521,321522,321524,321525,321529,321530,321531,321532,321533,321534,321535,321536,321540,321541,321542,321543,321544,321545,321546,321548,321549,321550,321551,321552,321553,321556,321559,321561,321562,321564,321566,321568,321569,321572,321573,321574,321575,321576,321577,321578,321579,321580,321581,321583,321585,321587,321589,321591,321592,321593,321595,321598,321601,321602,321603,321613,321615,321618,321620,321621,321622,321625,321626,321627,321628,321654,321658,321659,321664,321672,321676,321677,321682,321683,321684,321685,321686,321688,321692,321694,321696,321697,321698,321701,321702,321707,321708,321709,321711,321712,321713,321717,321720,321721,321723,321725,321726,321732,321733,321734,321735,321736,321737,321738,321740,321741,321746,321754,321756,321758,321765,321767,321768,321769,321770,321772,321774,321775,321776,321777,321779,321793,321799,321835,321847,321848,321849,321850,321851,321852,321863,321876,321879,321885,321886,321890,321891,321893,321894,321895,321896,321923,321934,321941,321953,321995,322013,322014,322020,322023,322028,322030,322031,322032,322033,322034,322035,322036,322038,322039,322040,322041,322042,322043,322044,322045,322046,322047,322048,322049,322050,322051,322052,322053,322054,322055,322056,322057,322058,322059,322060,322061,322062,322063,322064,322065,322066,322067,322068,322069,322070,322071,322072,322073,322074,322090,322091,322092,322094,322097,322098,322099,322100,322101,322102,322103,322104,322105,322106,322107,322116,322118,322119,322120,322354,322428,323589,324717,326339,330354,330723,330724,330727,330729,332873,332904,336263,339140,339142,339143,352475,354415,356020,262716,276947)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='BROWNING FIREARMS' 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 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 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 = 215115 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 = 215115 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215115

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 = 215115 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215115  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=215115 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 = 215116 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 = 215116 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215116

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 = 215116 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215116  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=215116 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 = 215117 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 = 215117 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215117

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 = 215117 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215117  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=215117 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 = 215118 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 = 215118 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215118

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 = 215118 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215118  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=215118 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 = 215119 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 = 215119 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215119

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 = 215119 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215119  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=215119 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 = 215120 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 = 215120 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215120

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 = 215120 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215120  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=215120 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 = 215121 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 = 215121 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215121

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 = 215121 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215121  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=215121 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 = 215122 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 = 215122 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 13, 2026 17:10:11' and
end_date >= 'Apr 13, 2026 17:10:11'
and store_id=10 and style_id=215122

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 = 215122 
and (a.start_date<= 'Apr 13, 2026 17:10:11' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:11'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215122  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=215122 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 = 215123 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 = 215123 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215123

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 = 215123 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215123  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=215123 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 = 215124 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 = 215124 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215124

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 = 215124 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215124  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=215124 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 = 215125 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 = 215125 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215125

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 = 215125 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215125  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=215125 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 = 215126 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 = 215126 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215126

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 = 215126 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215126  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=215126 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 = 215127 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 = 215127 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215127

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 = 215127 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215127  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=215127 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 = 215128 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 = 215128 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215128

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 = 215128 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215128  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=215128 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 = 215129 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 = 215129 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215129

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 = 215129 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215129  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=215129 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 = 215130 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 = 215130 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215130

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 = 215130 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215130  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=215130 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 = 215131 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 = 215131 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215131

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 = 215131 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215131  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=215131 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 = 215132 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 = 215132 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 13, 2026 17:10:12' and
end_date >= 'Apr 13, 2026 17:10:12'
and store_id=10 and style_id=215132

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 = 215132 
and (a.start_date<= 'Apr 13, 2026 17:10:12' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 17:10:12'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=215132  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=215132 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/16/brand/browning%20firearms
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/16/brand/browning firearms
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=22858132
cftoken=a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5
hitcount=1
lastvisit={ts '2026-04-13 17:10:10'}
timecreated={ts '2026-04-13 17:10:10'}
urltoken=CFID=22858132&CFTOKEN=a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5

Cookie Variables:
CFID=22858132
CFTOKEN=a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5
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=22858132
cftoken=a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5
cs=/category.cfm/CurrentPage/16/brand/browning firearms
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22858132_a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5
strarray=Array (0)
urltoken=CFID=22858132&CFTOKEN=a717b2aaee9632f-56CD817A-C09A-B290-AA4950D16BADA1B5

URL Parameters:
CLEARANCE=
CurrentPage=16
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=browningfirearms
WHATSNEW=
brand=browning firearms