Glock

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 16:00:00' AND b.end_date >= '2026-04-13 16: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='glock'
	
	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 grandgetproductsglock
		where
		 style_id is not null
            
				and brand='GLOCK'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproductsglock
		where
		 picture_id is not null
            
			
				and brand='GLOCK'
			


order by

min_price

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

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

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 17 and c.style_id in (21980,21984,249643,211079,254302,356406,252191,361895,107250,250666,358574,130336,284331,361459,117149,107249,125120,326151,192180,334165,355114,117150,193087,207643,253322,284330,311569,123317,192191,192348,284333,22101,22107,22149,115236,252484,284334,284335,284342,326164,332822,356697,358863,362116,362359,201626,252085,355718,357248,21997,22008,22009,22131,22132,75427,75428,114698,114700,114702,115257,123319,128960,131326,134569,145264,147060,147481,147482,164889,168792,192179,192182,204002,205392,209452,212098,247857,250503,262276,284328,284329,284336,284340,284343,284347,303408,316441,326158,326160,355854,356843,357069,357499,358446,360681,361463,362376,363304,363305,147483,361275,361557,21846,21847,21848,21862,21875,21876,21882,21890,21893,21894,21898,21899,21903,21904,21906,21907,21909,21910,21911,21914,21916,21917,21938,21939,21949,21968,21970,21976,21978,21979,21981,21982,21983,21985,21986,21987,21988,21990,21991,21992,21993,21995,21996,21998,21999,22002,22004,22005,22051,22099,22111,22116,22117,22118,22119,22120,22122,22124,22125,22126,22128,22130,22134,22140,22143,22147,22152,22155,22156,58934,68065,69861,70344,72561,75425,75426,79706,84849,85224,85538,87100,89116,89117,91864,92318,93726,94613,95325,100304,101131,101734,101976,102132,102160,103596,105446,107789,108247,108383,108420,109257,109506,109836,110301,111730,112600,113252,113681,114911,115222,115235,115743,116984,117151,118406,118408,118410,118412,118455,119517,120222,121358,121561,123097,124097,124165,124625,124879,124880,125004,125099,125119,125320,125632,126892,126893,126894,129218,129220,129512,129589,129962,130110,130427,133411,133782,133783,133830,133921,134157,134427,134432,134542,135099,135268,135504,135962,135963,135965,136638,136701,137242,138209,140144,140212,141243,141289,141447,141480,141687,141710,143085,143805,143881,143907,143968,144450,144451,144452,144857,144858,144859,145074,145150,145371,147479,147936,147937,148388,148510,150974,150975,151743,152316,152696,153231,155176,155375,155690,156323,156324,158480,158524,159122,160904,161190,161335,161336,161337,161338,161339,161342,161343,161344,161345,161346,161347,161348,161349,161350,161351,161352,161398,161478,161688,161717,162204,163144,163201,163268,163307,163941,164015,164160,164336,164348,164473,164479,164665,164666,164667,164711,164762,164796,164797,164884,164929,164974,164978,164979,165130,165139,165144,165178,165191,165333,165499,165500,167701,167704,168047,168050,168065,168066,168100,168147,168148,168153,168154,168160,168175,168180,168182,168188,168420,168421,168535,168537,168538,168667,168668,168674,168675,168676,168677,168678,168679,168680,168681,168682,168683,168685,168686,168687,168688,168690,168692,168693,168694,168695,168696,168699,168700,168701,168702,168747,168748,168749,168750,168751,168752,168753,168754,168823,168825,168828,168829,168830,168831,168870,168871,169055,169438,169614,169615,170129,170130,170195,170196,170399,170401,170403,170624,170625,170626,170632,172685,172887,173265,173270,173864,173865,175328,175329,176373,176450,178694,178695,178696,179124,179258,179429,179516,179656,179739,179765,180046,181362,181414,181851,182003,183660,184009,184234,184291,184297,184351,184448,188243,188281,188282,188283,188731,189019,189166,189292,191490,191585,191727,191728,191729,192152,192163,192181,192230,192280,192470,193475,193477,193478,193613,193914,194032,195461,195462,195841,195892,195965,196022,196064,196068,196075,196289,197051,197069,197071,197081,197298,197299,197746,197824,197826,199965,201601,201820,201911,201971,202214,202215,202216,202217,202484,202485,202486,202998,203000,203233,205434,205959,206052,206090,206301,206319,206743,206778,206916,207038,207486,207957,207958,207959,208141,208203,208332,208657,208953,209189,209190,209449,209450,209451,209848,209876,209880,209984,210292,210422,211031,211062,211234,211235,211370,211371,211693,211786,211788,211940,212027,212293,213413,213424,213436,213461,213760,213762,214082,214429,214465,214466,214592,214677,214678,214679,214703,214715,214717,214809,214810,214894,214926,215557,215638,215888,215899,215902,216704,216890,216926,216927,217372,217479,217480,217481,217694,218045,218047,218048,218050,218051,218052,218053,218377,218479,219636,219638,219772,220072,220218,220339,220370,220472,220713,220747,220887,220958,220962,220965,220967,220968,220970,221074,221973,222232,222233,222465,225304,225306,225914,226059,227157,227160,227161,227162,228586,228595,228596,228604,228605,235864,236911,239391,239404,239406,242420,244961,245221,245238,245240,245413,245437,245438,245906,246049,246450,246451,246487,246903,246904,246905,246906,246907,246908,246909,246910,246911,246914,246915,246916,246917,246918,246919,246990,247526,247527,247899,249497,249500,249502,249570,249635,249636,249637,249638,249639,249640,249641,249642,249692,249693,250128,250140,250176,250181,250185,250265,250285,250418,250419,250426,250514,250515,250624,250667,250668,251208,251347,251640,251653,251724,251725,251897,251951,252022,252053,252054,252055,252141,252320,252653,252948,253029,253139,253246,253253,253298,253321,253324,253371,253372,253471,253556,253964,253969,253970,253986,254180,254200,254201,254252,254358,254359,254367,254505,254506,254509,255163,255435,255436,255438,255439,255440,255441,255563,255565,255566,255696,255697,255698,255786,255787,255790,255791,255809,256053,256072,256091,256092,256095,256192,256198,256201,256426,256508,256513,256569,256603,256682,256963,256979,257008,257010,257011,257017,257064,257065,257230,260459,260524,260576,260577,260578,260579,260778,260866,260877,260969,260972,260973,261047,261380,261382,261383,261384,261385,262052,262286,262289,262375,262443,262453,262832,262834,262997,263529,263654,263794,263809,263835,264298,264302,264592,264595,264600,264647,264653,264755,265018,266132,266133,266135,266136,266137,266289,266651,266703,266773,266965,267049,267050,267051,267069,267122,267139,267213,267255,267294,267295,267413,267465,267478,267783,268003,268037,268054,268386,268411,268665,268902,268909,268915,269008,269115,269192,269231,269232,269233,269395,269396,269397,269398,269399,269400,269401,269471,269482,269483,269484,269510,269511,269512,269550,269870,269872,269873,269874,269875,269876,269878,269880,269881,269882,269896,270864,270866,270867,270873,270874,270875,270876,270969,271440,271444,271959,272207,272259,272261,272675,272676,273114,273439,273562,273563,273564,273812,275743,275843,275957,275997,276111,276112,276206,276210,276211,276212,276213,276214,276408,276411,276414,276861,276862,276863,276864,277071,277072,277073,277075,277078,277079,277080,277488,277527,277529,277581,277881,277883,277884,277886,278904,279400,279407,279408,279410,279470,279471,279472,279475,279477,279606,279607,279971,279978,280001,280057,280064,280187,280190,280260,280273,280345,280347,280348,280392,280424,280453,280506,280507,280508,280509,280510,280511,280833,281155,281161,281162,281163,281199,281348,281422,281520,281522,281527,281530,281531,281638,281838,281839,281847,281848,281849,281938,282146,282147,282480,283358,283360,283446,283630,283800,283802,283824,283825,283852,283958,283990,284332,284337,284344,284994,285339,285341,285352,285353,285391,285392,285396,285404,285436,285678,285800,285801,285806,285821,285825,285826,285946,285948,285961,285963,286272,286274,286313,286768,286960,287275,287276,287277,287553,287554,287555,287557,287558,287559,287560,287562,287563,287564,287727,287768,287769,287771,287772,287775,287908,287916,287918,287919,287961,288021,288040,288084,288088,288732,288888,288889,288891,289430,289611,289612,289668,289895,290036,290037,290038,290041,290042,290357,290358,290495,290603,290656,290716,290788,290907,291230,291231,291236,291504,291554,291555,291556,291973,291974,291976,292091,292114,292130,292131,292132,292133,292134,292144,292145,292627,292678,292679,292681,293000,293066,293083,293084,293085,293086,293087,293210,293211,293212,293213,293214,293215,294603,294676,294679,294866,294867,294875,294882,294913,294932,294970,295067,296375,296380,296381,296389,296392,296394,296395,296462,296465,296472,296503,296576,296577,296582,296587,296591,296592,296593,296594,296618,296634,296637,296639,296647,296648,297047,297048,297049,297253,297254,297388,297389,297393,297540,297576,297777,297847,297885,297886,298393,298395,298398,298399,298549,298600,298689,298975,298977,299011,299026,299041,299051,299053,299065,299156,299372,300579,300580,300583,300584,300586,300596,300597,300598,300599,300601,300606,300612,300647,300675,300707,300708,300710,300712,300713,300730,300734,300735,300736,300737,300738,300739,301156,301174,301363,302658,302659,302660,303131,303407,303497,303511,303513,303537,303540,303626,303926,303927,303928,303929,303931,303932,303934,304685,304686,304687,304689,304690,304691,304695,304696,304697,304698,304699,304701,304703,304809,304878,304880,304882,304884,304887,304891,304894,304897,304898,304929,304957,305076,305090,305092,305120,305126,305550,305551,305598,305641,307231,307232,307672,307673,307674,307676,307706,307709,307710,307712,307713,307715,307717,307720,307722,307724,307725,307742,307748,307749,307750,307751,307758,307804,307806,307889,308064,308272,308273,308276,309328,309334,309345,309539,309614,309615,309617,309618,309812,309813,309814,309820,309821,309825,309977,309978,309979,309980,309981,309982,310072,310128,310274,310294,310300,310301,310302,310506,310646,310647,310648,310649,310650,310651,310652,310655,311629,311632,311746,311747,312050,312060,312356,312386,312390,312400,312401,312402,312424,316364,316459,316463,316465,316467,316468,316469,316471,316606,316633,316676,318623,318625,318626,319772,319773,319790,319797,319798,319799,319812,319813,319814,319816,319817,319818,319825,319826,319828,319830,319831,319832,319840,319932,319933,320124,320739,320740,320741,320743,320745,320746,322152,322153,322529,322531,322570,322598,322638,322639,322641,322643,322653,322655,322658,322661,323294,323343,323396,323552,323553,323554,323954,323965,324743,324775,324785,324803,324843,324879,325305,325308,325316,325322,325325,325326,325330,325332,325333,325334,325335,325336,325337,325343,325347,325355,326123,326156,326157,326161,326163,326210,326219,326220,326221,326280,326299,326300,326303,326310,326315,326319,326324,326327,326476,326477,326572,326632,326633,326637,326644,326645,326647,326651,328417,328768,328773,328774,328976,329022,329149,329269,329327,329353,329540,329544,329546,329548,329549,329550,329551,329600,329612,329613,329614,329738,329846,329951,330247,330248,330317,330318,330511,330513,330515,330519,330526,330601,330602,330603,330604,330743,330746,330747,330749,330780,330801,330963,330968,330971,330992,331085,331102,331103,331123,331124,331566,331567,331568,331581,331799,331800,331801,331802,331872,331873,332290,332321,332332,332334,332383,332395,332396,332412,332414,332415,332417,332451,332457,332487,332488,332518,332604,332608,332687,332806,332827,332829,332832,332834,332839,332842,332845,332850,332852,333067,333068,333069,333252,333256,333932,333933,333934,333989,333990,333992,333995,333996,334073,334074,334080,334093,334094,334146,334147,334149,334250,335801,336084,336294,336409,336412,336416,336419,336422,336424,336427,336436,336541,336542,336543,336544,336601,336602,336603,336604,336605,336776,336777,336778,336793,336837,336839,336841,336842,336843,336844,336845,336860,336862,336891,336928,337105,337142,337146,337147,337339,337348,337351,337475,337737,337806,337816,337835,337836,337940,337968,338008,338482,338483,338565,338586,338771,338772,338773,338775,339386,340301,340304,340331,340333,340349,340564,340575,340576,340577,340635,340656,340657,340671,340727,340728,340744,340759,342210,342422,342471,342472,342473,342474,342475,342917,342918,342919,342920,342921,342923,342925,343141,343163,343307,344039,344129,344483,344852,344854,344855,344856,344857,344858,344883,345074,345075,345076,345078,345079,345080,345081,345082,345084,345085,345087,345088,345090,345091,345202,345218,345262,346672,346673,346674,346677,346795,346797,346880,346881,346886,346888,346890,346892,347006,347091,347092,347093,347094,347096,347141,347142,347144,347145,347152,347155,347158,347161,347162,347285,347286,347287,347898,347899,347900,348064,348065,348066,348067,348068,348287,348288,348503,348707,348708,348710,348711,348713,348716,348796,348859,348886,348887,349066,349067,349081,349124,349255,349256,349257,349679,349740,349792,349794,349796,349797,349819,349820,349821,349928,349930,349931,349932,349935,350156,350157,350159,350735,350807,350809,351997,351998,352000,352003,352004,352006,352029,352042,352055,352313,352481,352482,352483,352485,352539,352689,352760,352763,352767,353021,353212,353213,353214,353215,353281,353282,353283,353438,353443,353475,353519,353522,353525,353560,353848,353849,353850,354144,354148,354495,354782,355002,355007,355008,355032,355033,355037,355043,355044,355046,355047,355068,355069,355070,355071,355072,355073,355192,355195,355197,355199,355200,355201,355202,355203,355204,355468,355598,355706,355853,355939,355940,355941,356025,356541,356542,356543,356640,356641,356647,356652,356663,356853,357067,357123,357131,357181,357210,357376,357398,357399,357428,357501,357733,357737,357998,357999,358000,358297,358298,358299,358578,359219,359220,359221,359687,359708,359745,359752,359810,359813,359974,359975,359976,360000,360273,360279,360283,360727,360792,360793,360855,360863,361003,361011,361012,361013,361017,361037,361041,361276,361555,361556,361746,361768,361838,361848,361863,361877,362030,362042,362046,362050,362227,362270,362650,320161)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='GLOCK' 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='Cleaning & Maintenance' and subtyp_1='EMPTY' and site = 'sportsman'

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

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

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

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

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

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

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

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

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

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

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Speedloaders' 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 (21980,21984,249643,211079,254302,356406,252191,361895,107250,250666,358574,130336,284331,361459,117149,107249,125120,326151,192180,334165,355114,117150,193087,207643,253322,284330,311569,123317,192191,192348,284333,22101,22107,22149,115236,252484,284334,284335,284342,326164,332822,356697,358863,362116,362359,201626,252085,355718,357248,21997,22008,22009,22131,22132,75427,75428,114698,114700,114702,115257,123319,128960,131326,134569,145264,147060,147481,147482,164889,168792,192179,192182,204002,205392,209452,212098,247857,250503,262276,284328,284329,284336,284340,284343,284347,303408,316441,326158,326160,355854,356843,357069,357499,358446,360681,361463,362376,363304,363305,147483,361275,361557,21846,21847,21848,21862,21875,21876,21882,21890,21893,21894,21898,21899,21903,21904,21906,21907,21909,21910,21911,21914,21916,21917,21938,21939,21949,21968,21970,21976,21978,21979,21981,21982,21983,21985,21986,21987,21988,21990,21991,21992,21993,21995,21996,21998,21999,22002,22004,22005,22051,22099,22111,22116,22117,22118,22119,22120,22122,22124,22125,22126,22128,22130,22134,22140,22143,22147,22152,22155,22156,58934,68065,69861,70344,72561,75425,75426,79706,84849,85224,85538,87100,89116,89117,91864,92318,93726,94613,95325,100304,101131,101734,101976,102132,102160,103596,105446,107789,108247,108383,108420,109257,109506,109836,110301,111730,112600,113252,113681,114911,115222,115235,115743,116984,117151,118406,118408,118410,118412,118455,119517,120222,121358,121561,123097,124097,124165,124625,124879,124880,125004,125099,125119,125320,125632,126892,126893,126894,129218,129220,129512,129589,129962,130110,130427,133411,133782,133783,133830,133921,134157,134427,134432,134542,135099,135268,135504,135962,135963,135965,136638,136701,137242,138209,140144,140212,141243,141289,141447,141480,141687,141710,143085,143805,143881,143907,143968,144450,144451,144452,144857,144858,144859,145074,145150,145371,147479,147936,147937,148388,148510,150974,150975,151743,152316,152696,153231,155176,155375,155690,156323,156324,158480,158524,159122,160904,161190,161335,161336,161337,161338,161339,161342,161343,161344,161345,161346,161347,161348,161349,161350,161351,161352,161398,161478,161688,161717,162204,163144,163201,163268,163307,163941,164015,164160,164336,164348,164473,164479,164665,164666,164667,164711,164762,164796,164797,164884,164929,164974,164978,164979,165130,165139,165144,165178,165191,165333,165499,165500,167701,167704,168047,168050,168065,168066,168100,168147,168148,168153,168154,168160,168175,168180,168182,168188,168420,168421,168535,168537,168538,168667,168668,168674,168675,168676,168677,168678,168679,168680,168681,168682,168683,168685,168686,168687,168688,168690,168692,168693,168694,168695,168696,168699,168700,168701,168702,168747,168748,168749,168750,168751,168752,168753,168754,168823,168825,168828,168829,168830,168831,168870,168871,169055,169438,169614,169615,170129,170130,170195,170196,170399,170401,170403,170624,170625,170626,170632,172685,172887,173265,173270,173864,173865,175328,175329,176373,176450,178694,178695,178696,179124,179258,179429,179516,179656,179739,179765,180046,181362,181414,181851,182003,183660,184009,184234,184291,184297,184351,184448,188243,188281,188282,188283,188731,189019,189166,189292,191490,191585,191727,191728,191729,192152,192163,192181,192230,192280,192470,193475,193477,193478,193613,193914,194032,195461,195462,195841,195892,195965,196022,196064,196068,196075,196289,197051,197069,197071,197081,197298,197299,197746,197824,197826,199965,201601,201820,201911,201971,202214,202215,202216,202217,202484,202485,202486,202998,203000,203233,205434,205959,206052,206090,206301,206319,206743,206778,206916,207038,207486,207957,207958,207959,208141,208203,208332,208657,208953,209189,209190,209449,209450,209451,209848,209876,209880,209984,210292,210422,211031,211062,211234,211235,211370,211371,211693,211786,211788,211940,212027,212293,213413,213424,213436,213461,213760,213762,214082,214429,214465,214466,214592,214677,214678,214679,214703,214715,214717,214809,214810,214894,214926,215557,215638,215888,215899,215902,216704,216890,216926,216927,217372,217479,217480,217481,217694,218045,218047,218048,218050,218051,218052,218053,218377,218479,219636,219638,219772,220072,220218,220339,220370,220472,220713,220747,220887,220958,220962,220965,220967,220968,220970,221074,221973,222232,222233,222465,225304,225306,225914,226059,227157,227160,227161,227162,228586,228595,228596,228604,228605,235864,236911,239391,239404,239406,242420,244961,245221,245238,245240,245413,245437,245438,245906,246049,246450,246451,246487,246903,246904,246905,246906,246907,246908,246909,246910,246911,246914,246915,246916,246917,246918,246919,246990,247526,247527,247899,249497,249500,249502,249570,249635,249636,249637,249638,249639,249640,249641,249642,249692,249693,250128,250140,250176,250181,250185,250265,250285,250418,250419,250426,250514,250515,250624,250667,250668,251208,251347,251640,251653,251724,251725,251897,251951,252022,252053,252054,252055,252141,252320,252653,252948,253029,253139,253246,253253,253298,253321,253324,253371,253372,253471,253556,253964,253969,253970,253986,254180,254200,254201,254252,254358,254359,254367,254505,254506,254509,255163,255435,255436,255438,255439,255440,255441,255563,255565,255566,255696,255697,255698,255786,255787,255790,255791,255809,256053,256072,256091,256092,256095,256192,256198,256201,256426,256508,256513,256569,256603,256682,256963,256979,257008,257010,257011,257017,257064,257065,257230,260459,260524,260576,260577,260578,260579,260778,260866,260877,260969,260972,260973,261047,261380,261382,261383,261384,261385,262052,262286,262289,262375,262443,262453,262832,262834,262997,263529,263654,263794,263809,263835,264298,264302,264592,264595,264600,264647,264653,264755,265018,266132,266133,266135,266136,266137,266289,266651,266703,266773,266965,267049,267050,267051,267069,267122,267139,267213,267255,267294,267295,267413,267465,267478,267783,268003,268037,268054,268386,268411,268665,268902,268909,268915,269008,269115,269192,269231,269232,269233,269395,269396,269397,269398,269399,269400,269401,269471,269482,269483,269484,269510,269511,269512,269550,269870,269872,269873,269874,269875,269876,269878,269880,269881,269882,269896,270864,270866,270867,270873,270874,270875,270876,270969,271440,271444,271959,272207,272259,272261,272675,272676,273114,273439,273562,273563,273564,273812,275743,275843,275957,275997,276111,276112,276206,276210,276211,276212,276213,276214,276408,276411,276414,276861,276862,276863,276864,277071,277072,277073,277075,277078,277079,277080,277488,277527,277529,277581,277881,277883,277884,277886,278904,279400,279407,279408,279410,279470,279471,279472,279475,279477,279606,279607,279971,279978,280001,280057,280064,280187,280190,280260,280273,280345,280347,280348,280392,280424,280453,280506,280507,280508,280509,280510,280511,280833,281155,281161,281162,281163,281199,281348,281422,281520,281522,281527,281530,281531,281638,281838,281839,281847,281848,281849,281938,282146,282147,282480,283358,283360,283446,283630,283800,283802,283824,283825,283852,283958,283990,284332,284337,284344,284994,285339,285341,285352,285353,285391,285392,285396,285404,285436,285678,285800,285801,285806,285821,285825,285826,285946,285948,285961,285963,286272,286274,286313,286768,286960,287275,287276,287277,287553,287554,287555,287557,287558,287559,287560,287562,287563,287564,287727,287768,287769,287771,287772,287775,287908,287916,287918,287919,287961,288021,288040,288084,288088,288732,288888,288889,288891,289430,289611,289612,289668,289895,290036,290037,290038,290041,290042,290357,290358,290495,290603,290656,290716,290788,290907,291230,291231,291236,291504,291554,291555,291556,291973,291974,291976,292091,292114,292130,292131,292132,292133,292134,292144,292145,292627,292678,292679,292681,293000,293066,293083,293084,293085,293086,293087,293210,293211,293212,293213,293214,293215,294603,294676,294679,294866,294867,294875,294882,294913,294932,294970,295067,296375,296380,296381,296389,296392,296394,296395,296462,296465,296472,296503,296576,296577,296582,296587,296591,296592,296593,296594,296618,296634,296637,296639,296647,296648,297047,297048,297049,297253,297254,297388,297389,297393,297540,297576,297777,297847,297885,297886,298393,298395,298398,298399,298549,298600,298689,298975,298977,299011,299026,299041,299051,299053,299065,299156,299372,300579,300580,300583,300584,300586,300596,300597,300598,300599,300601,300606,300612,300647,300675,300707,300708,300710,300712,300713,300730,300734,300735,300736,300737,300738,300739,301156,301174,301363,302658,302659,302660,303131,303407,303497,303511,303513,303537,303540,303626,303926,303927,303928,303929,303931,303932,303934,304685,304686,304687,304689,304690,304691,304695,304696,304697,304698,304699,304701,304703,304809,304878,304880,304882,304884,304887,304891,304894,304897,304898,304929,304957,305076,305090,305092,305120,305126,305550,305551,305598,305641,307231,307232,307672,307673,307674,307676,307706,307709,307710,307712,307713,307715,307717,307720,307722,307724,307725,307742,307748,307749,307750,307751,307758,307804,307806,307889,308064,308272,308273,308276,309328,309334,309345,309539,309614,309615,309617,309618,309812,309813,309814,309820,309821,309825,309977,309978,309979,309980,309981,309982,310072,310128,310274,310294,310300,310301,310302,310506,310646,310647,310648,310649,310650,310651,310652,310655,311629,311632,311746,311747,312050,312060,312356,312386,312390,312400,312401,312402,312424,316364,316459,316463,316465,316467,316468,316469,316471,316606,316633,316676,318623,318625,318626,319772,319773,319790,319797,319798,319799,319812,319813,319814,319816,319817,319818,319825,319826,319828,319830,319831,319832,319840,319932,319933,320124,320739,320740,320741,320743,320745,320746,322152,322153,322529,322531,322570,322598,322638,322639,322641,322643,322653,322655,322658,322661,323294,323343,323396,323552,323553,323554,323954,323965,324743,324775,324785,324803,324843,324879,325305,325308,325316,325322,325325,325326,325330,325332,325333,325334,325335,325336,325337,325343,325347,325355,326123,326156,326157,326161,326163,326210,326219,326220,326221,326280,326299,326300,326303,326310,326315,326319,326324,326327,326476,326477,326572,326632,326633,326637,326644,326645,326647,326651,328417,328768,328773,328774,328976,329022,329149,329269,329327,329353,329540,329544,329546,329548,329549,329550,329551,329600,329612,329613,329614,329738,329846,329951,330247,330248,330317,330318,330511,330513,330515,330519,330526,330601,330602,330603,330604,330743,330746,330747,330749,330780,330801,330963,330968,330971,330992,331085,331102,331103,331123,331124,331566,331567,331568,331581,331799,331800,331801,331802,331872,331873,332290,332321,332332,332334,332383,332395,332396,332412,332414,332415,332417,332451,332457,332487,332488,332518,332604,332608,332687,332806,332827,332829,332832,332834,332839,332842,332845,332850,332852,333067,333068,333069,333252,333256,333932,333933,333934,333989,333990,333992,333995,333996,334073,334074,334080,334093,334094,334146,334147,334149,334250,335801,336084,336294,336409,336412,336416,336419,336422,336424,336427,336436,336541,336542,336543,336544,336601,336602,336603,336604,336605,336776,336777,336778,336793,336837,336839,336841,336842,336843,336844,336845,336860,336862,336891,336928,337105,337142,337146,337147,337339,337348,337351,337475,337737,337806,337816,337835,337836,337940,337968,338008,338482,338483,338565,338586,338771,338772,338773,338775,339386,340301,340304,340331,340333,340349,340564,340575,340576,340577,340635,340656,340657,340671,340727,340728,340744,340759,342210,342422,342471,342472,342473,342474,342475,342917,342918,342919,342920,342921,342923,342925,343141,343163,343307,344039,344129,344483,344852,344854,344855,344856,344857,344858,344883,345074,345075,345076,345078,345079,345080,345081,345082,345084,345085,345087,345088,345090,345091,345202,345218,345262,346672,346673,346674,346677,346795,346797,346880,346881,346886,346888,346890,346892,347006,347091,347092,347093,347094,347096,347141,347142,347144,347145,347152,347155,347158,347161,347162,347285,347286,347287,347898,347899,347900,348064,348065,348066,348067,348068,348287,348288,348503,348707,348708,348710,348711,348713,348716,348796,348859,348886,348887,349066,349067,349081,349124,349255,349256,349257,349679,349740,349792,349794,349796,349797,349819,349820,349821,349928,349930,349931,349932,349935,350156,350157,350159,350735,350807,350809,351997,351998,352000,352003,352004,352006,352029,352042,352055,352313,352481,352482,352483,352485,352539,352689,352760,352763,352767,353021,353212,353213,353214,353215,353281,353282,353283,353438,353443,353475,353519,353522,353525,353560,353848,353849,353850,354144,354148,354495,354782,355002,355007,355008,355032,355033,355037,355043,355044,355046,355047,355068,355069,355070,355071,355072,355073,355192,355195,355197,355199,355200,355201,355202,355203,355204,355468,355598,355706,355853,355939,355940,355941,356025,356541,356542,356543,356640,356641,356647,356652,356663,356853,357067,357123,357131,357181,357210,357376,357398,357399,357428,357501,357733,357737,357998,357999,358000,358297,358298,358299,358578,359219,359220,359221,359687,359708,359745,359752,359810,359813,359974,359975,359976,360000,360273,360279,360283,360727,360792,360793,360855,360863,361003,361011,361012,361013,361017,361037,361041,361276,361555,361556,361746,361768,361838,361848,361863,361877,362030,362042,362046,362050,362227,362270,362650,320161)

select distinct typ from getproducts1 where dept='Firearms' and brand='GLOCK' 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 (21980,21984,249643,211079,254302,356406,252191,361895,107250,250666,358574,130336,284331,361459,117149,107249,125120,326151,192180,334165,355114,117150,193087,207643,253322,284330,311569,123317,192191,192348,284333,22101,22107,22149,115236,252484,284334,284335,284342,326164,332822,356697,358863,362116,362359,201626,252085,355718,357248,21997,22008,22009,22131,22132,75427,75428,114698,114700,114702,115257,123319,128960,131326,134569,145264,147060,147481,147482,164889,168792,192179,192182,204002,205392,209452,212098,247857,250503,262276,284328,284329,284336,284340,284343,284347,303408,316441,326158,326160,355854,356843,357069,357499,358446,360681,361463,362376,363304,363305,147483,361275,361557,21846,21847,21848,21862,21875,21876,21882,21890,21893,21894,21898,21899,21903,21904,21906,21907,21909,21910,21911,21914,21916,21917,21938,21939,21949,21968,21970,21976,21978,21979,21981,21982,21983,21985,21986,21987,21988,21990,21991,21992,21993,21995,21996,21998,21999,22002,22004,22005,22051,22099,22111,22116,22117,22118,22119,22120,22122,22124,22125,22126,22128,22130,22134,22140,22143,22147,22152,22155,22156,58934,68065,69861,70344,72561,75425,75426,79706,84849,85224,85538,87100,89116,89117,91864,92318,93726,94613,95325,100304,101131,101734,101976,102132,102160,103596,105446,107789,108247,108383,108420,109257,109506,109836,110301,111730,112600,113252,113681,114911,115222,115235,115743,116984,117151,118406,118408,118410,118412,118455,119517,120222,121358,121561,123097,124097,124165,124625,124879,124880,125004,125099,125119,125320,125632,126892,126893,126894,129218,129220,129512,129589,129962,130110,130427,133411,133782,133783,133830,133921,134157,134427,134432,134542,135099,135268,135504,135962,135963,135965,136638,136701,137242,138209,140144,140212,141243,141289,141447,141480,141687,141710,143085,143805,143881,143907,143968,144450,144451,144452,144857,144858,144859,145074,145150,145371,147479,147936,147937,148388,148510,150974,150975,151743,152316,152696,153231,155176,155375,155690,156323,156324,158480,158524,159122,160904,161190,161335,161336,161337,161338,161339,161342,161343,161344,161345,161346,161347,161348,161349,161350,161351,161352,161398,161478,161688,161717,162204,163144,163201,163268,163307,163941,164015,164160,164336,164348,164473,164479,164665,164666,164667,164711,164762,164796,164797,164884,164929,164974,164978,164979,165130,165139,165144,165178,165191,165333,165499,165500,167701,167704,168047,168050,168065,168066,168100,168147,168148,168153,168154,168160,168175,168180,168182,168188,168420,168421,168535,168537,168538,168667,168668,168674,168675,168676,168677,168678,168679,168680,168681,168682,168683,168685,168686,168687,168688,168690,168692,168693,168694,168695,168696,168699,168700,168701,168702,168747,168748,168749,168750,168751,168752,168753,168754,168823,168825,168828,168829,168830,168831,168870,168871,169055,169438,169614,169615,170129,170130,170195,170196,170399,170401,170403,170624,170625,170626,170632,172685,172887,173265,173270,173864,173865,175328,175329,176373,176450,178694,178695,178696,179124,179258,179429,179516,179656,179739,179765,180046,181362,181414,181851,182003,183660,184009,184234,184291,184297,184351,184448,188243,188281,188282,188283,188731,189019,189166,189292,191490,191585,191727,191728,191729,192152,192163,192181,192230,192280,192470,193475,193477,193478,193613,193914,194032,195461,195462,195841,195892,195965,196022,196064,196068,196075,196289,197051,197069,197071,197081,197298,197299,197746,197824,197826,199965,201601,201820,201911,201971,202214,202215,202216,202217,202484,202485,202486,202998,203000,203233,205434,205959,206052,206090,206301,206319,206743,206778,206916,207038,207486,207957,207958,207959,208141,208203,208332,208657,208953,209189,209190,209449,209450,209451,209848,209876,209880,209984,210292,210422,211031,211062,211234,211235,211370,211371,211693,211786,211788,211940,212027,212293,213413,213424,213436,213461,213760,213762,214082,214429,214465,214466,214592,214677,214678,214679,214703,214715,214717,214809,214810,214894,214926,215557,215638,215888,215899,215902,216704,216890,216926,216927,217372,217479,217480,217481,217694,218045,218047,218048,218050,218051,218052,218053,218377,218479,219636,219638,219772,220072,220218,220339,220370,220472,220713,220747,220887,220958,220962,220965,220967,220968,220970,221074,221973,222232,222233,222465,225304,225306,225914,226059,227157,227160,227161,227162,228586,228595,228596,228604,228605,235864,236911,239391,239404,239406,242420,244961,245221,245238,245240,245413,245437,245438,245906,246049,246450,246451,246487,246903,246904,246905,246906,246907,246908,246909,246910,246911,246914,246915,246916,246917,246918,246919,246990,247526,247527,247899,249497,249500,249502,249570,249635,249636,249637,249638,249639,249640,249641,249642,249692,249693,250128,250140,250176,250181,250185,250265,250285,250418,250419,250426,250514,250515,250624,250667,250668,251208,251347,251640,251653,251724,251725,251897,251951,252022,252053,252054,252055,252141,252320,252653,252948,253029,253139,253246,253253,253298,253321,253324,253371,253372,253471,253556,253964,253969,253970,253986,254180,254200,254201,254252,254358,254359,254367,254505,254506,254509,255163,255435,255436,255438,255439,255440,255441,255563,255565,255566,255696,255697,255698,255786,255787,255790,255791,255809,256053,256072,256091,256092,256095,256192,256198,256201,256426,256508,256513,256569,256603,256682,256963,256979,257008,257010,257011,257017,257064,257065,257230,260459,260524,260576,260577,260578,260579,260778,260866,260877,260969,260972,260973,261047,261380,261382,261383,261384,261385,262052,262286,262289,262375,262443,262453,262832,262834,262997,263529,263654,263794,263809,263835,264298,264302,264592,264595,264600,264647,264653,264755,265018,266132,266133,266135,266136,266137,266289,266651,266703,266773,266965,267049,267050,267051,267069,267122,267139,267213,267255,267294,267295,267413,267465,267478,267783,268003,268037,268054,268386,268411,268665,268902,268909,268915,269008,269115,269192,269231,269232,269233,269395,269396,269397,269398,269399,269400,269401,269471,269482,269483,269484,269510,269511,269512,269550,269870,269872,269873,269874,269875,269876,269878,269880,269881,269882,269896,270864,270866,270867,270873,270874,270875,270876,270969,271440,271444,271959,272207,272259,272261,272675,272676,273114,273439,273562,273563,273564,273812,275743,275843,275957,275997,276111,276112,276206,276210,276211,276212,276213,276214,276408,276411,276414,276861,276862,276863,276864,277071,277072,277073,277075,277078,277079,277080,277488,277527,277529,277581,277881,277883,277884,277886,278904,279400,279407,279408,279410,279470,279471,279472,279475,279477,279606,279607,279971,279978,280001,280057,280064,280187,280190,280260,280273,280345,280347,280348,280392,280424,280453,280506,280507,280508,280509,280510,280511,280833,281155,281161,281162,281163,281199,281348,281422,281520,281522,281527,281530,281531,281638,281838,281839,281847,281848,281849,281938,282146,282147,282480,283358,283360,283446,283630,283800,283802,283824,283825,283852,283958,283990,284332,284337,284344,284994,285339,285341,285352,285353,285391,285392,285396,285404,285436,285678,285800,285801,285806,285821,285825,285826,285946,285948,285961,285963,286272,286274,286313,286768,286960,287275,287276,287277,287553,287554,287555,287557,287558,287559,287560,287562,287563,287564,287727,287768,287769,287771,287772,287775,287908,287916,287918,287919,287961,288021,288040,288084,288088,288732,288888,288889,288891,289430,289611,289612,289668,289895,290036,290037,290038,290041,290042,290357,290358,290495,290603,290656,290716,290788,290907,291230,291231,291236,291504,291554,291555,291556,291973,291974,291976,292091,292114,292130,292131,292132,292133,292134,292144,292145,292627,292678,292679,292681,293000,293066,293083,293084,293085,293086,293087,293210,293211,293212,293213,293214,293215,294603,294676,294679,294866,294867,294875,294882,294913,294932,294970,295067,296375,296380,296381,296389,296392,296394,296395,296462,296465,296472,296503,296576,296577,296582,296587,296591,296592,296593,296594,296618,296634,296637,296639,296647,296648,297047,297048,297049,297253,297254,297388,297389,297393,297540,297576,297777,297847,297885,297886,298393,298395,298398,298399,298549,298600,298689,298975,298977,299011,299026,299041,299051,299053,299065,299156,299372,300579,300580,300583,300584,300586,300596,300597,300598,300599,300601,300606,300612,300647,300675,300707,300708,300710,300712,300713,300730,300734,300735,300736,300737,300738,300739,301156,301174,301363,302658,302659,302660,303131,303407,303497,303511,303513,303537,303540,303626,303926,303927,303928,303929,303931,303932,303934,304685,304686,304687,304689,304690,304691,304695,304696,304697,304698,304699,304701,304703,304809,304878,304880,304882,304884,304887,304891,304894,304897,304898,304929,304957,305076,305090,305092,305120,305126,305550,305551,305598,305641,307231,307232,307672,307673,307674,307676,307706,307709,307710,307712,307713,307715,307717,307720,307722,307724,307725,307742,307748,307749,307750,307751,307758,307804,307806,307889,308064,308272,308273,308276,309328,309334,309345,309539,309614,309615,309617,309618,309812,309813,309814,309820,309821,309825,309977,309978,309979,309980,309981,309982,310072,310128,310274,310294,310300,310301,310302,310506,310646,310647,310648,310649,310650,310651,310652,310655,311629,311632,311746,311747,312050,312060,312356,312386,312390,312400,312401,312402,312424,316364,316459,316463,316465,316467,316468,316469,316471,316606,316633,316676,318623,318625,318626,319772,319773,319790,319797,319798,319799,319812,319813,319814,319816,319817,319818,319825,319826,319828,319830,319831,319832,319840,319932,319933,320124,320739,320740,320741,320743,320745,320746,322152,322153,322529,322531,322570,322598,322638,322639,322641,322643,322653,322655,322658,322661,323294,323343,323396,323552,323553,323554,323954,323965,324743,324775,324785,324803,324843,324879,325305,325308,325316,325322,325325,325326,325330,325332,325333,325334,325335,325336,325337,325343,325347,325355,326123,326156,326157,326161,326163,326210,326219,326220,326221,326280,326299,326300,326303,326310,326315,326319,326324,326327,326476,326477,326572,326632,326633,326637,326644,326645,326647,326651,328417,328768,328773,328774,328976,329022,329149,329269,329327,329353,329540,329544,329546,329548,329549,329550,329551,329600,329612,329613,329614,329738,329846,329951,330247,330248,330317,330318,330511,330513,330515,330519,330526,330601,330602,330603,330604,330743,330746,330747,330749,330780,330801,330963,330968,330971,330992,331085,331102,331103,331123,331124,331566,331567,331568,331581,331799,331800,331801,331802,331872,331873,332290,332321,332332,332334,332383,332395,332396,332412,332414,332415,332417,332451,332457,332487,332488,332518,332604,332608,332687,332806,332827,332829,332832,332834,332839,332842,332845,332850,332852,333067,333068,333069,333252,333256,333932,333933,333934,333989,333990,333992,333995,333996,334073,334074,334080,334093,334094,334146,334147,334149,334250,335801,336084,336294,336409,336412,336416,336419,336422,336424,336427,336436,336541,336542,336543,336544,336601,336602,336603,336604,336605,336776,336777,336778,336793,336837,336839,336841,336842,336843,336844,336845,336860,336862,336891,336928,337105,337142,337146,337147,337339,337348,337351,337475,337737,337806,337816,337835,337836,337940,337968,338008,338482,338483,338565,338586,338771,338772,338773,338775,339386,340301,340304,340331,340333,340349,340564,340575,340576,340577,340635,340656,340657,340671,340727,340728,340744,340759,342210,342422,342471,342472,342473,342474,342475,342917,342918,342919,342920,342921,342923,342925,343141,343163,343307,344039,344129,344483,344852,344854,344855,344856,344857,344858,344883,345074,345075,345076,345078,345079,345080,345081,345082,345084,345085,345087,345088,345090,345091,345202,345218,345262,346672,346673,346674,346677,346795,346797,346880,346881,346886,346888,346890,346892,347006,347091,347092,347093,347094,347096,347141,347142,347144,347145,347152,347155,347158,347161,347162,347285,347286,347287,347898,347899,347900,348064,348065,348066,348067,348068,348287,348288,348503,348707,348708,348710,348711,348713,348716,348796,348859,348886,348887,349066,349067,349081,349124,349255,349256,349257,349679,349740,349792,349794,349796,349797,349819,349820,349821,349928,349930,349931,349932,349935,350156,350157,350159,350735,350807,350809,351997,351998,352000,352003,352004,352006,352029,352042,352055,352313,352481,352482,352483,352485,352539,352689,352760,352763,352767,353021,353212,353213,353214,353215,353281,353282,353283,353438,353443,353475,353519,353522,353525,353560,353848,353849,353850,354144,354148,354495,354782,355002,355007,355008,355032,355033,355037,355043,355044,355046,355047,355068,355069,355070,355071,355072,355073,355192,355195,355197,355199,355200,355201,355202,355203,355204,355468,355598,355706,355853,355939,355940,355941,356025,356541,356542,356543,356640,356641,356647,356652,356663,356853,357067,357123,357131,357181,357210,357376,357398,357399,357428,357501,357733,357737,357998,357999,358000,358297,358298,358299,358578,359219,359220,359221,359687,359708,359745,359752,359810,359813,359974,359975,359976,360000,360273,360279,360283,360727,360792,360793,360855,360863,361003,361011,361012,361013,361017,361037,361041,361276,361555,361556,361746,361768,361838,361848,361863,361877,362030,362042,362046,362050,362227,362270,362650,320161)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='GLOCK' 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, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 29 and c.style_id in (21980,21984,249643,211079,254302,356406,252191,361895,107250,250666,358574,130336,284331,361459,117149,107249,125120,326151,192180,334165,355114,117150,193087,207643,253322,284330,311569,123317,192191,192348,284333,22101,22107,22149,115236,252484,284334,284335,284342,326164,332822,356697,358863,362116,362359,201626,252085,355718,357248,21997,22008,22009,22131,22132,75427,75428,114698,114700,114702,115257,123319,128960,131326,134569,145264,147060,147481,147482,164889,168792,192179,192182,204002,205392,209452,212098,247857,250503,262276,284328,284329,284336,284340,284343,284347,303408,316441,326158,326160,355854,356843,357069,357499,358446,360681,361463,362376,363304,363305,147483,361275,361557,21846,21847,21848,21862,21875,21876,21882,21890,21893,21894,21898,21899,21903,21904,21906,21907,21909,21910,21911,21914,21916,21917,21938,21939,21949,21968,21970,21976,21978,21979,21981,21982,21983,21985,21986,21987,21988,21990,21991,21992,21993,21995,21996,21998,21999,22002,22004,22005,22051,22099,22111,22116,22117,22118,22119,22120,22122,22124,22125,22126,22128,22130,22134,22140,22143,22147,22152,22155,22156,58934,68065,69861,70344,72561,75425,75426,79706,84849,85224,85538,87100,89116,89117,91864,92318,93726,94613,95325,100304,101131,101734,101976,102132,102160,103596,105446,107789,108247,108383,108420,109257,109506,109836,110301,111730,112600,113252,113681,114911,115222,115235,115743,116984,117151,118406,118408,118410,118412,118455,119517,120222,121358,121561,123097,124097,124165,124625,124879,124880,125004,125099,125119,125320,125632,126892,126893,126894,129218,129220,129512,129589,129962,130110,130427,133411,133782,133783,133830,133921,134157,134427,134432,134542,135099,135268,135504,135962,135963,135965,136638,136701,137242,138209,140144,140212,141243,141289,141447,141480,141687,141710,143085,143805,143881,143907,143968,144450,144451,144452,144857,144858,144859,145074,145150,145371,147479,147936,147937,148388,148510,150974,150975,151743,152316,152696,153231,155176,155375,155690,156323,156324,158480,158524,159122,160904,161190,161335,161336,161337,161338,161339,161342,161343,161344,161345,161346,161347,161348,161349,161350,161351,161352,161398,161478,161688,161717,162204,163144,163201,163268,163307,163941,164015,164160,164336,164348,164473,164479,164665,164666,164667,164711,164762,164796,164797,164884,164929,164974,164978,164979,165130,165139,165144,165178,165191,165333,165499,165500,167701,167704,168047,168050,168065,168066,168100,168147,168148,168153,168154,168160,168175,168180,168182,168188,168420,168421,168535,168537,168538,168667,168668,168674,168675,168676,168677,168678,168679,168680,168681,168682,168683,168685,168686,168687,168688,168690,168692,168693,168694,168695,168696,168699,168700,168701,168702,168747,168748,168749,168750,168751,168752,168753,168754,168823,168825,168828,168829,168830,168831,168870,168871,169055,169438,169614,169615,170129,170130,170195,170196,170399,170401,170403,170624,170625,170626,170632,172685,172887,173265,173270,173864,173865,175328,175329,176373,176450,178694,178695,178696,179124,179258,179429,179516,179656,179739,179765,180046,181362,181414,181851,182003,183660,184009,184234,184291,184297,184351,184448,188243,188281,188282,188283,188731,189019,189166,189292,191490,191585,191727,191728,191729,192152,192163,192181,192230,192280,192470,193475,193477,193478,193613,193914,194032,195461,195462,195841,195892,195965,196022,196064,196068,196075,196289,197051,197069,197071,197081,197298,197299,197746,197824,197826,199965,201601,201820,201911,201971,202214,202215,202216,202217,202484,202485,202486,202998,203000,203233,205434,205959,206052,206090,206301,206319,206743,206778,206916,207038,207486,207957,207958,207959,208141,208203,208332,208657,208953,209189,209190,209449,209450,209451,209848,209876,209880,209984,210292,210422,211031,211062,211234,211235,211370,211371,211693,211786,211788,211940,212027,212293,213413,213424,213436,213461,213760,213762,214082,214429,214465,214466,214592,214677,214678,214679,214703,214715,214717,214809,214810,214894,214926,215557,215638,215888,215899,215902,216704,216890,216926,216927,217372,217479,217480,217481,217694,218045,218047,218048,218050,218051,218052,218053,218377,218479,219636,219638,219772,220072,220218,220339,220370,220472,220713,220747,220887,220958,220962,220965,220967,220968,220970,221074,221973,222232,222233,222465,225304,225306,225914,226059,227157,227160,227161,227162,228586,228595,228596,228604,228605,235864,236911,239391,239404,239406,242420,244961,245221,245238,245240,245413,245437,245438,245906,246049,246450,246451,246487,246903,246904,246905,246906,246907,246908,246909,246910,246911,246914,246915,246916,246917,246918,246919,246990,247526,247527,247899,249497,249500,249502,249570,249635,249636,249637,249638,249639,249640,249641,249642,249692,249693,250128,250140,250176,250181,250185,250265,250285,250418,250419,250426,250514,250515,250624,250667,250668,251208,251347,251640,251653,251724,251725,251897,251951,252022,252053,252054,252055,252141,252320,252653,252948,253029,253139,253246,253253,253298,253321,253324,253371,253372,253471,253556,253964,253969,253970,253986,254180,254200,254201,254252,254358,254359,254367,254505,254506,254509,255163,255435,255436,255438,255439,255440,255441,255563,255565,255566,255696,255697,255698,255786,255787,255790,255791,255809,256053,256072,256091,256092,256095,256192,256198,256201,256426,256508,256513,256569,256603,256682,256963,256979,257008,257010,257011,257017,257064,257065,257230,260459,260524,260576,260577,260578,260579,260778,260866,260877,260969,260972,260973,261047,261380,261382,261383,261384,261385,262052,262286,262289,262375,262443,262453,262832,262834,262997,263529,263654,263794,263809,263835,264298,264302,264592,264595,264600,264647,264653,264755,265018,266132,266133,266135,266136,266137,266289,266651,266703,266773,266965,267049,267050,267051,267069,267122,267139,267213,267255,267294,267295,267413,267465,267478,267783,268003,268037,268054,268386,268411,268665,268902,268909,268915,269008,269115,269192,269231,269232,269233,269395,269396,269397,269398,269399,269400,269401,269471,269482,269483,269484,269510,269511,269512,269550,269870,269872,269873,269874,269875,269876,269878,269880,269881,269882,269896,270864,270866,270867,270873,270874,270875,270876,270969,271440,271444,271959,272207,272259,272261,272675,272676,273114,273439,273562,273563,273564,273812,275743,275843,275957,275997,276111,276112,276206,276210,276211,276212,276213,276214,276408,276411,276414,276861,276862,276863,276864,277071,277072,277073,277075,277078,277079,277080,277488,277527,277529,277581,277881,277883,277884,277886,278904,279400,279407,279408,279410,279470,279471,279472,279475,279477,279606,279607,279971,279978,280001,280057,280064,280187,280190,280260,280273,280345,280347,280348,280392,280424,280453,280506,280507,280508,280509,280510,280511,280833,281155,281161,281162,281163,281199,281348,281422,281520,281522,281527,281530,281531,281638,281838,281839,281847,281848,281849,281938,282146,282147,282480,283358,283360,283446,283630,283800,283802,283824,283825,283852,283958,283990,284332,284337,284344,284994,285339,285341,285352,285353,285391,285392,285396,285404,285436,285678,285800,285801,285806,285821,285825,285826,285946,285948,285961,285963,286272,286274,286313,286768,286960,287275,287276,287277,287553,287554,287555,287557,287558,287559,287560,287562,287563,287564,287727,287768,287769,287771,287772,287775,287908,287916,287918,287919,287961,288021,288040,288084,288088,288732,288888,288889,288891,289430,289611,289612,289668,289895,290036,290037,290038,290041,290042,290357,290358,290495,290603,290656,290716,290788,290907,291230,291231,291236,291504,291554,291555,291556,291973,291974,291976,292091,292114,292130,292131,292132,292133,292134,292144,292145,292627,292678,292679,292681,293000,293066,293083,293084,293085,293086,293087,293210,293211,293212,293213,293214,293215,294603,294676,294679,294866,294867,294875,294882,294913,294932,294970,295067,296375,296380,296381,296389,296392,296394,296395,296462,296465,296472,296503,296576,296577,296582,296587,296591,296592,296593,296594,296618,296634,296637,296639,296647,296648,297047,297048,297049,297253,297254,297388,297389,297393,297540,297576,297777,297847,297885,297886,298393,298395,298398,298399,298549,298600,298689,298975,298977,299011,299026,299041,299051,299053,299065,299156,299372,300579,300580,300583,300584,300586,300596,300597,300598,300599,300601,300606,300612,300647,300675,300707,300708,300710,300712,300713,300730,300734,300735,300736,300737,300738,300739,301156,301174,301363,302658,302659,302660,303131,303407,303497,303511,303513,303537,303540,303626,303926,303927,303928,303929,303931,303932,303934,304685,304686,304687,304689,304690,304691,304695,304696,304697,304698,304699,304701,304703,304809,304878,304880,304882,304884,304887,304891,304894,304897,304898,304929,304957,305076,305090,305092,305120,305126,305550,305551,305598,305641,307231,307232,307672,307673,307674,307676,307706,307709,307710,307712,307713,307715,307717,307720,307722,307724,307725,307742,307748,307749,307750,307751,307758,307804,307806,307889,308064,308272,308273,308276,309328,309334,309345,309539,309614,309615,309617,309618,309812,309813,309814,309820,309821,309825,309977,309978,309979,309980,309981,309982,310072,310128,310274,310294,310300,310301,310302,310506,310646,310647,310648,310649,310650,310651,310652,310655,311629,311632,311746,311747,312050,312060,312356,312386,312390,312400,312401,312402,312424,316364,316459,316463,316465,316467,316468,316469,316471,316606,316633,316676,318623,318625,318626,319772,319773,319790,319797,319798,319799,319812,319813,319814,319816,319817,319818,319825,319826,319828,319830,319831,319832,319840,319932,319933,320124,320739,320740,320741,320743,320745,320746,322152,322153,322529,322531,322570,322598,322638,322639,322641,322643,322653,322655,322658,322661,323294,323343,323396,323552,323553,323554,323954,323965,324743,324775,324785,324803,324843,324879,325305,325308,325316,325322,325325,325326,325330,325332,325333,325334,325335,325336,325337,325343,325347,325355,326123,326156,326157,326161,326163,326210,326219,326220,326221,326280,326299,326300,326303,326310,326315,326319,326324,326327,326476,326477,326572,326632,326633,326637,326644,326645,326647,326651,328417,328768,328773,328774,328976,329022,329149,329269,329327,329353,329540,329544,329546,329548,329549,329550,329551,329600,329612,329613,329614,329738,329846,329951,330247,330248,330317,330318,330511,330513,330515,330519,330526,330601,330602,330603,330604,330743,330746,330747,330749,330780,330801,330963,330968,330971,330992,331085,331102,331103,331123,331124,331566,331567,331568,331581,331799,331800,331801,331802,331872,331873,332290,332321,332332,332334,332383,332395,332396,332412,332414,332415,332417,332451,332457,332487,332488,332518,332604,332608,332687,332806,332827,332829,332832,332834,332839,332842,332845,332850,332852,333067,333068,333069,333252,333256,333932,333933,333934,333989,333990,333992,333995,333996,334073,334074,334080,334093,334094,334146,334147,334149,334250,335801,336084,336294,336409,336412,336416,336419,336422,336424,336427,336436,336541,336542,336543,336544,336601,336602,336603,336604,336605,336776,336777,336778,336793,336837,336839,336841,336842,336843,336844,336845,336860,336862,336891,336928,337105,337142,337146,337147,337339,337348,337351,337475,337737,337806,337816,337835,337836,337940,337968,338008,338482,338483,338565,338586,338771,338772,338773,338775,339386,340301,340304,340331,340333,340349,340564,340575,340576,340577,340635,340656,340657,340671,340727,340728,340744,340759,342210,342422,342471,342472,342473,342474,342475,342917,342918,342919,342920,342921,342923,342925,343141,343163,343307,344039,344129,344483,344852,344854,344855,344856,344857,344858,344883,345074,345075,345076,345078,345079,345080,345081,345082,345084,345085,345087,345088,345090,345091,345202,345218,345262,346672,346673,346674,346677,346795,346797,346880,346881,346886,346888,346890,346892,347006,347091,347092,347093,347094,347096,347141,347142,347144,347145,347152,347155,347158,347161,347162,347285,347286,347287,347898,347899,347900,348064,348065,348066,348067,348068,348287,348288,348503,348707,348708,348710,348711,348713,348716,348796,348859,348886,348887,349066,349067,349081,349124,349255,349256,349257,349679,349740,349792,349794,349796,349797,349819,349820,349821,349928,349930,349931,349932,349935,350156,350157,350159,350735,350807,350809,351997,351998,352000,352003,352004,352006,352029,352042,352055,352313,352481,352482,352483,352485,352539,352689,352760,352763,352767,353021,353212,353213,353214,353215,353281,353282,353283,353438,353443,353475,353519,353522,353525,353560,353848,353849,353850,354144,354148,354495,354782,355002,355007,355008,355032,355033,355037,355043,355044,355046,355047,355068,355069,355070,355071,355072,355073,355192,355195,355197,355199,355200,355201,355202,355203,355204,355468,355598,355706,355853,355939,355940,355941,356025,356541,356542,356543,356640,356641,356647,356652,356663,356853,357067,357123,357131,357181,357210,357376,357398,357399,357428,357501,357733,357737,357998,357999,358000,358297,358298,358299,358578,359219,359220,359221,359687,359708,359745,359752,359810,359813,359974,359975,359976,360000,360273,360279,360283,360727,360792,360793,360855,360863,361003,361011,361012,361013,361017,361037,361041,361276,361555,361556,361746,361768,361838,361848,361863,361877,362030,362042,362046,362050,362227,362270,362650,320161)

select distinct typ from getproducts1 where dept='Law Enforcement' and brand='GLOCK' 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='Law Enforcement' and typ='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='Outdoor Recreation' 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 = 3565 and c.style_id in (21980,21984,249643,211079,254302,356406,252191,361895,107250,250666,358574,130336,284331,361459,117149,107249,125120,326151,192180,334165,355114,117150,193087,207643,253322,284330,311569,123317,192191,192348,284333,22101,22107,22149,115236,252484,284334,284335,284342,326164,332822,356697,358863,362116,362359,201626,252085,355718,357248,21997,22008,22009,22131,22132,75427,75428,114698,114700,114702,115257,123319,128960,131326,134569,145264,147060,147481,147482,164889,168792,192179,192182,204002,205392,209452,212098,247857,250503,262276,284328,284329,284336,284340,284343,284347,303408,316441,326158,326160,355854,356843,357069,357499,358446,360681,361463,362376,363304,363305,147483,361275,361557,21846,21847,21848,21862,21875,21876,21882,21890,21893,21894,21898,21899,21903,21904,21906,21907,21909,21910,21911,21914,21916,21917,21938,21939,21949,21968,21970,21976,21978,21979,21981,21982,21983,21985,21986,21987,21988,21990,21991,21992,21993,21995,21996,21998,21999,22002,22004,22005,22051,22099,22111,22116,22117,22118,22119,22120,22122,22124,22125,22126,22128,22130,22134,22140,22143,22147,22152,22155,22156,58934,68065,69861,70344,72561,75425,75426,79706,84849,85224,85538,87100,89116,89117,91864,92318,93726,94613,95325,100304,101131,101734,101976,102132,102160,103596,105446,107789,108247,108383,108420,109257,109506,109836,110301,111730,112600,113252,113681,114911,115222,115235,115743,116984,117151,118406,118408,118410,118412,118455,119517,120222,121358,121561,123097,124097,124165,124625,124879,124880,125004,125099,125119,125320,125632,126892,126893,126894,129218,129220,129512,129589,129962,130110,130427,133411,133782,133783,133830,133921,134157,134427,134432,134542,135099,135268,135504,135962,135963,135965,136638,136701,137242,138209,140144,140212,141243,141289,141447,141480,141687,141710,143085,143805,143881,143907,143968,144450,144451,144452,144857,144858,144859,145074,145150,145371,147479,147936,147937,148388,148510,150974,150975,151743,152316,152696,153231,155176,155375,155690,156323,156324,158480,158524,159122,160904,161190,161335,161336,161337,161338,161339,161342,161343,161344,161345,161346,161347,161348,161349,161350,161351,161352,161398,161478,161688,161717,162204,163144,163201,163268,163307,163941,164015,164160,164336,164348,164473,164479,164665,164666,164667,164711,164762,164796,164797,164884,164929,164974,164978,164979,165130,165139,165144,165178,165191,165333,165499,165500,167701,167704,168047,168050,168065,168066,168100,168147,168148,168153,168154,168160,168175,168180,168182,168188,168420,168421,168535,168537,168538,168667,168668,168674,168675,168676,168677,168678,168679,168680,168681,168682,168683,168685,168686,168687,168688,168690,168692,168693,168694,168695,168696,168699,168700,168701,168702,168747,168748,168749,168750,168751,168752,168753,168754,168823,168825,168828,168829,168830,168831,168870,168871,169055,169438,169614,169615,170129,170130,170195,170196,170399,170401,170403,170624,170625,170626,170632,172685,172887,173265,173270,173864,173865,175328,175329,176373,176450,178694,178695,178696,179124,179258,179429,179516,179656,179739,179765,180046,181362,181414,181851,182003,183660,184009,184234,184291,184297,184351,184448,188243,188281,188282,188283,188731,189019,189166,189292,191490,191585,191727,191728,191729,192152,192163,192181,192230,192280,192470,193475,193477,193478,193613,193914,194032,195461,195462,195841,195892,195965,196022,196064,196068,196075,196289,197051,197069,197071,197081,197298,197299,197746,197824,197826,199965,201601,201820,201911,201971,202214,202215,202216,202217,202484,202485,202486,202998,203000,203233,205434,205959,206052,206090,206301,206319,206743,206778,206916,207038,207486,207957,207958,207959,208141,208203,208332,208657,208953,209189,209190,209449,209450,209451,209848,209876,209880,209984,210292,210422,211031,211062,211234,211235,211370,211371,211693,211786,211788,211940,212027,212293,213413,213424,213436,213461,213760,213762,214082,214429,214465,214466,214592,214677,214678,214679,214703,214715,214717,214809,214810,214894,214926,215557,215638,215888,215899,215902,216704,216890,216926,216927,217372,217479,217480,217481,217694,218045,218047,218048,218050,218051,218052,218053,218377,218479,219636,219638,219772,220072,220218,220339,220370,220472,220713,220747,220887,220958,220962,220965,220967,220968,220970,221074,221973,222232,222233,222465,225304,225306,225914,226059,227157,227160,227161,227162,228586,228595,228596,228604,228605,235864,236911,239391,239404,239406,242420,244961,245221,245238,245240,245413,245437,245438,245906,246049,246450,246451,246487,246903,246904,246905,246906,246907,246908,246909,246910,246911,246914,246915,246916,246917,246918,246919,246990,247526,247527,247899,249497,249500,249502,249570,249635,249636,249637,249638,249639,249640,249641,249642,249692,249693,250128,250140,250176,250181,250185,250265,250285,250418,250419,250426,250514,250515,250624,250667,250668,251208,251347,251640,251653,251724,251725,251897,251951,252022,252053,252054,252055,252141,252320,252653,252948,253029,253139,253246,253253,253298,253321,253324,253371,253372,253471,253556,253964,253969,253970,253986,254180,254200,254201,254252,254358,254359,254367,254505,254506,254509,255163,255435,255436,255438,255439,255440,255441,255563,255565,255566,255696,255697,255698,255786,255787,255790,255791,255809,256053,256072,256091,256092,256095,256192,256198,256201,256426,256508,256513,256569,256603,256682,256963,256979,257008,257010,257011,257017,257064,257065,257230,260459,260524,260576,260577,260578,260579,260778,260866,260877,260969,260972,260973,261047,261380,261382,261383,261384,261385,262052,262286,262289,262375,262443,262453,262832,262834,262997,263529,263654,263794,263809,263835,264298,264302,264592,264595,264600,264647,264653,264755,265018,266132,266133,266135,266136,266137,266289,266651,266703,266773,266965,267049,267050,267051,267069,267122,267139,267213,267255,267294,267295,267413,267465,267478,267783,268003,268037,268054,268386,268411,268665,268902,268909,268915,269008,269115,269192,269231,269232,269233,269395,269396,269397,269398,269399,269400,269401,269471,269482,269483,269484,269510,269511,269512,269550,269870,269872,269873,269874,269875,269876,269878,269880,269881,269882,269896,270864,270866,270867,270873,270874,270875,270876,270969,271440,271444,271959,272207,272259,272261,272675,272676,273114,273439,273562,273563,273564,273812,275743,275843,275957,275997,276111,276112,276206,276210,276211,276212,276213,276214,276408,276411,276414,276861,276862,276863,276864,277071,277072,277073,277075,277078,277079,277080,277488,277527,277529,277581,277881,277883,277884,277886,278904,279400,279407,279408,279410,279470,279471,279472,279475,279477,279606,279607,279971,279978,280001,280057,280064,280187,280190,280260,280273,280345,280347,280348,280392,280424,280453,280506,280507,280508,280509,280510,280511,280833,281155,281161,281162,281163,281199,281348,281422,281520,281522,281527,281530,281531,281638,281838,281839,281847,281848,281849,281938,282146,282147,282480,283358,283360,283446,283630,283800,283802,283824,283825,283852,283958,283990,284332,284337,284344,284994,285339,285341,285352,285353,285391,285392,285396,285404,285436,285678,285800,285801,285806,285821,285825,285826,285946,285948,285961,285963,286272,286274,286313,286768,286960,287275,287276,287277,287553,287554,287555,287557,287558,287559,287560,287562,287563,287564,287727,287768,287769,287771,287772,287775,287908,287916,287918,287919,287961,288021,288040,288084,288088,288732,288888,288889,288891,289430,289611,289612,289668,289895,290036,290037,290038,290041,290042,290357,290358,290495,290603,290656,290716,290788,290907,291230,291231,291236,291504,291554,291555,291556,291973,291974,291976,292091,292114,292130,292131,292132,292133,292134,292144,292145,292627,292678,292679,292681,293000,293066,293083,293084,293085,293086,293087,293210,293211,293212,293213,293214,293215,294603,294676,294679,294866,294867,294875,294882,294913,294932,294970,295067,296375,296380,296381,296389,296392,296394,296395,296462,296465,296472,296503,296576,296577,296582,296587,296591,296592,296593,296594,296618,296634,296637,296639,296647,296648,297047,297048,297049,297253,297254,297388,297389,297393,297540,297576,297777,297847,297885,297886,298393,298395,298398,298399,298549,298600,298689,298975,298977,299011,299026,299041,299051,299053,299065,299156,299372,300579,300580,300583,300584,300586,300596,300597,300598,300599,300601,300606,300612,300647,300675,300707,300708,300710,300712,300713,300730,300734,300735,300736,300737,300738,300739,301156,301174,301363,302658,302659,302660,303131,303407,303497,303511,303513,303537,303540,303626,303926,303927,303928,303929,303931,303932,303934,304685,304686,304687,304689,304690,304691,304695,304696,304697,304698,304699,304701,304703,304809,304878,304880,304882,304884,304887,304891,304894,304897,304898,304929,304957,305076,305090,305092,305120,305126,305550,305551,305598,305641,307231,307232,307672,307673,307674,307676,307706,307709,307710,307712,307713,307715,307717,307720,307722,307724,307725,307742,307748,307749,307750,307751,307758,307804,307806,307889,308064,308272,308273,308276,309328,309334,309345,309539,309614,309615,309617,309618,309812,309813,309814,309820,309821,309825,309977,309978,309979,309980,309981,309982,310072,310128,310274,310294,310300,310301,310302,310506,310646,310647,310648,310649,310650,310651,310652,310655,311629,311632,311746,311747,312050,312060,312356,312386,312390,312400,312401,312402,312424,316364,316459,316463,316465,316467,316468,316469,316471,316606,316633,316676,318623,318625,318626,319772,319773,319790,319797,319798,319799,319812,319813,319814,319816,319817,319818,319825,319826,319828,319830,319831,319832,319840,319932,319933,320124,320739,320740,320741,320743,320745,320746,322152,322153,322529,322531,322570,322598,322638,322639,322641,322643,322653,322655,322658,322661,323294,323343,323396,323552,323553,323554,323954,323965,324743,324775,324785,324803,324843,324879,325305,325308,325316,325322,325325,325326,325330,325332,325333,325334,325335,325336,325337,325343,325347,325355,326123,326156,326157,326161,326163,326210,326219,326220,326221,326280,326299,326300,326303,326310,326315,326319,326324,326327,326476,326477,326572,326632,326633,326637,326644,326645,326647,326651,328417,328768,328773,328774,328976,329022,329149,329269,329327,329353,329540,329544,329546,329548,329549,329550,329551,329600,329612,329613,329614,329738,329846,329951,330247,330248,330317,330318,330511,330513,330515,330519,330526,330601,330602,330603,330604,330743,330746,330747,330749,330780,330801,330963,330968,330971,330992,331085,331102,331103,331123,331124,331566,331567,331568,331581,331799,331800,331801,331802,331872,331873,332290,332321,332332,332334,332383,332395,332396,332412,332414,332415,332417,332451,332457,332487,332488,332518,332604,332608,332687,332806,332827,332829,332832,332834,332839,332842,332845,332850,332852,333067,333068,333069,333252,333256,333932,333933,333934,333989,333990,333992,333995,333996,334073,334074,334080,334093,334094,334146,334147,334149,334250,335801,336084,336294,336409,336412,336416,336419,336422,336424,336427,336436,336541,336542,336543,336544,336601,336602,336603,336604,336605,336776,336777,336778,336793,336837,336839,336841,336842,336843,336844,336845,336860,336862,336891,336928,337105,337142,337146,337147,337339,337348,337351,337475,337737,337806,337816,337835,337836,337940,337968,338008,338482,338483,338565,338586,338771,338772,338773,338775,339386,340301,340304,340331,340333,340349,340564,340575,340576,340577,340635,340656,340657,340671,340727,340728,340744,340759,342210,342422,342471,342472,342473,342474,342475,342917,342918,342919,342920,342921,342923,342925,343141,343163,343307,344039,344129,344483,344852,344854,344855,344856,344857,344858,344883,345074,345075,345076,345078,345079,345080,345081,345082,345084,345085,345087,345088,345090,345091,345202,345218,345262,346672,346673,346674,346677,346795,346797,346880,346881,346886,346888,346890,346892,347006,347091,347092,347093,347094,347096,347141,347142,347144,347145,347152,347155,347158,347161,347162,347285,347286,347287,347898,347899,347900,348064,348065,348066,348067,348068,348287,348288,348503,348707,348708,348710,348711,348713,348716,348796,348859,348886,348887,349066,349067,349081,349124,349255,349256,349257,349679,349740,349792,349794,349796,349797,349819,349820,349821,349928,349930,349931,349932,349935,350156,350157,350159,350735,350807,350809,351997,351998,352000,352003,352004,352006,352029,352042,352055,352313,352481,352482,352483,352485,352539,352689,352760,352763,352767,353021,353212,353213,353214,353215,353281,353282,353283,353438,353443,353475,353519,353522,353525,353560,353848,353849,353850,354144,354148,354495,354782,355002,355007,355008,355032,355033,355037,355043,355044,355046,355047,355068,355069,355070,355071,355072,355073,355192,355195,355197,355199,355200,355201,355202,355203,355204,355468,355598,355706,355853,355939,355940,355941,356025,356541,356542,356543,356640,356641,356647,356652,356663,356853,357067,357123,357131,357181,357210,357376,357398,357399,357428,357501,357733,357737,357998,357999,358000,358297,358298,358299,358578,359219,359220,359221,359687,359708,359745,359752,359810,359813,359974,359975,359976,360000,360273,360279,360283,360727,360792,360793,360855,360863,361003,361011,361012,361013,361017,361037,361041,361276,361555,361556,361746,361768,361838,361848,361863,361877,362030,362042,362046,362050,362227,362270,362650,320161)

select distinct typ from getproducts1 where dept='Outdoor Recreation' and brand='GLOCK' 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='Outdoor Recreation' and typ='Drinkwear & Accessories' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Outdoor Recreation' and typ='Knives & Tools' and subtyp_1='EMPTY' and site = 'sportsman'

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

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

			from tb_skus a with (nolock)

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

			where a.style_id = 347287 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 = 347287 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=347287

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

select * from tb_product_reviews with (nolock) where style_id=347287  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=347287 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 = 347898 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 = 347898 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=347898

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

select * from tb_product_reviews with (nolock) where style_id=347898  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=347898 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 = 347899 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 = 347899 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=347899

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

select * from tb_product_reviews with (nolock) where style_id=347899  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=347899 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 = 347900 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 = 347900 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=347900

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

select * from tb_product_reviews with (nolock) where style_id=347900  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=347900 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 = 348064 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 = 348064 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348064

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

select * from tb_product_reviews with (nolock) where style_id=348064  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=348064 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 = 348065 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 = 348065 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348065

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

select * from tb_product_reviews with (nolock) where style_id=348065  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=348065 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 = 348066 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 = 348066 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348066

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

select * from tb_product_reviews with (nolock) where style_id=348066  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=348066 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 = 348067 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 = 348067 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348067

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

select * from tb_product_reviews with (nolock) where style_id=348067  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=348067 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 = 348068 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 = 348068 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348068

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

select * from tb_product_reviews with (nolock) where style_id=348068  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=348068 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 = 348287 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 = 348287 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 16:31:10' and
end_date >= 'Apr 13, 2026 16:31:10'
and store_id=10 and style_id=348287

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

select * from tb_product_reviews with (nolock) where style_id=348716  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=348716 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=S_U_F345=Y; USERNAME=""; LAST_NAME=""; CUSTOMER_ID=""; FIRST_NAME=""; EMAIL=""; CFID=Z4joj6qrkm3od1lmwralrv08p89d4av1gjql6k28gz3tw2hee1-22857161; CFTOKEN=Z4joj6qrkm3od1lmwralrv08p89d4av1gjql6k28gz3tw2hee1-974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB; PASSWORD=""; CFGLOBALS=urltoken%3DCFID%23%3D22857161%26CFTOKEN%23%3D974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB%23lastvisit%3D%7Bts%20%272026%2D04%2D13%2016%3A31%3A09%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D04%2D13%2016%3A31%3A08%27%7D%23cftoken%3D974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB%23cfid%3D22857161%23
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/98/brand/glock
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/98/brand/glock
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=22857161
cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
hitcount=2
lastvisit={ts '2026-04-13 16:31:09'}
timecreated={ts '2026-04-13 16:31:08'}
urltoken=CFID=22857161&CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB

Cookie Variables:
CFGLOBALS=urltoken=CFID#=22857161&CFTOKEN#=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB#lastvisit={ts '2026-04-13 16:31:09'}#hitcount=2#timecreated={ts '2026-04-13 16:31:08'}#cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB#cfid=22857161#
CFID=22857161
CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
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=22857161
cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
cs=/category.cfm/CurrentPage/98/brand/glock
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22857161_974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
strarray=Array (0)
urltoken=CFID=22857161&CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB

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