SELECT Style_ID FROM TB_Styles
	

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

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

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

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

					select * from application.getWebTaxonomy where dept='Mens' 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 = 'mens') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='2024-10-14 11:18:07.0' and displaystop>='2024-10-14 11:18:07.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='Mens' 	
		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='Mens'
					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))='Mens'
            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 '%34%' 
									
										or 
									
									upper(Sizelist) LIKE '%MEDIUM%' 
									
										or 
									
									upper(Sizelist) LIKE '%27%' 
									)
							 GROUP BY STYLE_ID
		ORDER BY min(sortposition)
		

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

		SELECT * FROM GetALLBrands4 ORDER BY
		sortposition asc 

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

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

				SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Mens' 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='MENS' and upper(typ)<>'EMPTY' and style_id IN (430771,445217,435617,445273,411902,445277,435569,428197,423362,435620,445235,445232,450775,452344,403520,275604,458535,444879,447251,447250,440165,393437,393440,393438,393444,452590,452592,433233,444717,366224,428779,436034,407894,403751,403746,403748,403752,420186,403750,403747,428861,428408,416098,440709,442435,459537,459539,407769,419214,407775,450687,457737,459540,353117,456125,450686,441209,453031,419006,432620,443237,432633,446129,421893,419018,419008,441211,451525,441216,435235,402881,416949,440291,438458,456084,419010,438419,456126,449873,453039,446094,440312,429939,441220,456165,456108,456198,421892,440302,435208,422475,422474,446126,402895,422472,435207,403141,449869,434583,440285,446101,446105,421846,449864,441217,421958,438220,456086,434586,423182,449860,429707,451506,441210,456088,456179,438225,440288,456161,446095,456130,456132,454928,433668,411571,441207,429708,441214,451508,451507,441229,456083,456072,455839,446102,446946,441231,402906,403071,402900,364871,424074,434577,390269,440292,441213,429719,456124,430966,448185,430588,417203,451769,453519,451758,436658,412736,392372,434408,412673,422984,427173,436702,436701,413306,436240,424239,436239,407034,407035,457077,459883,457616,418337,341945,366380,446868,442248,460071,442249,426931,454046,454055,438885,454050,454051,454056,454504,454509,454508,426054,426089,301128,454054,454115,454047,454048,449453,449454,383540,452692,435307,417595,407732,373453,437281,442068,343545,437287,437284,456217,458024,458020,454154,458018,456215,456216,380263,444957,312319,458604,452329,452327,452328,436392,452330,412769,385179,385180,385189,459228,459217,459223,459227,459226,459218,459590,459225,458306,458191,459448,445656,287566,432870,451938,290054,407897,459407,442411,429525,442452,442409,446757,446759,446755,435982,430431,456354,439262,456355,445130,456352,417931,437952,458229,458221,458242,452408,458226,458216,458236,458239,452786,452787,460135,452796,452788,460133,460134,457426,417884,422883,450205,448407,448409,440490,450204,384377,447727,447733,447742,436548,436539,447722,456494,456504,456511,436559,456519,456487,456491,456500,456505,436547,456501,456506,456492,456502,456507,394324,456509,456493,456510,394337,456512,447737,436549,447719,447723,447728,447735,436540,436555,436533,447717,447734,436541,447730,456513,456503,456508,436537,447724,414797,425987,425998,426005,456514,436550,426010,447725,447729,447738,426002,426011,425989,452356,448026,442599,455126,434777,455122,455123,451406,458178,455124,451502,451503,440898,440899,452355,442598,455127,447826,426678,434776,451408,416797,457186,406173,456808,452481,452482,416809,406181,406258,456885,398959,446445,446446,460018,456797,406267,446485,406199,456795,442053,400469,238336,29788,350364,454810,403289,441015,382200,416673,454808,343282,325255,416671,403284,454809,448197,448189,448193,448195,414979,461651,461650,451281,456616,454180,456553,454182,456557,459381,459380,442779,418099,428169,452784,452963,448515,437182,437184,457103,457102,457101,432558,432557,453645,436516,402156,453144,421582,330914,409723,26778,365936,455626,439058,432844,443630,416727,430268,441824,436467,402689,402362,441264,455643,433225,459126,436514,431371,433257,459124,451454,416736,455632,430267,441265,441805,451438,430266,441806,451453,389947,402478,402479,430272,442924,419570,455615,407125,459143,432717,435498,446945,451133,443396,453859,440951,445321,420567,430143,403796,453893,453603,423144,454331,453867,436229,453886,453865,453894,450970,450971,452902,450969,453896,416576,452909,386150,452904,452911,443883,451084,452906,452910,416699,404077,415992,395832,441531,446234,453911,445319,452905,423116,452907,432779,404051,386292,424532,27402,27328,451584,403270,364669,433131,451587,454745,360285,429560,451594,451803,433879,450076,272233,418114,430115,364667,335585,451599,451806,454747,418101,451620,451622,441829,429562,429552,403257,335586,319573,429557,451805,26706,459510,450075,355290,436020,453927,453946,430076,452011,448503,457047,457046,457018,453742,453741,457025,365241,365446,435353,406137,381608,390101,399179,368468,452145,441901,444990,383298,406146,440525,455198,444993,456921,455314,452150,456934,440509,441899,430947,437626,441902,456936,456939,456923,371924,371374,371371,456912,429874,441900,456925,452146,452151,440515,456930,365472,456342,366656,456319,362778,456322,368481,454184,454185,456329,443248,454153,456321,456341,460093,456344,460094,444678,448364,448365,331661,451799,451800,418220,202016,418222,356602,396183,430623,438082,430614,418453,426915,408627,408626,408625,441652,406328,417560,406118,447625,428727,441664,451563,416748,416749,426922,426921,415818,430621,435920,434292,438443,408570,435916,451557,431442,434172,448419,442589,457053,406329,435940,435928,454872,417634,420547,417635,415825,416612,409831,416596,441951,434311,415849,383791,421707,434224,416601,426923,441501,397630,417533,383867,380198,341639,441981,454854,438449,448416,454870,431538,433803,434169,380187,413914,356014,418454,380517,453719,434293,431387,447631,417566,446506,339759,431494,393467,430622,434173,408464,444269,452169,451567,415847,438437,416616,408916,448417,370516,443721,451560,448421,434320,446514,460461,448418,417624,417626,451559,452173,417567,441504,446513,454871,415827,430619,416604,441500,408607,380169,434308,417559,457552,415094,415946,435923,453560,451555,411430,447630,448426,431459,434272,457069,415178,408463,457070,431380,406113,438442,434164,451562,417631,417630,426938,451561,417527,416610,431381,415817,435927,426934,412942,421741,454711,417576,451556,426913,451566,424311,413933,452222,448423,452177,383871,457068,431382,441949,410930,454708,438750,448438,452181,438748,431526,431525,453564,448437,438752,435937,446841,446838,436607,446846,446853,446840,446843,436606,446844,446845,446848,446850,446839,446842,424409,446847,431537,442978,327703,435740,410630,369002,435742,439452,289520,359297,289835,339609,457644,457653,457658,367835,367812,436091,422639,435264,238892,238833,233920,359687,11420,439118,458928,459268,248351,370207,450058,455118,424952,424950,424948,233922,458930,458926,453989,453979,453990,441872,380340,441870,447141,437652,453972,365286,452133,452136,454011,453987,453969,456572,453256,447142,452134,453971,454004,453966,453967,453965,441874,406422,453978,433030,453977,454148,453964,417741,448393,445814,448385,438500,441324,451707,451708,441339,445510,432795,435890,445902,443365,441328,441329,434472,441331,448395,365315,434492,441417,434491,441416,448492,445894,435836,451698,451697,441321,444046,435835,435884,445896,434482,441322,445897,289229,445898,441342,434474,448384,429566,432785,451700,451701,453261,456979,446465,445910,456984,434475,454341,441337,456971,394978,416430,440691,420684,440692,440693,434025,431956,440690,383987,394979,436579,394981,416429,430759,436580,451782,388939,436581,447806,444553,444559,433248,455116,401321) 
                GROUP BY typ
			

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

                  select distinct sizeList 
                  from getproducts 
                  where sizeList <>''  
                   and upper(dept)='MENS'   
                  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 = 430771
		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=430771
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=430771 
          ORDER BY a.term_sale_id desc
		 

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

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

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

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435617
		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=435617
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435617 
          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 = 445273
		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=445273
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445273 
          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 = 411902
		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=411902
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=411902 
          ORDER BY a.term_sale_id desc
		 

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

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

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

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 435569
		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=435569
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435569 
          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 = 428197
		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=428197
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=428197 
          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 = 423362
		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=423362
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=423362 
          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 = 435620
		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=435620
			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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=435620 
          ORDER BY a.term_sale_id desc
		 

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

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

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

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

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

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

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 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:18:00' 
        	AND b.end_date >= '2024-10-14 11:18: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 = 393437
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

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

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

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

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

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

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

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

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:18:00' 
        	AND b.end_date >= '2024-10-14 11:18:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=393438 
          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/mens/browse/size/3,26,15,160,154w,34,medium,27
HTTP_URL=/category.cfm?mapping=mens/browse/size/3,26,15,160,154w,34,medium,27
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=mens/browse/size/3,26,15,160,154w,34,medium,27
REMOTE_ADDR=52.15.80.101
REMOTE_HOST=52.15.80.101
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=3455
cftoken=d0ecc5ddf5ea1a00-7414AC00-AEA0-CE6E-37C5D64D5D669CFA

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=3455
cftoken=d0ecc5ddf5ea1a00-7414AC00-AEA0-CE6E-37C5D64D5D669CFA
checkout=Struct (4)
couponreset=NO
cs=https://www.bcsurf.com/mens/browse/size/3,26,15,160,154w,34,medium,27
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/mens/browse/size/3,26,15,160,154w,34,medium,27
password=
phone=
picurl=https://www.bcsurf.com/images/
prodimgurl=https://www.bcsurf.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_3455_d0ecc5ddf5ea1a00-7414AC00-AEA0-CE6E-37C5D64D5D669CFA
shipmethodlist=0,1
urltoken=CFID=3455&CFTOKEN=d0ecc5ddf5ea1a00-7414AC00-AEA0-CE6E-37C5D64D5D669CFA
username=
website=Struct (1)

URL Parameters:
mapping=mens/browse/size/3,26,15,160,154w,34,medium,27