All Products

SELECT Style_ID FROM TB_Styles

select * from web_category_mappings where url='all-products' or url='/all-products'

select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '5BF5D4F7-B37F-F6D3-63451E6205BEB29C') AND (active = 1) AND display > 0

select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
			dept='' and typ='' and subtyp_1='' and subtyp_2='' and subtyp_3=''	
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc

SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(usePackage) as usePackage
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		, max(of1) as of1
        , max(of2) as of2
        , max(of3) as of3
        , max(of4) as of4
        , max(of5) as of5
        , max(of6) as of6
        , max(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		, min(deposit) as deposit
		, max(last_rcvd) as last_rcvd
		, ROW_NUMBER() OVER(ORDER BY max(OF7) ASC) AS RowNum
		FROM [dbo].[web_all_products] 
        WHERE 1=1
            --AND pictureid is not null

		
						and upper(pricerange)='25-to-50'
					
							--Do Nothing Here
                    GROUP BY STYLE_ID
		ORDER BY min(sortposition)

SELECT * FROM GetALLProducts ORDER BY
		last_rcvd desc

SELECT max(dept) as dept, max(web_url) as web_url, max(sort_position) as sort_position
					FROM tb_web_taxonomy 
					WHERE dept>'' and typ='EMPTY' and dept<>'EMPTY'  
					group by dept
					ORDER BY sort_position

SELECT DISTINCT dept, count(distinct style_id) as itemCount 
                FROM getproducts 
                WHERE upper(dept)<>'EMPTY'  
					
					and style_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					
                GROUP BY dept

SELECT max(brand) as brand,max(branddisplay) as branddisplay, count(distinct
      
        style_id
      
      ) as itemCount 
      FROM web_all_products 
      WHERE brand >'' and style_id IN (9505,31999,1897,33561,1900,1926,1896,32037,32040,18866,33560,33562,1885,28744,33546,32025,32039,32041,3083,1293,8813,8789,33498,10647,1296,33543,33544,9212,17081,15336,31987,17610,17612,17768,17664,17655,17667,17696,17767,1350,33384,32971,32974,33015,6186,3082,18864,18769,5456,18826,33473,33474,33478,33479,3033,3071,3170,2106,33487,4353,4404,32926,4434,4204,33485,33486,11134,2143,2168,1106,4031,4032,2177,1136,1150,1108,1109,1114,1124,1034,1086,32588,32851,8877,8879,7808,7827,7128,7775,7778,7784,4038,5060,32062,4386,32867,10695,23620,3168,3122,11192,4714,4720,4736,28773,8256,4723,4710,4711,30588,32015,9265,911,912,913,2854,4452,4399,4375,4245,4255,9267,47,61,4111,4112,4145,45,46,4127,32976,4128,4095,10375,23473,5280,32879,33414,33422,33425,33432,28708,33430,2273,2299,17226,6210,32928,25318,4165,4167,28305,18895,9351,9458,9460,9461,9562,9504,9440,1061,7164,32458,2127,1104,7830,32091,4239,17805,13979,15326,15322,15323,15327,15329,15330,15333,15334,32931,9210,7312,7315,15425,15460,23468,33275,8986,8988,8989,8990,5210,5049,32064,1642,33296,1285,4138,4120,4119,4093,71,48,24624,4140,1205,1204,33266,32016,923,32972,4207,4273,32609,32596,32569,32577,2181,2185,32568,2137,32773,7141,32400,32774,7813,2134,2167,32453,2159,8812,3197,3275,3129,3050,8155,5812,4129,32973,9457,9459,5980,12766,4719,9456,32939,5138,5248,5157,4414,4410,6206,4551,4586,4618,4643,4647,4633,4634,4638,4639,4640,4620,4569,4577,31979,31980,7257,13978,13981,28709,1658,3368,1655,32159,32162,32163,32164,32165,3556,32187,32188,32189,32190,32191,32192,32201,31918,32874,4236,32888,32877,30556,31975,4589,4629,23579,8194,8205,8477,8621,4568,32149,7918,28638,32115,32116,32109,9587,9448,4347,4406,4718,24629,23488,32063,30555,30557,31754,31757,31758,31844,4164,4168,4170,4171,4172,32001,17773,31940,31912,31913,7929,28303,7826,8938,1152,9005,1072,4030,4360,8729,4318,4238,4278,1055,1093,619,8885,8886,8887,1126,1147,1110,1037,1091,7787,8930,9007,7801,7803,7805,12199,2169,57,12250,9835,4391,4383,4384,4211,4244,4398,4321,4405,8641,4731,9349,9350,25411,25517,4102,4146,4147,59,60,30523,1119,1077,1075,30654,30541,30543,28644,28646,2158,5137,4560,4593,9248,8197,8588,4650,4662,4636,4627,4592,4596,4600,4616,4617,4567,4580,4552,16963,29046,1348,2265,6191,9261,12242,9077,9262,7713,19044,25351,11163,28699,2276,16966,16944,15668,27448,27310,4028,16943,3019,2872,916,28994,28996,28997,10505,30652,30653,30539,30540,30542,30544,30545,3243,15162,11204,23921,12074,12088,12089,12090,12091,12092,23205,66,25749,12075,12076,12077,12078,19022,2701,8859,9715,8815,3171,3166,3225,3145,3128,2875,2877,28745,23654,23659,23660,30461,30462,25759,16946,28741,5949,29014,9135,9144,9260,915,9078,9086,6168,25381,25375,25326,25364,28250,30518,28249,29070,4221,5706,5903,6223,13859,2350,2356,2357,6032,10367,64,1973,7874,7875,24679,9083,10289,1556,4166,6194,24680,24675,12231,24674,13174,24677,10675,9629,27486,11602,28475,23509,19024,17225,14525,14767,14916,14917,14920,2876,2879,6067,4716,28916,25881,28705,25724,4717,28645,5531,5637,1313,28697,28481,6799,28606,28608,28641,5898,6196,23977,18338,14766,7734,15215,14768,15173,13816,6209,18577,9842,357,25332,25335,17122,15335,3065,7920,7928,14837,11205,27796,28221,7919,8829,3125,3121,4513,9463,9557,9584,15301,1315,25725,23598,4388,12808,12227,25734,24893,27331,27358,27449,18958,12256,4326,3009,3172,1822,6184,70,27311,27488,17784,3241,3077,3023,25760,25757,27271,27272,9133,1311,5902,5635,25733,3186,3025,7917,10219,7936,5511,1290,15351,9263,18292,18294,580,25320,8633,2945,8790,2954,2963,2873,25737,9087,25683,4524,1317,14999,14846,10677,3189,354,9586,18289,4125,19041,10566,23511,23622,7935,3117,4023,24837,24859,13891,1321,1288,7934,9132,7732,10224,7733,1305,1474,3195,3178,23580,23581,6188,19063,17224,575,606,7939,4135,4089,7770,7771,8810,3185,8860,3239,19043,8613,2678,1884,5156,8861,2959,2909,4900,1355,3529,15300,417,9214,7286,23231,7954,2700,23212,1391,11188,16899,18455,3496,9168,4307,18918,18919,18891,16767,17987,3004,8854,10221,7926,2688,4091,9442,3540,13898,17227,1819,6493,6200,69,3135,4914,1494,5268,4433,5636,7795,6829,1821,2903,5247,9696,8178,2902,3032,420,419,1982,1931,6034,7984,3126,1816,1069,1070,7927,2172,2448,2450,7796,2452,2453,2456,2457,2458,2459,8748,2444,8814,183,8540,219,1987,1888,3849,1837,738,224,40,31799,23616,23617,24647,23485,18900,17294,15636,12512,5508,5629,5701,12185,12186,12187,12188,12190,14923,15328,15331,15332,15325,16949,17625,17652,17472,25379,25380,25369,25370,25371,25372,26777,26778,26803,26840,28428,27772,27885,27900,27995,27997,28010,28063,28082,32021,32857,32858,32859,27533,32988,32992,33003,33390,33392,33495,32042,31846,31968,28276,28818,28820,28822,28823,28824,28825,28828,28829,28830,28831,28848,28851,28852,28871,28874,28875,28998,25667,25718,25736,12189,6314,6489,7790,7938,8153,8229,7275,7736,7737,5412,4970,4090,3280,3342,3343,3344,2967,1893)  
      GROUP BY Ltrim(brand),Ltrim(branddisplay)
      ORDER BY  max(brand) ASC

SELECT distinct of18  , count(distinct
        
          style_id
        
        ) as itemCount 
        FROM GETPRODUCTS 
        WHERE of18 >''  
        GROUP BY of18 
        ORDER BY of18 asc

SELECT pricerange as price, count(distinct
      
        style_id
      
      ) as itemCount FROM GETPRODUCTS 
      WHERE pricerange > ''
      GROUP BY pricerange 
      ORDER BY pricerange ASC

SELECT * FROM temp ORDER BY ranking ASC

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '23CAF9FB-155D-9BEA-014DE05AEA6984A7') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '2363C0DF-155D-9BEA-018D2CD496E7A280') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C0F49-155D-9BEA-014E0DE3321A0824') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C2F35-155D-9BEA-0116EE02CB815150') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236D22DF-155D-9BEA-010FAA115A719DE2') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CFAC8-155D-9BEA-014EF87802FDB145') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CDE9D-155D-9BEA-018641D3692BE8E9') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) AND display > 0

SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) and display > 0
            ORDER BY orderno

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '831A3F76-155D-9BEA-01EECAF7F29E927E') AND (active = 1) AND display > 0

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '36A31A9E-E77A-435E-A56D80D272E5C3DB') AND (active = 1) AND display > 0

SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FIREARMS' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='AMMUNITION' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MAGAZINES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='RELOADING' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='STORAGE' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='OPTICS' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KNIVES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ON SALE' 
                                    ORDER BY sort_position

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=16ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 05:02:28.028

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, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.bullseyenorth.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\bullseye\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, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.bullseyenorth.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=all-products/browse/price/25-to-50/instock/all/page/9
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.16.53.112
PATH_INFO=
PATH_TRANSLATED=C:\websites\bullseye\category.cfm
QUERY_STRING=mapping=all-products/browse/price/25-to-50/instock/all/page/9
REMOTE_ADDR=3.135.198.7
REMOTE_HOST=3.135.198.7
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.bullseyenorth.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=13006767
CFTOKEN=1f819c38d68721c2-D2E31A4A-D65E-3462-B149C09235021473
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
KWORD=

Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=13006767
cftoken=1f819c38d68721c2-D2E31A4A-D65E-3462-B149C09235021473
checkout=Struct (4)
couponreset=NO
cs=https://www.bullseyenorth.com/all-products/browse/price/25-to-50/instock/all
customer_id=
customerdiscount=0
display_cc=YES
displaycount=9
email=
employeeloggedin=false
first_name=
iconurl=https://www.bullseyenorth.com/images/icons/
last_name=
memberloggedin=N
myreturnurl=https://www.bullseyenorth.com/all-products/browse/price/25-to-50/instock/all
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_13006767_1f819c38d68721c2-D2E31A4A-D65E-3462-B149C09235021473
shipmethodlist=0,1
urltoken=CFID=13006767&CFTOKEN=1f819c38d68721c2-D2E31A4A-D65E-3462-B149C09235021473
username=
website=Struct (1)

URL Parameters:
mapping=all-products/browse/price/25-to-50/instock/all/page/9