Taurus

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 23:00:00' AND b.end_date >= '2026-04-13 23: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='taurus'
	
	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 grandgetproductstaurus
		where
		 style_id is not null
            
				and brand='TAURUS'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproductstaurus
		where
		 picture_id is not null
            
			
				and brand='TAURUS'
			


order by

min_price

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

select distinct (dept) as dept from getproducts1 where brand='TAURUS' 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 (251464,217249,250965,358879,305051,53949,334958,257266,257267,331223,336139,251742,336141,336144,361189,336142,336145,353252,289970,53948,114645,247485,260920,357545,336143,353253,336146,113766,227302,247488,353254,53961,104468,289968,305046,335224,203917,359558,219800,219801,257275,286677,326187,326188,352102,358890,361774,361858,361878,362437,53818,53820,53824,53827,53858,53889,53894,53912,53913,53918,53919,53925,53929,53930,53933,53934,53936,53937,53951,53952,53956,53960,53979,53992,53993,53999,54029,54035,54036,54038,54041,54043,54047,67732,68234,68533,68534,68542,74911,75339,77853,84067,85328,88519,91163,92720,100606,101456,107012,107665,108023,108208,110962,111156,112321,113146,113147,113522,114644,115104,115910,116155,116655,116993,117195,119052,119158,120925,121157,121166,121990,122799,122870,124355,124764,125065,125609,126262,126525,128453,128633,129542,134711,135306,136382,143149,151395,151733,152539,153046,153292,153354,153356,153357,155212,155215,155216,157874,169862,178654,184300,189788,189789,189790,189791,189792,189796,189798,189799,189800,189802,189803,189903,191514,191688,192360,192361,192606,193096,193098,193099,193101,193102,193103,193104,193105,193106,193107,193108,193109,193110,193113,193115,193117,193119,193120,193121,193122,193123,193124,193125,193127,193129,193130,193131,193132,193133,193137,193138,193291,195887,196073,197136,197138,197139,197140,197141,198160,199036,200030,201673,201765,205184,205643,205644,205645,205646,205647,205648,205649,205652,205653,205654,205655,205976,206320,206321,206749,206981,206983,207752,207954,208272,210660,210661,210662,210663,210664,210665,210666,210667,210668,210669,210670,210671,210672,210673,210674,210675,212031,214317,214886,215163,215164,216628,217251,217252,217253,217257,217258,217706,217707,217776,217777,217778,217779,217780,217781,217782,217982,219799,219802,219803,219804,219938,220055,220544,220567,220568,220569,220570,220595,220596,220888,220890,220892,220924,220950,221015,221023,221029,221037,221042,222481,222534,222535,222565,222573,222574,222575,222584,222650,223174,223175,223176,225266,225268,225273,225293,225302,225314,225315,225317,225324,225328,225343,227134,227151,227153,227154,228019,228020,228021,228052,228179,228587,242378,242387,242409,247435,247437,247438,247439,247441,247457,247458,247459,247460,247461,247462,247464,247465,247466,247467,247468,247469,247470,247471,247472,247473,247475,247476,247477,247478,247480,247482,247483,247484,247487,247490,247491,247493,247494,247495,247498,247499,247500,247501,247502,247535,247544,247549,247550,247551,247742,247746,247748,247750,247785,247787,247788,247795,247805,247811,248890,248891,251454,251455,251457,251459,251461,251462,251463,251613,251733,251734,251979,253446,253735,253738,253743,253746,254161,254162,255256,255884,257263,257264,257265,257268,257274,257276,257277,257278,257279,257280,257281,257284,257285,257286,257287,257288,257289,257290,257294,257295,257296,260631,260908,260910,260926,260927,260937,260938,260939,260940,260941,261118,264161,264163,264164,264176,264177,264182,266287,266473,266751,267031,267033,267216,267218,267220,267304,268307,268310,268317,268319,268320,268322,268324,268325,268329,268340,268342,268343,268346,268348,268350,268352,268357,268873,268874,268978,269017,269022,269074,271562,271807,271808,272954,272955,273793,273929,274099,274107,274109,274642,274643,274644,274645,276052,276158,276159,277025,277026,277027,277028,277029,277030,277031,277032,277873,277922,277923,277924,278355,278401,278928,279023,279267,279473,279960,279961,279972,279975,279976,279980,279983,279990,280005,280009,280021,280022,280171,280183,280191,280197,280322,280324,280335,280336,280437,280825,280826,280832,280838,280847,280848,280849,280850,280858,280859,280861,280871,280875,281202,281345,281346,281364,281367,281373,281378,281379,281380,281387,281428,281458,281459,281494,281495,281496,281497,281498,281765,282030,282110,282177,282645,282646,282647,282648,282649,282650,282651,282682,282742,282743,282746,282748,282749,282951,282952,283367,283412,283413,283721,284193,285291,285292,285300,285373,285389,285399,285411,285418,285421,285424,285429,285435,285437,285438,285499,285500,285502,285516,285767,285778,285782,285807,285814,285816,285817,285822,285823,285833,285852,285874,285923,285929,285950,285967,286228,286279,286282,286664,286665,286666,286668,286669,286670,286673,286674,286675,286676,287906,287907,287909,287917,287929,287931,288046,288080,288147,288589,289003,289320,289332,289346,289735,289759,289959,289960,289961,289962,289963,289964,289965,289967,289971,290596,290658,290674,290680,290683,290688,290695,290705,290713,290718,290722,290725,290731,290738,290759,290763,290766,290770,290776,290785,290789,290793,290795,290798,290800,290802,290810,290814,290818,291060,291082,291874,292981,293053,293088,293092,293093,293094,293095,293096,293098,293099,293100,293101,293103,293104,293151,293156,293163,293166,293167,293168,293169,293170,293171,293172,293174,293175,293176,293177,293178,293180,293181,293183,293193,293194,293195,293196,293197,293199,293200,293201,293202,293204,293205,293208,293222,293226,293227,293228,293229,293233,293234,293235,293236,293237,293238,293239,293240,293241,293242,293243,293244,293245,293246,293247,293248,293249,293250,293251,293252,293253,293254,293255,293256,293257,293258,293259,293260,293261,293404,294870,294928,294936,294957,294963,294964,296458,296467,296568,296595,296601,296602,296603,296604,296605,296606,296615,297362,297368,297369,297380,297381,297402,297404,297405,297406,297409,297412,297517,297518,297519,297520,297521,297522,297523,297524,297585,297586,297587,297941,297942,297943,298685,298686,298702,298715,298749,298751,298957,298958,298960,298964,298967,298997,299009,299012,299032,299035,299037,299042,299047,299049,299055,299072,299206,299306,300594,300614,301143,301146,303111,303112,303262,303263,303613,303615,305036,305037,305039,305040,305043,305044,305045,305048,305049,305050,305055,305059,305072,305075,305095,305128,305571,305591,307694,307697,307721,307727,307739,307755,307782,307787,307794,307803,307808,307809,307878,307881,307883,307884,307887,307895,307898,309301,309305,309322,309340,309349,309489,309491,309533,309622,309627,309643,309732,310203,310204,310205,310207,310218,310328,310783,310791,310826,310827,311131,311639,311642,312397,312398,312403,312420,316653,316664,316666,322559,323952,324474,324741,324744,324745,324746,324749,324778,324802,324824,324840,324845,324849,324853,324881,325009,325110,325144,325161,325208,325303,326288,326296,326309,326317,326329,326532,326535,326538,326540,326542,326549,326563,329042,329556,329570,329741,329744,329808,330666,330802,330804,330807,330808,330953,330959,330962,330965,330967,330974,330975,330983,330985,330988,331002,331005,331006,331007,331008,331009,331011,331012,331013,331014,331043,331096,331109,331121,331122,331128,331130,331132,331139,332221,332283,332304,332308,332340,332789,332808,332828,332844,332870,332921,332927,333089,333090,333094,333098,333101,333102,333104,333176,333604,333605,333610,333611,333887,333926,333927,333928,334097,334098,334099,334101,334103,335218,336140,336156,336158,336161,336162,336163,336165,336166,336168,336169,336221,336226,336278,336281,336284,336303,336304,336305,336306,336307,336399,336400,336410,336425,336433,336476,336477,336772,336774,336775,336869,336895,337342,337365,337369,337370,337371,337377,337380,337387,337388,337406,337407,337416,337811,337818,337869,337879,338058,338667,338816,338817,338818,338820,338821,338822,338823,338824,338825,340456,340651,340664,340665,340669,340682,340687,340731,340733,340745,340750,340870,341119,341124,341135,342203,342945,342946,343112,343114,343115,343116,343120,343121,343301,343404,343675,344032,344042,344159,344474,344688,344689,344690,344691,344692,344693,344694,344695,344696,344697,344698,344699,344700,344701,344703,344704,344705,344706,344707,344708,344710,344711,344712,345059,345086,345089,345093,345098,345100,345103,345104,345106,345109,345112,345115,345118,345122,345124,346846,346850,346852,346853,346858,346859,346860,346862,346863,346903,346904,346991,346993,347003,347097,347099,347100,347101,347102,347103,347104,347105,347106,347107,347108,347109,347111,347112,347283,347288,348036,348037,348038,348040,348041,348042,348043,348044,348045,348046,348047,348048,348049,348336,348492,348498,348507,348510,348512,348727,348857,348858,348896,348898,349223,349759,349787,349788,349789,349790,349791,351883,351916,351921,351924,351925,351934,351935,351938,351939,351940,351942,352101,352305,352308,352489,352722,352724,352727,352737,352739,352740,352743,352746,352747,352750,352751,353210,353939,353944,353945,354163,354431,354459,354466,354487,354491,354502,354999,355000,355011,355012,355013,355205,355206,355207,355208,355209,355210,355211,355212,355213,355214,355415,355933,355934,355935,355936,355937,355938,356053,356054,356055,356056,356057,356058,356616,356617,356638,356643,356646,356648,356664,356665,357385,357386,357387,357389,357401,357431,358331,358332,358333,358783,358815,358891,359683,359684,359685,359746,359753,359820,359984,360275,360286,360722,360723,360724,360729,360731,360761,360771,360776,360785,360846,360848,360851,360980,361001,361006,361008,361565,361568,361569,361649,361737,361738,362039,362048,362432,362436,362438,362442,358865,361874,330667)

select distinct typ from getproducts1 where dept='California Guns' and brand='TAURUS' 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 (251464,217249,250965,358879,305051,53949,334958,257266,257267,331223,336139,251742,336141,336144,361189,336142,336145,353252,289970,53948,114645,247485,260920,357545,336143,353253,336146,113766,227302,247488,353254,53961,104468,289968,305046,335224,203917,359558,219800,219801,257275,286677,326187,326188,352102,358890,361774,361858,361878,362437,53818,53820,53824,53827,53858,53889,53894,53912,53913,53918,53919,53925,53929,53930,53933,53934,53936,53937,53951,53952,53956,53960,53979,53992,53993,53999,54029,54035,54036,54038,54041,54043,54047,67732,68234,68533,68534,68542,74911,75339,77853,84067,85328,88519,91163,92720,100606,101456,107012,107665,108023,108208,110962,111156,112321,113146,113147,113522,114644,115104,115910,116155,116655,116993,117195,119052,119158,120925,121157,121166,121990,122799,122870,124355,124764,125065,125609,126262,126525,128453,128633,129542,134711,135306,136382,143149,151395,151733,152539,153046,153292,153354,153356,153357,155212,155215,155216,157874,169862,178654,184300,189788,189789,189790,189791,189792,189796,189798,189799,189800,189802,189803,189903,191514,191688,192360,192361,192606,193096,193098,193099,193101,193102,193103,193104,193105,193106,193107,193108,193109,193110,193113,193115,193117,193119,193120,193121,193122,193123,193124,193125,193127,193129,193130,193131,193132,193133,193137,193138,193291,195887,196073,197136,197138,197139,197140,197141,198160,199036,200030,201673,201765,205184,205643,205644,205645,205646,205647,205648,205649,205652,205653,205654,205655,205976,206320,206321,206749,206981,206983,207752,207954,208272,210660,210661,210662,210663,210664,210665,210666,210667,210668,210669,210670,210671,210672,210673,210674,210675,212031,214317,214886,215163,215164,216628,217251,217252,217253,217257,217258,217706,217707,217776,217777,217778,217779,217780,217781,217782,217982,219799,219802,219803,219804,219938,220055,220544,220567,220568,220569,220570,220595,220596,220888,220890,220892,220924,220950,221015,221023,221029,221037,221042,222481,222534,222535,222565,222573,222574,222575,222584,222650,223174,223175,223176,225266,225268,225273,225293,225302,225314,225315,225317,225324,225328,225343,227134,227151,227153,227154,228019,228020,228021,228052,228179,228587,242378,242387,242409,247435,247437,247438,247439,247441,247457,247458,247459,247460,247461,247462,247464,247465,247466,247467,247468,247469,247470,247471,247472,247473,247475,247476,247477,247478,247480,247482,247483,247484,247487,247490,247491,247493,247494,247495,247498,247499,247500,247501,247502,247535,247544,247549,247550,247551,247742,247746,247748,247750,247785,247787,247788,247795,247805,247811,248890,248891,251454,251455,251457,251459,251461,251462,251463,251613,251733,251734,251979,253446,253735,253738,253743,253746,254161,254162,255256,255884,257263,257264,257265,257268,257274,257276,257277,257278,257279,257280,257281,257284,257285,257286,257287,257288,257289,257290,257294,257295,257296,260631,260908,260910,260926,260927,260937,260938,260939,260940,260941,261118,264161,264163,264164,264176,264177,264182,266287,266473,266751,267031,267033,267216,267218,267220,267304,268307,268310,268317,268319,268320,268322,268324,268325,268329,268340,268342,268343,268346,268348,268350,268352,268357,268873,268874,268978,269017,269022,269074,271562,271807,271808,272954,272955,273793,273929,274099,274107,274109,274642,274643,274644,274645,276052,276158,276159,277025,277026,277027,277028,277029,277030,277031,277032,277873,277922,277923,277924,278355,278401,278928,279023,279267,279473,279960,279961,279972,279975,279976,279980,279983,279990,280005,280009,280021,280022,280171,280183,280191,280197,280322,280324,280335,280336,280437,280825,280826,280832,280838,280847,280848,280849,280850,280858,280859,280861,280871,280875,281202,281345,281346,281364,281367,281373,281378,281379,281380,281387,281428,281458,281459,281494,281495,281496,281497,281498,281765,282030,282110,282177,282645,282646,282647,282648,282649,282650,282651,282682,282742,282743,282746,282748,282749,282951,282952,283367,283412,283413,283721,284193,285291,285292,285300,285373,285389,285399,285411,285418,285421,285424,285429,285435,285437,285438,285499,285500,285502,285516,285767,285778,285782,285807,285814,285816,285817,285822,285823,285833,285852,285874,285923,285929,285950,285967,286228,286279,286282,286664,286665,286666,286668,286669,286670,286673,286674,286675,286676,287906,287907,287909,287917,287929,287931,288046,288080,288147,288589,289003,289320,289332,289346,289735,289759,289959,289960,289961,289962,289963,289964,289965,289967,289971,290596,290658,290674,290680,290683,290688,290695,290705,290713,290718,290722,290725,290731,290738,290759,290763,290766,290770,290776,290785,290789,290793,290795,290798,290800,290802,290810,290814,290818,291060,291082,291874,292981,293053,293088,293092,293093,293094,293095,293096,293098,293099,293100,293101,293103,293104,293151,293156,293163,293166,293167,293168,293169,293170,293171,293172,293174,293175,293176,293177,293178,293180,293181,293183,293193,293194,293195,293196,293197,293199,293200,293201,293202,293204,293205,293208,293222,293226,293227,293228,293229,293233,293234,293235,293236,293237,293238,293239,293240,293241,293242,293243,293244,293245,293246,293247,293248,293249,293250,293251,293252,293253,293254,293255,293256,293257,293258,293259,293260,293261,293404,294870,294928,294936,294957,294963,294964,296458,296467,296568,296595,296601,296602,296603,296604,296605,296606,296615,297362,297368,297369,297380,297381,297402,297404,297405,297406,297409,297412,297517,297518,297519,297520,297521,297522,297523,297524,297585,297586,297587,297941,297942,297943,298685,298686,298702,298715,298749,298751,298957,298958,298960,298964,298967,298997,299009,299012,299032,299035,299037,299042,299047,299049,299055,299072,299206,299306,300594,300614,301143,301146,303111,303112,303262,303263,303613,303615,305036,305037,305039,305040,305043,305044,305045,305048,305049,305050,305055,305059,305072,305075,305095,305128,305571,305591,307694,307697,307721,307727,307739,307755,307782,307787,307794,307803,307808,307809,307878,307881,307883,307884,307887,307895,307898,309301,309305,309322,309340,309349,309489,309491,309533,309622,309627,309643,309732,310203,310204,310205,310207,310218,310328,310783,310791,310826,310827,311131,311639,311642,312397,312398,312403,312420,316653,316664,316666,322559,323952,324474,324741,324744,324745,324746,324749,324778,324802,324824,324840,324845,324849,324853,324881,325009,325110,325144,325161,325208,325303,326288,326296,326309,326317,326329,326532,326535,326538,326540,326542,326549,326563,329042,329556,329570,329741,329744,329808,330666,330802,330804,330807,330808,330953,330959,330962,330965,330967,330974,330975,330983,330985,330988,331002,331005,331006,331007,331008,331009,331011,331012,331013,331014,331043,331096,331109,331121,331122,331128,331130,331132,331139,332221,332283,332304,332308,332340,332789,332808,332828,332844,332870,332921,332927,333089,333090,333094,333098,333101,333102,333104,333176,333604,333605,333610,333611,333887,333926,333927,333928,334097,334098,334099,334101,334103,335218,336140,336156,336158,336161,336162,336163,336165,336166,336168,336169,336221,336226,336278,336281,336284,336303,336304,336305,336306,336307,336399,336400,336410,336425,336433,336476,336477,336772,336774,336775,336869,336895,337342,337365,337369,337370,337371,337377,337380,337387,337388,337406,337407,337416,337811,337818,337869,337879,338058,338667,338816,338817,338818,338820,338821,338822,338823,338824,338825,340456,340651,340664,340665,340669,340682,340687,340731,340733,340745,340750,340870,341119,341124,341135,342203,342945,342946,343112,343114,343115,343116,343120,343121,343301,343404,343675,344032,344042,344159,344474,344688,344689,344690,344691,344692,344693,344694,344695,344696,344697,344698,344699,344700,344701,344703,344704,344705,344706,344707,344708,344710,344711,344712,345059,345086,345089,345093,345098,345100,345103,345104,345106,345109,345112,345115,345118,345122,345124,346846,346850,346852,346853,346858,346859,346860,346862,346863,346903,346904,346991,346993,347003,347097,347099,347100,347101,347102,347103,347104,347105,347106,347107,347108,347109,347111,347112,347283,347288,348036,348037,348038,348040,348041,348042,348043,348044,348045,348046,348047,348048,348049,348336,348492,348498,348507,348510,348512,348727,348857,348858,348896,348898,349223,349759,349787,349788,349789,349790,349791,351883,351916,351921,351924,351925,351934,351935,351938,351939,351940,351942,352101,352305,352308,352489,352722,352724,352727,352737,352739,352740,352743,352746,352747,352750,352751,353210,353939,353944,353945,354163,354431,354459,354466,354487,354491,354502,354999,355000,355011,355012,355013,355205,355206,355207,355208,355209,355210,355211,355212,355213,355214,355415,355933,355934,355935,355936,355937,355938,356053,356054,356055,356056,356057,356058,356616,356617,356638,356643,356646,356648,356664,356665,357385,357386,357387,357389,357401,357431,358331,358332,358333,358783,358815,358891,359683,359684,359685,359746,359753,359820,359984,360275,360286,360722,360723,360724,360729,360731,360761,360771,360776,360785,360846,360848,360851,360980,361001,361006,361008,361565,361568,361569,361649,361737,361738,362039,362048,362432,362436,362438,362442,358865,361874,330667)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='TAURUS' 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='Gun Parts' and subtyp_1='EMPTY' and site = 'sportsman'

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

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

select web_url, picture_id, 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 (251464,217249,250965,358879,305051,53949,334958,257266,257267,331223,336139,251742,336141,336144,361189,336142,336145,353252,289970,53948,114645,247485,260920,357545,336143,353253,336146,113766,227302,247488,353254,53961,104468,289968,305046,335224,203917,359558,219800,219801,257275,286677,326187,326188,352102,358890,361774,361858,361878,362437,53818,53820,53824,53827,53858,53889,53894,53912,53913,53918,53919,53925,53929,53930,53933,53934,53936,53937,53951,53952,53956,53960,53979,53992,53993,53999,54029,54035,54036,54038,54041,54043,54047,67732,68234,68533,68534,68542,74911,75339,77853,84067,85328,88519,91163,92720,100606,101456,107012,107665,108023,108208,110962,111156,112321,113146,113147,113522,114644,115104,115910,116155,116655,116993,117195,119052,119158,120925,121157,121166,121990,122799,122870,124355,124764,125065,125609,126262,126525,128453,128633,129542,134711,135306,136382,143149,151395,151733,152539,153046,153292,153354,153356,153357,155212,155215,155216,157874,169862,178654,184300,189788,189789,189790,189791,189792,189796,189798,189799,189800,189802,189803,189903,191514,191688,192360,192361,192606,193096,193098,193099,193101,193102,193103,193104,193105,193106,193107,193108,193109,193110,193113,193115,193117,193119,193120,193121,193122,193123,193124,193125,193127,193129,193130,193131,193132,193133,193137,193138,193291,195887,196073,197136,197138,197139,197140,197141,198160,199036,200030,201673,201765,205184,205643,205644,205645,205646,205647,205648,205649,205652,205653,205654,205655,205976,206320,206321,206749,206981,206983,207752,207954,208272,210660,210661,210662,210663,210664,210665,210666,210667,210668,210669,210670,210671,210672,210673,210674,210675,212031,214317,214886,215163,215164,216628,217251,217252,217253,217257,217258,217706,217707,217776,217777,217778,217779,217780,217781,217782,217982,219799,219802,219803,219804,219938,220055,220544,220567,220568,220569,220570,220595,220596,220888,220890,220892,220924,220950,221015,221023,221029,221037,221042,222481,222534,222535,222565,222573,222574,222575,222584,222650,223174,223175,223176,225266,225268,225273,225293,225302,225314,225315,225317,225324,225328,225343,227134,227151,227153,227154,228019,228020,228021,228052,228179,228587,242378,242387,242409,247435,247437,247438,247439,247441,247457,247458,247459,247460,247461,247462,247464,247465,247466,247467,247468,247469,247470,247471,247472,247473,247475,247476,247477,247478,247480,247482,247483,247484,247487,247490,247491,247493,247494,247495,247498,247499,247500,247501,247502,247535,247544,247549,247550,247551,247742,247746,247748,247750,247785,247787,247788,247795,247805,247811,248890,248891,251454,251455,251457,251459,251461,251462,251463,251613,251733,251734,251979,253446,253735,253738,253743,253746,254161,254162,255256,255884,257263,257264,257265,257268,257274,257276,257277,257278,257279,257280,257281,257284,257285,257286,257287,257288,257289,257290,257294,257295,257296,260631,260908,260910,260926,260927,260937,260938,260939,260940,260941,261118,264161,264163,264164,264176,264177,264182,266287,266473,266751,267031,267033,267216,267218,267220,267304,268307,268310,268317,268319,268320,268322,268324,268325,268329,268340,268342,268343,268346,268348,268350,268352,268357,268873,268874,268978,269017,269022,269074,271562,271807,271808,272954,272955,273793,273929,274099,274107,274109,274642,274643,274644,274645,276052,276158,276159,277025,277026,277027,277028,277029,277030,277031,277032,277873,277922,277923,277924,278355,278401,278928,279023,279267,279473,279960,279961,279972,279975,279976,279980,279983,279990,280005,280009,280021,280022,280171,280183,280191,280197,280322,280324,280335,280336,280437,280825,280826,280832,280838,280847,280848,280849,280850,280858,280859,280861,280871,280875,281202,281345,281346,281364,281367,281373,281378,281379,281380,281387,281428,281458,281459,281494,281495,281496,281497,281498,281765,282030,282110,282177,282645,282646,282647,282648,282649,282650,282651,282682,282742,282743,282746,282748,282749,282951,282952,283367,283412,283413,283721,284193,285291,285292,285300,285373,285389,285399,285411,285418,285421,285424,285429,285435,285437,285438,285499,285500,285502,285516,285767,285778,285782,285807,285814,285816,285817,285822,285823,285833,285852,285874,285923,285929,285950,285967,286228,286279,286282,286664,286665,286666,286668,286669,286670,286673,286674,286675,286676,287906,287907,287909,287917,287929,287931,288046,288080,288147,288589,289003,289320,289332,289346,289735,289759,289959,289960,289961,289962,289963,289964,289965,289967,289971,290596,290658,290674,290680,290683,290688,290695,290705,290713,290718,290722,290725,290731,290738,290759,290763,290766,290770,290776,290785,290789,290793,290795,290798,290800,290802,290810,290814,290818,291060,291082,291874,292981,293053,293088,293092,293093,293094,293095,293096,293098,293099,293100,293101,293103,293104,293151,293156,293163,293166,293167,293168,293169,293170,293171,293172,293174,293175,293176,293177,293178,293180,293181,293183,293193,293194,293195,293196,293197,293199,293200,293201,293202,293204,293205,293208,293222,293226,293227,293228,293229,293233,293234,293235,293236,293237,293238,293239,293240,293241,293242,293243,293244,293245,293246,293247,293248,293249,293250,293251,293252,293253,293254,293255,293256,293257,293258,293259,293260,293261,293404,294870,294928,294936,294957,294963,294964,296458,296467,296568,296595,296601,296602,296603,296604,296605,296606,296615,297362,297368,297369,297380,297381,297402,297404,297405,297406,297409,297412,297517,297518,297519,297520,297521,297522,297523,297524,297585,297586,297587,297941,297942,297943,298685,298686,298702,298715,298749,298751,298957,298958,298960,298964,298967,298997,299009,299012,299032,299035,299037,299042,299047,299049,299055,299072,299206,299306,300594,300614,301143,301146,303111,303112,303262,303263,303613,303615,305036,305037,305039,305040,305043,305044,305045,305048,305049,305050,305055,305059,305072,305075,305095,305128,305571,305591,307694,307697,307721,307727,307739,307755,307782,307787,307794,307803,307808,307809,307878,307881,307883,307884,307887,307895,307898,309301,309305,309322,309340,309349,309489,309491,309533,309622,309627,309643,309732,310203,310204,310205,310207,310218,310328,310783,310791,310826,310827,311131,311639,311642,312397,312398,312403,312420,316653,316664,316666,322559,323952,324474,324741,324744,324745,324746,324749,324778,324802,324824,324840,324845,324849,324853,324881,325009,325110,325144,325161,325208,325303,326288,326296,326309,326317,326329,326532,326535,326538,326540,326542,326549,326563,329042,329556,329570,329741,329744,329808,330666,330802,330804,330807,330808,330953,330959,330962,330965,330967,330974,330975,330983,330985,330988,331002,331005,331006,331007,331008,331009,331011,331012,331013,331014,331043,331096,331109,331121,331122,331128,331130,331132,331139,332221,332283,332304,332308,332340,332789,332808,332828,332844,332870,332921,332927,333089,333090,333094,333098,333101,333102,333104,333176,333604,333605,333610,333611,333887,333926,333927,333928,334097,334098,334099,334101,334103,335218,336140,336156,336158,336161,336162,336163,336165,336166,336168,336169,336221,336226,336278,336281,336284,336303,336304,336305,336306,336307,336399,336400,336410,336425,336433,336476,336477,336772,336774,336775,336869,336895,337342,337365,337369,337370,337371,337377,337380,337387,337388,337406,337407,337416,337811,337818,337869,337879,338058,338667,338816,338817,338818,338820,338821,338822,338823,338824,338825,340456,340651,340664,340665,340669,340682,340687,340731,340733,340745,340750,340870,341119,341124,341135,342203,342945,342946,343112,343114,343115,343116,343120,343121,343301,343404,343675,344032,344042,344159,344474,344688,344689,344690,344691,344692,344693,344694,344695,344696,344697,344698,344699,344700,344701,344703,344704,344705,344706,344707,344708,344710,344711,344712,345059,345086,345089,345093,345098,345100,345103,345104,345106,345109,345112,345115,345118,345122,345124,346846,346850,346852,346853,346858,346859,346860,346862,346863,346903,346904,346991,346993,347003,347097,347099,347100,347101,347102,347103,347104,347105,347106,347107,347108,347109,347111,347112,347283,347288,348036,348037,348038,348040,348041,348042,348043,348044,348045,348046,348047,348048,348049,348336,348492,348498,348507,348510,348512,348727,348857,348858,348896,348898,349223,349759,349787,349788,349789,349790,349791,351883,351916,351921,351924,351925,351934,351935,351938,351939,351940,351942,352101,352305,352308,352489,352722,352724,352727,352737,352739,352740,352743,352746,352747,352750,352751,353210,353939,353944,353945,354163,354431,354459,354466,354487,354491,354502,354999,355000,355011,355012,355013,355205,355206,355207,355208,355209,355210,355211,355212,355213,355214,355415,355933,355934,355935,355936,355937,355938,356053,356054,356055,356056,356057,356058,356616,356617,356638,356643,356646,356648,356664,356665,357385,357386,357387,357389,357401,357431,358331,358332,358333,358783,358815,358891,359683,359684,359685,359746,359753,359820,359984,360275,360286,360722,360723,360724,360729,360731,360761,360771,360776,360785,360846,360848,360851,360980,361001,361006,361008,361565,361568,361569,361649,361737,361738,362039,362048,362432,362436,362438,362442,358865,361874,330667)

select distinct typ from getproducts1 where dept='Firearms' and brand='TAURUS' 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 (251464,217249,250965,358879,305051,53949,334958,257266,257267,331223,336139,251742,336141,336144,361189,336142,336145,353252,289970,53948,114645,247485,260920,357545,336143,353253,336146,113766,227302,247488,353254,53961,104468,289968,305046,335224,203917,359558,219800,219801,257275,286677,326187,326188,352102,358890,361774,361858,361878,362437,53818,53820,53824,53827,53858,53889,53894,53912,53913,53918,53919,53925,53929,53930,53933,53934,53936,53937,53951,53952,53956,53960,53979,53992,53993,53999,54029,54035,54036,54038,54041,54043,54047,67732,68234,68533,68534,68542,74911,75339,77853,84067,85328,88519,91163,92720,100606,101456,107012,107665,108023,108208,110962,111156,112321,113146,113147,113522,114644,115104,115910,116155,116655,116993,117195,119052,119158,120925,121157,121166,121990,122799,122870,124355,124764,125065,125609,126262,126525,128453,128633,129542,134711,135306,136382,143149,151395,151733,152539,153046,153292,153354,153356,153357,155212,155215,155216,157874,169862,178654,184300,189788,189789,189790,189791,189792,189796,189798,189799,189800,189802,189803,189903,191514,191688,192360,192361,192606,193096,193098,193099,193101,193102,193103,193104,193105,193106,193107,193108,193109,193110,193113,193115,193117,193119,193120,193121,193122,193123,193124,193125,193127,193129,193130,193131,193132,193133,193137,193138,193291,195887,196073,197136,197138,197139,197140,197141,198160,199036,200030,201673,201765,205184,205643,205644,205645,205646,205647,205648,205649,205652,205653,205654,205655,205976,206320,206321,206749,206981,206983,207752,207954,208272,210660,210661,210662,210663,210664,210665,210666,210667,210668,210669,210670,210671,210672,210673,210674,210675,212031,214317,214886,215163,215164,216628,217251,217252,217253,217257,217258,217706,217707,217776,217777,217778,217779,217780,217781,217782,217982,219799,219802,219803,219804,219938,220055,220544,220567,220568,220569,220570,220595,220596,220888,220890,220892,220924,220950,221015,221023,221029,221037,221042,222481,222534,222535,222565,222573,222574,222575,222584,222650,223174,223175,223176,225266,225268,225273,225293,225302,225314,225315,225317,225324,225328,225343,227134,227151,227153,227154,228019,228020,228021,228052,228179,228587,242378,242387,242409,247435,247437,247438,247439,247441,247457,247458,247459,247460,247461,247462,247464,247465,247466,247467,247468,247469,247470,247471,247472,247473,247475,247476,247477,247478,247480,247482,247483,247484,247487,247490,247491,247493,247494,247495,247498,247499,247500,247501,247502,247535,247544,247549,247550,247551,247742,247746,247748,247750,247785,247787,247788,247795,247805,247811,248890,248891,251454,251455,251457,251459,251461,251462,251463,251613,251733,251734,251979,253446,253735,253738,253743,253746,254161,254162,255256,255884,257263,257264,257265,257268,257274,257276,257277,257278,257279,257280,257281,257284,257285,257286,257287,257288,257289,257290,257294,257295,257296,260631,260908,260910,260926,260927,260937,260938,260939,260940,260941,261118,264161,264163,264164,264176,264177,264182,266287,266473,266751,267031,267033,267216,267218,267220,267304,268307,268310,268317,268319,268320,268322,268324,268325,268329,268340,268342,268343,268346,268348,268350,268352,268357,268873,268874,268978,269017,269022,269074,271562,271807,271808,272954,272955,273793,273929,274099,274107,274109,274642,274643,274644,274645,276052,276158,276159,277025,277026,277027,277028,277029,277030,277031,277032,277873,277922,277923,277924,278355,278401,278928,279023,279267,279473,279960,279961,279972,279975,279976,279980,279983,279990,280005,280009,280021,280022,280171,280183,280191,280197,280322,280324,280335,280336,280437,280825,280826,280832,280838,280847,280848,280849,280850,280858,280859,280861,280871,280875,281202,281345,281346,281364,281367,281373,281378,281379,281380,281387,281428,281458,281459,281494,281495,281496,281497,281498,281765,282030,282110,282177,282645,282646,282647,282648,282649,282650,282651,282682,282742,282743,282746,282748,282749,282951,282952,283367,283412,283413,283721,284193,285291,285292,285300,285373,285389,285399,285411,285418,285421,285424,285429,285435,285437,285438,285499,285500,285502,285516,285767,285778,285782,285807,285814,285816,285817,285822,285823,285833,285852,285874,285923,285929,285950,285967,286228,286279,286282,286664,286665,286666,286668,286669,286670,286673,286674,286675,286676,287906,287907,287909,287917,287929,287931,288046,288080,288147,288589,289003,289320,289332,289346,289735,289759,289959,289960,289961,289962,289963,289964,289965,289967,289971,290596,290658,290674,290680,290683,290688,290695,290705,290713,290718,290722,290725,290731,290738,290759,290763,290766,290770,290776,290785,290789,290793,290795,290798,290800,290802,290810,290814,290818,291060,291082,291874,292981,293053,293088,293092,293093,293094,293095,293096,293098,293099,293100,293101,293103,293104,293151,293156,293163,293166,293167,293168,293169,293170,293171,293172,293174,293175,293176,293177,293178,293180,293181,293183,293193,293194,293195,293196,293197,293199,293200,293201,293202,293204,293205,293208,293222,293226,293227,293228,293229,293233,293234,293235,293236,293237,293238,293239,293240,293241,293242,293243,293244,293245,293246,293247,293248,293249,293250,293251,293252,293253,293254,293255,293256,293257,293258,293259,293260,293261,293404,294870,294928,294936,294957,294963,294964,296458,296467,296568,296595,296601,296602,296603,296604,296605,296606,296615,297362,297368,297369,297380,297381,297402,297404,297405,297406,297409,297412,297517,297518,297519,297520,297521,297522,297523,297524,297585,297586,297587,297941,297942,297943,298685,298686,298702,298715,298749,298751,298957,298958,298960,298964,298967,298997,299009,299012,299032,299035,299037,299042,299047,299049,299055,299072,299206,299306,300594,300614,301143,301146,303111,303112,303262,303263,303613,303615,305036,305037,305039,305040,305043,305044,305045,305048,305049,305050,305055,305059,305072,305075,305095,305128,305571,305591,307694,307697,307721,307727,307739,307755,307782,307787,307794,307803,307808,307809,307878,307881,307883,307884,307887,307895,307898,309301,309305,309322,309340,309349,309489,309491,309533,309622,309627,309643,309732,310203,310204,310205,310207,310218,310328,310783,310791,310826,310827,311131,311639,311642,312397,312398,312403,312420,316653,316664,316666,322559,323952,324474,324741,324744,324745,324746,324749,324778,324802,324824,324840,324845,324849,324853,324881,325009,325110,325144,325161,325208,325303,326288,326296,326309,326317,326329,326532,326535,326538,326540,326542,326549,326563,329042,329556,329570,329741,329744,329808,330666,330802,330804,330807,330808,330953,330959,330962,330965,330967,330974,330975,330983,330985,330988,331002,331005,331006,331007,331008,331009,331011,331012,331013,331014,331043,331096,331109,331121,331122,331128,331130,331132,331139,332221,332283,332304,332308,332340,332789,332808,332828,332844,332870,332921,332927,333089,333090,333094,333098,333101,333102,333104,333176,333604,333605,333610,333611,333887,333926,333927,333928,334097,334098,334099,334101,334103,335218,336140,336156,336158,336161,336162,336163,336165,336166,336168,336169,336221,336226,336278,336281,336284,336303,336304,336305,336306,336307,336399,336400,336410,336425,336433,336476,336477,336772,336774,336775,336869,336895,337342,337365,337369,337370,337371,337377,337380,337387,337388,337406,337407,337416,337811,337818,337869,337879,338058,338667,338816,338817,338818,338820,338821,338822,338823,338824,338825,340456,340651,340664,340665,340669,340682,340687,340731,340733,340745,340750,340870,341119,341124,341135,342203,342945,342946,343112,343114,343115,343116,343120,343121,343301,343404,343675,344032,344042,344159,344474,344688,344689,344690,344691,344692,344693,344694,344695,344696,344697,344698,344699,344700,344701,344703,344704,344705,344706,344707,344708,344710,344711,344712,345059,345086,345089,345093,345098,345100,345103,345104,345106,345109,345112,345115,345118,345122,345124,346846,346850,346852,346853,346858,346859,346860,346862,346863,346903,346904,346991,346993,347003,347097,347099,347100,347101,347102,347103,347104,347105,347106,347107,347108,347109,347111,347112,347283,347288,348036,348037,348038,348040,348041,348042,348043,348044,348045,348046,348047,348048,348049,348336,348492,348498,348507,348510,348512,348727,348857,348858,348896,348898,349223,349759,349787,349788,349789,349790,349791,351883,351916,351921,351924,351925,351934,351935,351938,351939,351940,351942,352101,352305,352308,352489,352722,352724,352727,352737,352739,352740,352743,352746,352747,352750,352751,353210,353939,353944,353945,354163,354431,354459,354466,354487,354491,354502,354999,355000,355011,355012,355013,355205,355206,355207,355208,355209,355210,355211,355212,355213,355214,355415,355933,355934,355935,355936,355937,355938,356053,356054,356055,356056,356057,356058,356616,356617,356638,356643,356646,356648,356664,356665,357385,357386,357387,357389,357401,357431,358331,358332,358333,358783,358815,358891,359683,359684,359685,359746,359753,359820,359984,360275,360286,360722,360723,360724,360729,360731,360761,360771,360776,360785,360846,360848,360851,360980,361001,361006,361008,361565,361568,361569,361649,361737,361738,362039,362048,362432,362436,362438,362442,358865,361874,330667)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='TAURUS' 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='Revolvers with Color' and subtyp_1='EMPTY' and site = 'sportsman'

SELECT *
			FROM tb_mfg_promo.dbo.tb_mfg_promos 
			WHERE brand='taurus' and (start_date<= '04/13/2026 23:59:00' or active=1) and end_date >= '04/13/2026'

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

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

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 = 217249 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 250965 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 53949 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 227302 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 257267 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 53948 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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

group by Style_id 
order by styles_web_taxonomy_id desc

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

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 = 358879 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 362437 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 361774 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 361878 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 361858 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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 = 361189 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

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

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

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

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

			from tb_skus a with (nolock)

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

			where a.style_id = 251464 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 = 251464 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=251464

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 = 251464 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=251464  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=251464 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 = 217249 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 = 217249 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=217249

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 = 217249 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=217249  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=217249 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 = 250965 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 = 250965 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=250965

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 = 250965 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=250965  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=250965 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 = 358879 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 = 358879 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=358879

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 = 358879 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=358879  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=358879 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 = 305051 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 = 305051 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=305051

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 = 305051 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=305051  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=305051 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 = 53949 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 = 53949 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=53949

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 = 53949 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=53949  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=53949 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 = 334958 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 = 334958 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=334958

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 = 334958 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=334958  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=334958 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 = 257266 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 = 257266 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=257266

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 = 257266 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=257266  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=257266 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 = 257267 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 = 257267 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=257267

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 = 257267 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=257267  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=257267 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 = 331223 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 = 331223 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=331223

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 = 331223 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=331223  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=331223 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 = 336139 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 = 336139 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=336139

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 = 336139 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336139  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=336139 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 = 251742 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 = 251742 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=251742

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 = 251742 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=251742  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=251742 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 = 336141 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 = 336141 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=336141

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 = 336141 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336141  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=336141 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 = 336144 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 = 336144 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=336144

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 = 336144 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336144  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=336144 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 = 361189 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 = 361189 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=361189

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 = 361189 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=361189  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=361189 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 = 336142 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 = 336142 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=336142

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 = 336142 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336142  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=336142 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 = 336145 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 = 336145 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=336145

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 = 336145 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=336145  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=336145 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 = 353252 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 = 353252 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 23:09:56' and
end_date >= 'Apr 13, 2026 23:09:56'
and store_id=10 and style_id=353252

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 = 353252 
and (a.start_date<= 'Apr 13, 2026 23:09:56' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 23:09:56'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=353252  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=353252 and status='A' and site = 'sportsman'

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

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/brand/taurus
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/brand/taurus
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=22865607
cftoken=5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47
hitcount=1
lastvisit={ts '2026-04-13 23:09:55'}
timecreated={ts '2026-04-13 23:09:55'}
urltoken=CFID=22865607&CFTOKEN=5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47

Cookie Variables:
CFID=22865607
CFTOKEN=5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47
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=22865607
cftoken=5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47
cs=/category.cfm/brand/taurus
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22865607_5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47
strarray=Array (0)
urltoken=CFID=22865607&CFTOKEN=5c5eb2118d55fdf1-63AAF1AD-AC70-3EBA-1FDAC5B1209A7A47

URL Parameters:
CLEARANCE=
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=taurus
WHATSNEW=
brand=taurus