SELECT Style_ID FROM TB_Styles
	

			select * from web_category_mappings where url='snowboarding' or url='/snowboarding'
			

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

			select web_url from application.getWebTaxonomy where upper(dept)='SNOWBOARDING' and typ='EMPTY'
			

			select web_url from application.getWebTaxonomy where upper(dept)='SNOWBOARDING' and typ='EMPTY'
		  

					select * from application.getWebTaxonomy where dept='Snowboarding' and typ<>'EMPTY' and subtyp_1='EMPTY' and sort_position<>'NO' order by sort_position desc
					

		    SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS
		    FROM tcontent
		    WHERE (parentID = '5EDE742B-D1F6-C174-A8E6A359B018AAD9') and (urltitle = 'snowboarding') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='2024-10-14 11:19:52.0' and displaystop>='2024-10-14 11:19:52.0') 
		    )
		

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '5EDE742B-D1F6-C174-A8E6A359B018AAD9') AND (active = 1) AND display > 0
        

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

			select dept, typ, subtyp_1, subtyp_2, subtyp_3, active, web_url, category_style from application.getWebTaxonomy where 
			
			
					dept='Snowboarding'
					and typ<>'EMPTY'
					and subtyp_1='EMPTY'
				
			
			order by sort_position
			

		SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, 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(famlist) as famlist
		, 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
		
		FROM [dbo].[web_all_products] WHERE pictureid is not null and (realname NOT LIKE 'Pit Viper%Sunglasses%' )

		
			and ltrim(rtrim(dept))='Snowboarding'
            and ltrim(rtrim(typ)) = 'EMPTY' 
								and (
								
									upper(Sizelist) LIKE '%1%' 
									
										or 
									
									upper(Sizelist) LIKE '%6%' 
									
										or 
									
									upper(Sizelist) LIKE '%40%' 
									
										or 
									
									upper(Sizelist) LIKE '%28%' 
									
										or 
									
									upper(Sizelist) LIKE '%LARGE%' 
									
										or 
									
									upper(Sizelist) LIKE '%153W%' 
									
										or 
									
									upper(Sizelist) LIKE '%151W%' 
									
										or 
									
									upper(Sizelist) LIKE '%146%' 
									
										or 
									
									upper(Sizelist) LIKE '%158W%' 
									)
							 GROUP BY STYLE_ID
		ORDER BY min(sortposition)
		

		SELECT * FROM 	
		GetALLProducts223  ORDER BY
		 RealName 

		SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, 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(famlist) as famlist
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(hexlist) as hexlist
		, 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
		
		FROM [dbo].[web_all_products] 
        WHERE pictureid is not null

		
			and ltrim(rtrim(dept))='Snowboarding'
		GROUP BY STYLE_ID 

		SELECT * FROM GetALLBrands223 ORDER BY
		sortposition asc 

          select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='snowboarding'
          

		select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='snowboarding'
		

				SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Snowboarding' and typ>'' and subtyp_1='EMPTY' and typ<>'EMPTY' 
                ORDER BY sort_position
			

				SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SNOWBOARDING' and upper(typ)<>'EMPTY' and style_id IN (435565,445217,445231,455328,459474,445228,445277,435688,445235,445232,445239,413775,423402,391517,391518,413255,393437,393440,393438,446352,437472,446706,435978,435977,436107,422984,412814,437502,436249,455657,455659,445938,455662,455663,455721,445947,445937,455660,455661,455695,455697,455722,455713,455715,455704,455705,455706,455708,445942,445944,455716,455717,436231,455725,445939,455664,455665,436141,455723,455718,455699,455700,455701,455719,445935,456702,455655,445943,455711,436158,455710,423424,455702,455703,446868,446722,454503,454046,454052,454055,454513,438885,454049,454050,454499,454051,454056,454504,454509,454508,454510,454060,454502,442100,454117,454201,454199,454200,438884,442106,442099,442105,442104,438623,453233,453236,438619,442078,442107,453240,453241,453242,454058,438613,421327,438614,442081,453243,438618,453230,453231,453229,438622,438615,453228,438610,438611,438609,453238,453239,453227,453226,453225,432640,442103,454054,438605,438607,453244,453245,442080,454115,454116,438604,454047,454053,454512,437290,455540,437286,437281,446297,357209,437272,357208,343545,437287,437284,413894,357207,437273,392347,446996,446998,437048,446995,446997,446994,446757,446759,446755,456715,456714,447017,456716,456717,456721,447009,456720,447267,437041,447008,447010,447007,447002,437039,447006,456718,456719,447018,394472,414228,374756,414193,447031,457363,391872,457359,447019,437563,425065,414192,437560,447029,457369,424005,447033,457373,374736,457361,437554,437565,447034,457374,457354,457360,437550,447021,457366,447022,446965,437553,447411,437552,446967,437555,447020,457365,457362,447719,437561,447027,457371,447026,425081,374732,414231,446961,446966,447023,457357,446911,461430,457358,414229,437557,436057,446772,446775,446771,446769,446770,446777,446773,446774,445807,447713,447712,446712,446710,446711,446713,413626,413627,413629,413632,413624,445616,445777,445796,437262,412745,413612,437264,447011,445633,413652,413630,413647,413651,445607,445603,412786,445618,413628,445775,445596,445597,445617,413640,413636,447016,445611,413638,445627,445623,445626,413634,437265,447014,445610,445613,437263,447012,445621,412743,412744,445631,454073,445630,437261,445605,445620,447015,437260,432202,413633,413631,432207,413648,424031,425095,437465,437466,437470,437467,447147,457756,437469,414418,413917,435916,413928,435928,424313,413930,413927,446506,413939,446514,446513,413920,424316,435923,413942,408463,424325,424311,413943,413933,435937,413575,446841,446852,446838,446948,413577,446780,436602,413589,436115,424407,436116,413606,436120,424396,446786,446787,424371,446801,446802,446785,447771,436130,436461,413588,446790,424373,413613,446803,446840,446789,446788,413592,436123,446794,392490,446844,436605,446845,436121,436122,446791,446792,446793,413615,446804,446805,436610,436126,436127,436460,446795,446796,446797,424385,436133,446806,446807,436124,446798,446799,446800,424388,413619,436134,446808,446839,446842,436112,446782,446783,436071,413583,436114,446784,436113,413604,436117,446781,436110,413576,445847,455658,438039,436088,445916,445922,436078,455692,455684,445907,436074,454475,455682,445915,455687,445921,438037,445924,445914,455686,445920,455690,455685,436079,445912,454474,445917,436084,455688,455683,445475,445517,445518,412423,445519,445520,445532,445534,445533,445535,445536,445537,445538,412417,412419,410324,444981,445541,445923,445933,445925,445814,445815,435837,445902,445894,435836,435835,445896,445900,445919,445897,445898,445932,445926,445910,445895) 
                GROUP BY typ
			

        SELECT brand,branddisplay, count(distinct
        
          style_id
        
        ) as itemCount 
        FROM getproducts 
        WHERE brand >'' 
        and upper(dept)='SNOWBOARDING'   
        GROUP BY brand,branddisplay 
        ORDER BY brand asc
        

                SELECT pricerange as price, count(distinct
                
                style_id
                
                ) as itemCount FROM getproducts 
                WHERE pricerange > ''
                 and upper(dept)='SNOWBOARDING'   
                GROUP BY pricerange 
                ORDER BY pricerange ASC
                

                SELECT * FROM temp ORDER BY ranking ASC
                

            select distinct FAMLIST, count(distinct
            
            style_id
            
            ) as itemcount 
            FROM getproducts 
            where FAMLIST<>'' and style_id <> 252213
             and upper(dept)='SNOWBOARDING'   
            GROUP BY FAMLIST
            

                  select distinct sizeList 
                  from getproducts 
                  where sizeList <>''  
                   and upper(dept)='SNOWBOARDING'   
                  group by sizeList
                  

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435565
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=435565
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435565 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445217
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445217
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445217 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445231
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445231
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445231 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455328
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455328
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455328 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 459474
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=459474
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=459474 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445228
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445228
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445228 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445277
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445277
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445277 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435688
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=435688
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435688 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445235
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445235
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445235 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445232
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445232
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445232 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445239
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445239
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445239 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 413775
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=413775
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=413775 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 423402
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=423402
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=423402 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 391517
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=391517
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=391517 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 391518
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=391518
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=391518 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 413255
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=413255
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=413255 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 393437
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=393437
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=393437 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 393440
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=393440
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=393440 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 393438
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=393438
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=393438 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 446352
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=446352
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=446352 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 437472
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=437472
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=437472 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 446706
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=446706
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=446706 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435978
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=435978
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435978 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435977
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=435977
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:19:00' 
        	AND b.end_date >= '2024-10-14 11:19:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435977 
          ORDER BY a.term_sale_id desc
		 

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35684555-EE35-F7BD-2C48AB815CFB5149') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3581E028-0BA8-C86F-CA4ECFC3081F3CF7') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3575014A-EDB6-21D0-51829D81B2081191') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35FD8DD0-ECD9-D4DB-CCB36427DF793CD8') 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 = '1A914999-DFE6-3992-87E5EB96B4418AC1') 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
            FROM tcontent
            WHERE (contentID = '35E53A2F-C82C-4DE8-CDD02EAA62DE69C2') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36560044-E1D3-8E01-AE5A2AC67D5BBCF0') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '367528A6-02D5-2606-1E8EAD27DFCF9231') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36913E04-EBCB-DAB8-962FE7042A6EC031') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '369974F5-FEE3-6BF2-4BFB1627C1DFC7B2') AND (active = 1) AND display > 0
        

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

							select distinct dept from web_all_products group by dept
						

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='MENS' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Mens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='WOMENS' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SWIM' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and a.sale='Y'
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

				SELECT *, 1 as querySort
				FROM firstQuery
				UNION
				SELECT *, 2 as querySort
				FROM getFiller
				ORDER BY querySort, sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='KIDS' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOYS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GIRLS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Kids' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='FOOTWEAR' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Footwear' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SKATEBOARDS' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COMPLETE SKATEBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PARTS AND ACCESSORIES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD TRUCKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD DECKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD WHEELS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PROTECTIVE GEAR' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LONGBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD BEARINGS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GRIPTAPE' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Skateboards' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SURF SHOP' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURFBOARDS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURF ACCESSORIES' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BODYBOARDING' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DIVE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LYCRA' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WETSUITS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Surf Shop' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SNOWBOARDING' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BINDINGS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BOOTS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GOGGLES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD HELMETS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARDS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD ACCESSORIES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Snowboarding' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

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

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
											group by typ
										

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BACKPACKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BAGS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEANIES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HAIR CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HATS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='JEWELRY' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PURSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SOCKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNGLASSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNSCREEN/SKIN CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WALLETS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATCHES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='FACEMASKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STICKERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOXERS/BRIEFS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATER BOTTLES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEACH TOWELS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COOLERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BELTS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

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

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LUGGAGE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, 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
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Accessories' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

          					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'
                                    ORDER BY sort_position
                    			

Application Variables:
accuratetaxchecksum=
accuratetaxlicensekey=
addtocarturl=https://www.bcsurf.com/
adminurl=https://www.bcsurf.com/web_admin/products/menu.cfm?style_id=
adwordsid=
allow_out_of_stock=NO
allow_sell_out_of_stock=NO
allow_show_out_of_stock=NO
altimgdir=D:\websites\prodimages\alt_images\
amazoncheckout=Struct (1)
applicationname=AppCFC
attr1_name=Color
attr2_name=Option
authorizenet=Struct (3)
bannerdir=D:\websites\images\banners\
bingverificationstr=
blogurl=
breakoutsizes=false
cms=muraDB
companyname=BC Surf & Sport
dbname=celerant
display_ship_methods=true
displaycount=24
displaypercentage=5
domesticshippingonly=false
ds=koalaSQL
egiftcardshippingmethodid=1
facebookurl=
fedex=Struct (12)
feedsdir=D:\websites\feeds\
filterlist=Price,Brand,Sale,New,Color,Size,length,test
forumemail=customerservice@bcsurf.com
freeshippingthreshold=50
fullauth=true
getwebtaxonomy=Query (272)
giftcardimgpath=file:///D:\websites\images/
giftcardpdfpath=D:\websites\giftcardPDF\
giftcardurl=https://www.bcsurf.com/info/e-gift-certificate
googleadwords=true
googleanalytics=true
googleanalyticsid=UA-2790860-5
googlecheckout=Struct (21)
googlefeedproducttype=Apparel & Accessories > Clothing
googleplusurl=
googleverificationstr=
homeurl=https://www.bcsurf.com/
imagedir=D:\websites\images\
instagramurl=
instockmsg=In-Stock
internationalcheckout=Struct (2)
invoverride=ALWAYS IN,DROP SHIP ITEM
isapirewritedir=C:\Program Files\Helicon\ISAPI_Rewrite3\
iscelerantactive=true
iscmsactive=false
isstorelocationsdbactive=false
largeprodimgdim=Struct (2)
locationdsdb=STORE_LOCATIONS
logdir=D:\websites\logs\
machine_id=8900
mailport=25
mailserver=127.0.0.1
medprodimgdim=Struct (2)
metadesc=
metatags=
multiplesitelist=/
mydomain=
orderemails=customerservice@bcsurf.com
outofstockmsg=Out of Stock
outofstockthreshold=0
packageid=0
packagetype=UNIVERSAL
pagetitle=BC Surf & Sport- Skate,Surf,Snowboard across the country since 1977
paypalconfig=Struct (11)
pinteresturl=
prefguestid=
pricing_store=90
prodimgdir=D:\websites\prodimages\
productreviews=true
qoh_store=ALL
quickcharge=Struct (6)
recaptcha=Struct (3)
receipttyp=SPECORDER
salesemail=customerservice@bcsurf.com
secureurl=https://www.bcsurf.com/
shiptomilitary=true
shiptostoreshippingmethodid=1
showattr1=true
showattr2=true
showsize=true
siteid=1
sitephone=800-528-9061
size_name=Size
smallprodimgdim=Struct (2)
speclist=length,test
startshoppingurl=https://www.bcsurf.com/
store=90
storelocator=false
supportemail=customerservice@bcsurf.com
tinyprodimgdim=Struct (2)
tsys=Struct (16)
twittername=
twitterurl=
ups=Struct (11)
use301redirects=false
use_authorizenet=true
use_avatax=false
use_celerant_shipping_rates=true
use_celerant_ups_live_rates=ON
use_dimensions=true
use_fedex_live_rates=false
use_giftcards=true
use_only_giftcards=true
use_quickcharge=false
use_ship_tax_codes=true
use_tsys=false
use_ups_live_rates=true
use_usps_live_rates=true
useaccuratetax=false
useamazoncheckout=false
usecelerantstorelocations=false
usegiftcerticates=true
usegooglecheckout=false
usepackages=false
usepaypal=true
usesavedcart=true
useshiptostore=true
usewebstylegrouping=false
usewishlists=true
usps=Struct (6)
util=Struct (26)
viewnosellmsg=Out of Stock
webadminurl=https://www.bcsurf.com/web_admin/
webroot=D:\websites\
websitename=BC Surf & Sport
wishlistemail=customerservice@bcsurf.com
wishlistphone=800-528-9061
woeurl=https://www.bcsurf.com/woe/
yahooverificationstr=
youtubeurl=

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=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=CN=www.bcsurf.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\defaultWebsite\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=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=CN=www.bcsurf.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.bcsurf.com
HTTP_REFERER=https://bcsurf.com/snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w
HTTP_URL=/category.cfm?mapping=snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=192.168.50.200
PATH_INFO=
PATH_TRANSLATED=D:\websites\defaultWebsite\category.cfm
QUERY_STRING=mapping=snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w
REMOTE_ADDR=3.15.206.25
REMOTE_HOST=3.15.206.25
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.bcsurf.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=3738
cftoken=f8fbf687a27b0634-7424ADDA-C031-7596-33AF83C2CFED84EE

Form Fields:
KWORD=

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
altimgurl=https://www.bcsurf.com/prodimages/alt_images/
cartstatus=NEW
cfid=3738
cftoken=f8fbf687a27b0634-7424ADDA-C031-7596-33AF83C2CFED84EE
checkout=Struct (4)
couponreset=NO
cs=https://www.bcsurf.com/snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w
customer_id=
customerdiscount=0
display_cc=YES
displaycount=24
email=
employeeloggedin=false
first_name=
iconurl=https://www.bcsurf.com/images/icons/
last_name=
memberloggedin=N
myreturnurl=https://www.bcsurf.com/snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w
password=
phone=
picurl=https://www.bcsurf.com/images/
prodimgurl=https://www.bcsurf.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_3738_f8fbf687a27b0634-7424ADDA-C031-7596-33AF83C2CFED84EE
shipmethodlist=0,1
urltoken=CFID=3738&CFTOKEN=f8fbf687a27b0634-7424ADDA-C031-7596-33AF83C2CFED84EE
username=
website=Struct (1)

URL Parameters:
mapping=snowboarding/browse/size/1,6,40,28,large,153w,151w,146,158w