Top Deals

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=10

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)

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 qq.status_finish <> 'Y' and c.store_id=10 
	
	and (a.style_id in (1304,1327,1333,1355,2009,3832,4636,4735,7539,10164,10913,10918,11751,11767,11827,12651,12664,12665,12666,12684,12705,12709,12713,12714,12715,12716,12720,12725,12729,15689,16264,19035,19053,19054,19058,19061,19070,19071,19076,19080,19084,19089,19101,19102,19158,19161,19162,19164,19166,19181,19189,19191,19192,19249,19284,19286,19361,19395,19405,19406,19408,19410,19413,19439,22009,22101,23377,23384,23385,23390,23407,23408,23547,23549,23550,23551,24029,24181,24192,24603,24620,24623,24626,24645,24651,24652,24653,24654,24656,24659,24663,24665,24673,24678,24680,24684,24700,24701,24704,24717,24720,24723,24732,24736,24742,24745,24746,24747,28049,28288,28291,28292,28294,28308,28310,28313,29953,29981,30056,30223,31836,31845,32286,32293,34461,35061,35151,36605,36608,36614,39143,39151,42301,44618,44626,44652,44655,44665,44677,44690,44697,44705,44706,44707,44732,44753,44754,44766,44767,44768,44773,44774,44901,44903,44908,44912,44924,46449,48792,48800,48818,48829,48840,48860,48875,48883,48885,48916,48943,48946,50236,50237,50262,50263,50264,50314,50315,50317,50318,50324,50325,50326,50327,50329,51464,51465,56320,57083,57088,57160,60181,60210,60296,60298,60301,61113,61114,61122,61126,61127,61130,61225,61230,61376,61377,61382,61394,61395,61400,61401,61403,61421,61424,61431,61445,61451,61458,61479,61481,61482,61804,61805,61807,61808,61809,61814,61815,61871,61872,61873,61936,61943,61961,61962,61967,61968,61971,61981,61992,64077,64137,64138,64750,66338,67023,69032,70172,70309,70403,70715,70728,70730,72107,72158,72706,73264,74002,74036,74038,74070,74138,74484,74958,75039,75189,75427,75428,76572,77459,77461,77682,77968,78583,78584,78796,79377,79544,79660,79794,79795,79854,79919,81772,81774,81775,81885,83835,84712,85213,85564,85743,86668,86844,86983,87281,87656,88286,88657,88658,90275,90618,90922,91341,91798,91874,91967,92249,93669,94151,94165,94166,94392,94743,94746,95822,97042,97292,97504,98468,98845,98896,99010,99242,99490,99497,99974,100867,101397,101765,101928,101929,101930,101931,102277,102772,103205,103481,103715,103718,104216,104298,104299,104301,104378,104468,104501,104789,105569,105622,105627,105799,105803,106530,106559,107249,108230,109580,109828,110828,112304,113024,113118,113217,113334,113766,113889,114029,114030,114032,114038,114201,114206,114207,114255,114866,116780,117149,117150,117784,117844,118320,118885,118963,119450,120026,120193,120234,120235,120298,120350,121254,121523,121524,121995,121996,122000,122001,122002,122003,122004,122005,122006,122007,122010,122011,122014,122022,122057,122063,122138,122142,122230,122532,122660,123161,123307,123317,123330,123531,124445,124548,124801,124878,125108,125435,126271,127017,127080,127095,127096,127471,127624,128459,128522,128949,130112,130219,130259,130891,131033,132297,133528,133561,133805,133809,133815,133817,133911,134424,134480,134551,134612,135018,135771,136189,136466,136845,136859,136939,137062,137064,138138,138322,138589,140013,140024,140031,140170,141249,141252,141296,142844,143197,143656,144547,144635,144803,144873,145315,147334,147504,147669,148056,148141,148483,148580,148591,148857,149391,149901,150089,150380,150415,150574,150575,150591,150677,150678,150679,150680,150725,150827,150828,150831,151095,151448,151449,151450,151705,151748,151846,151995,152477,153330,155808,157812,157849,158185,158186,158307,158874,159445,159446,161144,161216,161416,161439,161447,161639,161647,161686,161934,163074,163227,163336,163582,163720,163772,164202,164334,164409,164604,164605,164606,164607,164608,164611,164612,164613,164615,164617,164619,164627,164631,164632,164636,164654,164848,164915,165535,168036,168050,168309,168319,168322,168369,168435,168572,168709,168754,168795,168815,168816,168817,168818,168819,168822,168824,168826,168827,168832,168833,168834,169080,169270,170065,170092,170367,170637,170810,172324,172325,172654,172668,172683,173214,173489,175663,175850,178616,178889,179265,179435,179483,179484,179488,179493,179494,179496,179502,179531,179664,179672,179954,181143,181144,181258,181270,181811,181812,181920,181921,181940,181947,181948,182241,183796,183797,183798,183799,183801,183805,183806,183814,183818,183821,183830,183839,183842,183844,183846,183847,183850,184154,184524,185568,185569,185571,185572,185573,185574,185577,185593,185601,185603,186699,186732,186873,186875,186876,188427,188445,188447,188562,188563,188564,188565,188566,188845,188921,189449,189474,189598,189773,189776,189778,189940,189941,191335,191890,191971,192164,192191,192348,192426,192871,192900,192901,192948,192956,193049,193604,193668,193859,195973,195975,196303,196898,197004,197120,197391,197510,197918,198210,198319,198535,198582,198816,198817,199005,199082,199110,199111,199531,199850,199993,199996,199997,200004,200009,200013,200019,200048,200049,200053,200054,200055,200181,200182,200243,200248,200251,200294,200295,200296,200558,200785,201205,201206,201608,201672,202119,202366,202424,202477,202482,202491,202492,202659,202660,202666,202669,202688,202691,202703,202709,202713,202714,202738,202782,202783,202856,202869,203025,203476,203515,203617,203618,203635,203917,204023,204029,204030,204031,204064,204069,204183,204306,204584,204585,204586,204589,204821,204829,204900,204916,205000,205465,205613,205614,205887,205959,205983,205992,206075,206106,206109,206111,206199,206294,206296,206297,206421,206470,207234,207243,207244,207336,207414,207437,208009,208201,208357,208893,209061,209114,209115,209117,209122,209199,209200,209486,209497,209500,209502,209506,209767,210101,210105,210201,210262,210267,210270,210309,210684,211004,211300,212089,212097,212576,212578,212813,213026,213316,213567,213576,213579,213581,213584,213585,213591,213592,213730,213783,213912,214026,214027,214029,214032,214264,214629,214798,214813,215059,215060,215063,215086,215088,215094,215137,215539,215638,215810,215820,216110,216201,216290,216569,216705,216708,216709,216713,216752,216779,216790,216793,216944,216945,216971,216983,217172,217242,217322,217358,217416,217481,217525,217650,217711,217903,217906,217907,217978,217980,218021,218035,218038,218041,218042,218049,218237,218297,218326,218468,218558,219772,219773,219779,219799,219801,219950,219952,220136,220282,220479,220583,221125,221154,222129,222163,222329,222474,222706,222768,223025,223031,223100,223106,223134,223152,223168,223170,225241,225431,225432,225950,225951,225959,227196,227209,227233,227251,227302,227452,227455,227457,227458,227459,227466,227469,227470,227471,227473,227474,227477,227478,227545,227800,227891,227931,227933,228108,228153,228173,228207,231801,232241,232591,242470,242506,244952,244957,244983,245142,245409,245411,245440,245479,245481,245482,245484,245493,245499,245502,245506,245508,245527,246100,246117,246119,246302,246438,246947,247013,247015,247016,247017,247019,247020,247021,247043,247082,247090,247096,247136,247322,247364,247483,247485,247488,247490,247518,247647,247986,247992,247994,248047,248197,248198,248199,248200,248201,248208,248214,248223,248332,248333,248431,248433,248440,248442,248473,248733,248846,249066,249177,249242,249249,249289,249322,249333,249451,249730,249733,249847,249877,249953,250023,250031,250035,250041,250042,250044,250048,250057,250135,250235,250437,250475,250479,250480,250484,250489,250494,250495,250704,250770,250776,250777,250778,250779,250965,251047,251055,251056,251097,251106,251108,251144,251197,251199,251342,251464,251522,251757,251778,251902,252016,252071,252085,252227,252485,252744,252747,252757,252766,252828,252841,252864,253196,253324,253362,253415,253420,253425,253544,253593,253594,253662,253667,253671,253672,253677,253692,253717,253718,253729,254025,254027,254029,254069,254084,254090,254141,254142,254144,254531,254545,255035,255376,255635,255655,255690,256074,256093,256161,256285,256288,256609,256734,256746,256749,256791,257075,257129,257174,257192,257193,257194,257204,257266,257273,260459,260558,260611,260614,260716,260717,260720,260753,260845,260920,261225,261513,261539,261702,261711,261765,261802,261827,261828,261885,261913,261914,261947,262009,262051,262084,262106,262111,262112,262117,262123,262133,262145,262148,262151,262155,262168,262183,262255,262256,262522,262533,262536,262537,262590,262593,262599,262658,262662,262706,262717,262721,262723,262731,262752,262755,262948,262967,263033,263034,263383,263397,263398,263654,263707,264015,264033,264060,264081,264082,264083,264086,264102,264109,264153,264154,264155,264156,264222,264460,264474,264475,264476,264477,264479,264481,264608,264676,264678,264688,264753,264833,264846,266044,266207,266292,266383,266407,266442,266656,266801,266806,266816,266817,266940,266942,267088,267089,267093,267109,267126,267275,267430,267495,267496,267522,267523,267544,268020,268177,268182,268703,269101,269128,269451,269965,270023,270027,270066,270068,270070,270073,270116,270299,270732,270853,270856,270857,270865,270994,271016,271206,271321,271328,271475,271575,271887,272181,272230,272566,272706,272735,273164,273335,273376,273379,273401,273430,273442,273465,273466,273489,273490,273492,273494,273497,273500,273501,273595,273599,273612,273616,273623,273633,273662,273666,274368,274419,274444,274480,274485,274487,274488,274490,274494,274497,274499,274501,274502,274503,274504,274507,274508,274509,275679,275980,276024,276050,276181,276182,276316,276720,276776,276789,276791,276793,276794,276852,276880,276911,276929,276932,276939,276940,276943,276945,276946,276947,276969,277159,277359,277379,277414,277415,277489,277582,277655,277673,277761,277773,277775,277784,277785,277841,277905,277988,277989,277992,278000,278003,278069,278153,278186,278324,278341,278470,278572,278635,278638,278639,278642,278644,278937,279152,279156,279412,279413,279460,279464,279478,279549,279551,279887,279977,280241,280340,280341,280435,280553,280594,280745,281032,281033,281034,281035,281541,281563,281594,281609,281964,281979,282290,282369,282370,282494,282495,282496,282498,282499,282506,282510,282513,282514,282515,282516,282620,282626,282672,282816,282960,283201,283411,283438,283475,283485,283588,283625,283860,283955,283981,284005,284006,284200,284278,284280,284310,284330,284331,284333,284510,284545,284605,284653,284837,284838,284839,285008,285300,285308,285353,285586,285598,286588,286628,286697,286881,286888,287233,287241,287245,287291,287354,287400,287402,287403,287412,287539,287543,287544,287546,287547,287551,287669,287670,287681,287689,287742,287866,287867,288023,288326,288540,288583,288618,288758,288766,288807,288828,288829,288974,289232,289247,289248,289263,289557,289559,289560,289561,289562,289719,289723,289726,289771,289801,289968,289976,290139,290394,290406,290408,290410,290412,290414,290417,290418,290420,290421,290422,290423,290424,290425,290428,290682,290684,290692,290695,290906,290984,291252,291347,291366,291455,291471,291503,291506,291544,291613,291675,291817,291838,291987,291989,292146,292213,292217,292239,292282,292296,292495,292502,292634,292774,292849,292850,292871,293126,293127,293128,293129,293130,293135,293235,293282,293284,293293,293340,293358,293399,293567,293568,294588,294593,294857,294921,295085,295087,296108,296121,296125,296129,296130,296161,296163,296200,296201,296215,296216,296217,296219,296224,296226,296228,296237,296238,296280,296314,296323,296427,296501,296502,296609,296652,296653,296654,296655,296656,296657,296666,296689,296691,296692,296694,296702,296789,296790,296792,296794,296799,296869,296885,296887,296888,296889,296904,296905,297064,297065,297080,297178,297183,297184,297251,297477,297542,297549,297550,297577,297604,297605,297606,297607,297715,297720,297755,297788,297789,297986,298084,298195,298196,298199,298217,298357,298358,298359,298363,298365,298366,298395,298423,298482,298606,298894,299039,299117,299127,300665,300725,300881,300921,300956,301084,301104,301106,301385,301387,301391,301406,301425,301458,301465,301483,301500,301534,301579,301587,301611,301625,301722,301811,301868,301870,301918,301919,301979,302047,302048,302061,302121,302185,302216,302218,302219,302221,302340,302479,302499,302500,302501,302502,302534,302544,302558,302559,302562,302584,302585,302626,302828,302877,302938,302946,303079,303081,303082,303085,303088,303181,303182,303239,303278,303298,303332,303334,303348,303349,303357,303364,303367,303588,303600,303603,303604,303605,303606,303609,303610,303612,303617,303618,303741,303742,303745,303746,303799,303949,304303,304309,304454,304459,304872,304886,304888,304889,304890,304892,304893,304895,304929,304954,304971,304974,304975,304976,304977,304984,305003,305005,305006,305009,305023,305051,305161,305269,305380,305381,305382,305478,305479,305480,305482,305483,305484,305485,305487,305500,306674,306678,306683,306687,306710,306719,306787,306882,306887,307039,307191,307269,307270,307272,307273,307277,307303,307449,307596,307597,307659,307964,308253,309483,309545,309547,309699,309700,309737,309958,310025,310134,310153,310155,310156,310404,310443,310499,310507,310839,310844,310984,310994,310995,310997,310998,311173,311174,311175,311333,311513,311726,311728,311729,311733,311958,312289,312349,316373,316414,316450,316646,317720,317722,319248,319453,319954,319955,319988,320089,320092,320094,320096,320097,320217,320219,320516,320722,320737,321128,321141,321271,321299,321304,321310,321331,321391,321522,321597,321668,321670,321782,321793,322502,322642,322870,323224,323233,323310,323312,323335,323338,323341,323344,323377,323398,323494,323497,323550,323573,323601,323680,323697,323723,323783,323794,323809,323810,323811,323822,323823,323842,323869,323870,323871,323872,323907,324054,324056,324057,324059,324061,324225,324247,324292,324293,324384,324404,324405,324412,324433,324491,324545,324593,324595,324625,324627,324707,324852,324861,325299,325320,325323,325328,325361,325597,325599,325936,325937,325984,325990,326188,326206,326246,326295,326319,326500,326501,326502,326503,326504,326699,326700,326734,326735,326882,326962,326974,328273,328296,328323,328403,328696,328769,328770,328771,328807,328921,328925,328926,328927,328971,328982,329010,329058,329141,329340,329342,329343,329344,329458,329461,329463,329466,329528,329618,329671,329731,329732,330323,330342,330377,330395,330396,330493,330661,330763,330776,330784,331057,331205,331206,331223,331243,331245,331430,331580,331803,331831,331846,331873,331954,332074,332248,332267,332268,332845,332852,332891,333001,333051,333250,333251,333326,333334,333450,333451,333452,333453,333495,333497,333666,333683,333688,333706,333734,333747,333757,333815,333951,333956,334012,334014,334016,334017,334020,334021,334023,334038,334040,334043,334047,334059,334060,334061,334062,334066,334067,334068,334069,334070,334105,334106,334153,334154,334157,334158,334248,334254,334277,334313,334361,334364,334365,334366,334408,334409,334457,334591,334654,334862,334958,335184,335254,335255,335256,335290,335300,335308,335310,335478,335666,335668,335670,335822,336064,336066,336067,336068,336069,336071,336072,336073,336075,336076,336077,336088,336138,336139,336140,336142,336144,336145,336146,336156,336158,336177,336311,336312,336313,336317,336318,336319,336320,336331,336335,336342,336465,336515,336546,336552,336670,336677,336680,336690,336925,336956,337013,337014,337017,337018,337021,337025,337060,337102,337139,337141,337226,337271,337275,337296,337439,337440,337442,337458,337459,337585,337744,337831,338009,338029,338042,338095,338186,338190,338192,338310,338342,338373,338407,338408,338423,338424,338425,338426,338428,338431,338432,338439,338442,338443,338458,338459,338460,338461,338545,338575,338621,338699,339034,339140,339142,339143,339284,339371,340083,340127,340255,340410,340708,340725,342181,342407,342408,342410,342412,342414,342419,342420,342421,342424,342425,342431,342437,343447,343461,343554,343675,343677,344052,344214,344611,344775,344776,344777,344780,344818,345205,345252,346712,346740,346760,346762,346820,346832,346933,347210,347256,347294,347385,347386,347388,347389,347390,347391,347763,347889,347957,347958,347960,347961,347975,348030,348167,348236,348469,348490,348554,348562,348580,348598,348648,348738,348853,348856,349028,349066,349100,349101,349111,349204,349337,349352,349354,349367,349378,349387,349390,349398,349399,349426,349467,349468,349469,349471,349472,349473,349759,349817,349822,349823,349824,349825,349832,349840,349851,349881,349900,349902,349917,349950,349977,350016,350061,350157,350239,350671,351848,351859,351923,352042,352067,352068,352069,352070,352072,352086,352087,352088,352089,352102,352219,352221,352224,352276,352541,352543,352544,352546,352547,352549,352552,352554,352555,352559,352598,352764,352825,352838,352847,352873,352875,352877,352878,352879,352888,352889,352897,352898,352927,352947,353023,353024,353056,353081,353099,353100,353148,353151,353160,353161,353191,353203,353252,353254,353428,353463,353474,353476,353555,353560,353605,353607,353608,353609,353612,353613,353616,353618,353619,353620,353621,353622,353624,353693,353725,354035,354071,354077,354088,354114,354140,354239,354264,354291,354319,354323,354325,354356,354358,354360,354361,354380,354615,354780,354848,354893,354894,354947,354948,355166,355168,355256,355380,355456,355507,355509,355554,355555,355574,355578,355587,355605,355633,355634,355635,355636,355718,355730,355756,355775,355825,355955,355981,356086,356089,356155,356157,356158,356183,356216,356217,356238,356239,356240,356242,356243,356301,356302,356303,356311,356597,356602,356660,356720,356831,356832,356833,356924,357130,357179,357194,357250,357269,357287,357288,357293,357294,357295,357300,357301,357311,357312,357341,357342,357344,357345,357418,357419,357420,357421,357422,357501,357502,357503,357505,357545,357559,357562,357563,357564,357565,357566,357567,357569,357570,357571,357577,357578,357579,357580,357581,357583,357584,357585,357586,357588,357597,357598,357600,357614,357619,357627,357698,357699,357715,357716,357730,357760,357810,357824,357999,358000,358061,358105,358114,358115,358116,358117,358118,358119,358120,358121,358122,358123,358124,358129,358130,358131,358134,358135,358137,358139,358140,358141,358142,358143,358170,358172,358202,358245,358247,358249,358285,358286,358289,358321,358323,358324,358353,358356,358367,358377,358381,358382,358393,358398,358401,358404,358407,358423,358446,358477,358517,358535,358537,358551,358553,358651,358694,358733,358750,358752,358758,358765,358792,358817,358858,358859,358864,358866,358891,358908,358913,358922,359038,359075,359115,359147,359148,359149,359167,359168,359169,359170,359172,359173,359174,359175,359204,359206,359207,359208,359209,359210,359211,359212,359215,359218,359223,359225,359249,359316,359317,359414,359417,359419,359420,359502,359548,359549,359558,359563,359629,359630,359632,359633,359795,359814,359844,359846,359848,359965,359999,360000,360019,360050,360053,360054,360055,360056,360104,360195,360196,360376,360401,360403,360419,360422,360427,360428,360429,360441,360463,360464,360472,360473,360474,360475,360476,360479,360526,360527,360528,360529,360530,360531,360532,360533,360544,360574,360575,360580,360581,360612,360683,360693,360867,361091,361092,361189,361455,362040,362255,362285,362349,362503,362504,362505,362507,362509,362510,362513,362538) or a.style_id in (228179,175601,75310,296795,70207,122241,280519,215222,342288,294596,269073,296339,344592,75311,75334,75323,75326,122149,75328,358734))

	
	
	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(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 grandgetproducts
		where
		 style_id is not null
           
            

group by Style_id order by
min_price desc

select * from grandgetproducts
		where
		 picture_id is not null
            
			


order by

min_price

select distinct (dept) as dept from getproducts1
			where dept not in (?,?,?,?,?,?,?,?,?,?,?)
			 group by dept

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

select distinct typ from getproducts1 where dept='Ammo' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Apparel' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Firearms' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Fishing' and brand='' group by typ order by sort_position

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Gifts & Novelties' and typ='EMPTY' and site = 'sportsman'

select distinct typ from getproducts1 where dept='Gifts & Novelties' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Hunting' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Law Enforcement' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Outdoor Recreation' and brand='' group by typ order by sort_position

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

select distinct typ from getproducts1 where dept='Personal Defense' and brand='' group by typ order by sort_position

select distinct(brand) as brand from GetProducts

select web_url from tb_web_taxonomy with (nolock) where dept='' 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\black-friday.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/black-friday.cfm/CurrentPage/357/sale/all/order_by/min_price%20desc
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/357/sale/all/order_by/min_price desc
PATH_TRANSLATED=E:\inetpub\wwwroot\black-friday.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/black-friday.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=22857097
cftoken=7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936
hitcount=1
lastvisit={ts '2026-04-13 16:28:08'}
timecreated={ts '2026-04-13 16:28:08'}
urltoken=CFID=22857097&CFTOKEN=7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936

Cookie Variables:
CFID=22857097
CFTOKEN=7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936
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=22857097
cftoken=7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936
cs=/black-friday.cfm/CurrentPage/357/sale/all/order_by/min_price desc
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22857097_7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936
strarray=Array (0)
urltoken=CFID=22857097&CFTOKEN=7201b58faa917503-554CAF6B-E9E1-A8EE-090D7C0908719936

URL Parameters:
BRAND=
CLEARANCE=
CurrentPage=357
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=
WHATSNEW=
order_by=min_price desc
sale=all