SELECT Style_ID FROM TB_Styles
	

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

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

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

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

					select * from application.getWebTaxonomy where dept='Footwear' 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 = 'footwear') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='2024-10-14 11:42:02.0' and displaystop>='2024-10-14 11:42:02.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='Footwear' 	
		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='Footwear'
					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))='Footwear'
            and ltrim(rtrim(typ)) = 'EMPTY' 
								and (
								
									upper(Sizelist) LIKE '%3%' 
									
										or 
									
									upper(Sizelist) LIKE '%26%' 
									
										or 
									
									upper(Sizelist) LIKE '%15%' 
									
										or 
									
									upper(Sizelist) LIKE '%160%' 
									
										or 
									
									upper(Sizelist) LIKE '%154W%' 
									
										or 
									
									upper(Sizelist) LIKE '%25%' 
									
										or 
									
									upper(Sizelist) LIKE '%7%' 
									
										or 
									
									upper(Sizelist) LIKE '%9%' 
									
										or 
									
									upper(Sizelist) LIKE '%33%' 
									)
							 GROUP BY STYLE_ID
		ORDER BY min(sortposition)
		

		SELECT * FROM 	
		GetALLProducts119  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))='Footwear'
		GROUP BY STYLE_ID 

		SELECT * FROM GetALLBrands119 ORDER BY
		sortposition asc 

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

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

				SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Footwear' 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='FOOTWEAR' and upper(typ)<>'EMPTY' and style_id IN (450774,450775,452344,403520,421205,428099,275604,450773,452342,458535,444879,444882,447251,447252,447250,444880,440165,452343,324668,405975,425015,438361,385586,407032,407033,407034,407035,341945,434464,300761,366380,305117,305101,305103,305116,300762,443244,453087,443958,376146,376145,422142,447870,435746,426054,451387,426089,411482,426078,430331,416723,445500,301128,441682,449453,449454,383540,452692,435307,417595,407722,407732,412413,408297,433374,287566,432870,451938,290054,407897,407899,407898,435589,444805,435590,435596,435597,442411,429525,442452,442409,417884,422883,450205,454254,446573,438109,429969,440490,450204,440491,442583,432115,446884,444405,446883,450203,454253,433629,433628,452356,451579,451412,448026,440901,446576,442599,434789,455126,440900,434777,434780,441138,459600,455122,458649,455123,458650,446567,451570,451406,458178,455125,455124,442597,446569,447830,452354,451502,451503,446571,440898,433625,446574,440899,452355,442598,446570,455127,434783,447826,426678,442596,434776,451408,454181,238336,403295,29788,276395,369335,350364,454810,248452,454812,451780,358372,450940,343291,416685,422184,363912,289674,403289,441015,382200,260888,416673,454808,343282,325255,373011,382211,441256,416671,403284,454809,416686,409723,26778,433225,459126,366067,433231,433257,459124,454257,438693,432511,432510,382323,451816,459630,454749,451584,403270,364669,403285,384266,451809,433131,451587,454745,451820,436035,360285,429560,451594,451803,433879,450078,403267,364671,364670,450077,454748,451808,440689,450076,458963,429976,272233,418114,430115,364667,335585,451599,451806,454747,418101,28963,451620,451622,26709,239487,349497,441829,429562,429552,403257,335586,319573,429556,429557,451680,451805,429578,451682,26706,454603,451810,241327,459510,450075,458964,454605,454606,355290,436020,429584,429583,458510,429585,396878,410827,331661,28243,258259,451787,451799,451800,451788,451789,451797,392475,451798,451804,418220,451785,451796,451801,451791,230008,451795,202016,451794,191897,392477,332468,303877,418222,424409,367835,380989,367812,422639,435264,238892,238833,233920,359687,11420,459268,316186,248351,370207,450058,273656,450057,445480,438925,455118,424952,424950,424948,403583,233922,435820,289229) 
                GROUP BY typ
			

        SELECT brand,branddisplay, count(distinct
        
          style_id
        
        ) as itemCount 
        FROM getproducts 
        WHERE brand >'' 
        and upper(dept)='FOOTWEAR'   
        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)='FOOTWEAR'   
                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)='FOOTWEAR'   
            GROUP BY FAMLIST
            

                  select distinct sizeList 
                  from getproducts 
                  where sizeList <>''  
                   and upper(dept)='FOOTWEAR'   
                  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 = 450774
		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=450774
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=450774 
          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 = 450775
		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=450775
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=450775 
          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 = 452344
		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=452344
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=452344 
          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 = 403520
		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=403520
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=403520 
          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 = 421205
		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=421205
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=421205 
          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 = 428099
		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=428099
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=428099 
          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 = 275604
		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=275604
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=275604 
          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 = 450773
		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=450773
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=450773 
          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 = 452342
		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=452342
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=452342 
          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 = 458535
		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=458535
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=458535 
          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 = 444879
		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=444879
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=444879 
          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 = 444882
		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=444882
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=444882 
          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 = 447251
		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=447251
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=447251 
          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 = 447252
		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=447252
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=447252 
          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 = 447250
		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=447250
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=447250 
          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 = 444880
		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=444880
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=444880 
          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 = 440165
		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=440165
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=440165 
          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 = 452343
		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=452343
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=452343 
          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 = 324668
		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=324668
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=324668 
          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 = 405975
		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=405975
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=405975 
          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 = 425015
		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=425015
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=425015 
          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 = 438361
		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=438361
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=438361 
          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 = 385586
		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=385586
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=385586 
          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 = 407032
		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=407032
			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:42:00' 
        	AND b.end_date >= '2024-10-14 11:42:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=407032 
          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/footwear/browse/size/3,26,15,160,154w,25,7,9,33
HTTP_URL=/category.cfm?mapping=footwear/browse/size/3,26,15,160,154w,25,7,9,33
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=footwear/browse/size/3,26,15,160,154w,25,7,9,33
REMOTE_ADDR=3.135.209.78
REMOTE_HOST=3.135.209.78
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=7261
cftoken=1f61a108f9030e4-74EF9A40-C4EA-B783-71310D30975E65E4

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=7261
cftoken=1f61a108f9030e4-74EF9A40-C4EA-B783-71310D30975E65E4
checkout=Struct (4)
couponreset=NO
cs=https://www.bcsurf.com/footwear/browse/size/3,26,15,160,154w,25,7,9,33
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/footwear/browse/size/3,26,15,160,154w,25,7,9,33
password=
phone=
picurl=https://www.bcsurf.com/images/
prodimgurl=https://www.bcsurf.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_7261_1f61a108f9030e4-74EF9A40-C4EA-B783-71310D30975E65E4
shipmethodlist=0,1
urltoken=CFID=7261&CFTOKEN=1f61a108f9030e4-74EF9A40-C4EA-B783-71310D30975E65E4
username=
website=Struct (1)

URL Parameters:
mapping=footwear/browse/size/3,26,15,160,154w,25,7,9,33