Arcadian Shop | Outdoor Specialty Store

struct
ACTION	[empty string]
BRAND	[empty string]
CHOOSEADDRESS	[empty string]
CONFIRM	NO
CURRENTPAGE	1
Color	[empty string]
DEPT	Clothing and Footwear
GOTO	[empty string]
KEYWORD	[empty string]
NAV_CHOOSER	home
NEW	[empty string]
ORDER	[empty string]
ORDERBY	[empty string]
PAGE	6
PAYMETHOD	CC
PERPAGE	[empty string]
PPSUCCESS	NO
PRICE	[empty string]
RATE	[empty string]
RECEIPT_NUM	[empty string]
RETURNTO	[empty string]
RETURN_TO_PAGE	[empty string]
SALE	[empty string]
SAVEDCART	NO
SHIPPING	[empty string]
SHOP	clothing_and_footwear-mens-footwear
SUBTYP_1	Footwear
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Men's
WEB_TAXONOMY_ID	699
mapping	/clothing_and_footwear-mens-footwear
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_2	WEB_URL
1	Hiking	clothing_and_footwear-mens-footwear-hiking
2	Running	clothing_and_footwear-mens-footwear-running
3	Casual	clothing_and_footwear-mens-footwear-casual
4	Summer	clothing_and_footwear-mens-footwear-summer
5	Winter	clothing_and_footwear-mens-footwear-winter
6	Socks	clothing_and_footwear-mens-footwear-socks
7	Insoles	clothing_and_footwear-mens-footwear-insoles
8	Care & Waterproofing	clothing_and_footwear-mens-footwear-care_and_waterproofing
9	Gaitors	clothing_and_footwear-mens-footwear-gaitors
10	laces	clothing_and_footwear-mens-footwear-laces

CACHED

false

EXECUTIONTIME

SQL

SELECT subtyp_2, web_url FROM tb_web_taxonomy WHERE dept='CLOTHING AND FOOTWEAR' and typ='MEN''S' and subtyp_1='FOOTWEAR' and subtyp_2>'' and subtyp_3='EMPTY' and subtyp_2<>'EMPTY' ORDER BY sort_position

query

RESULTSET

query
	ITEMCOUNT	SUBTYP2
1	7	CARE & WATERPROOFING
2	36	CASUAL
3	9	GAITORS
4	53	HIKING
5	12	INSOLES
6	3	LACES
7	39	RUNNING
8	93	SOCKS
9	35	SUMMER
10	16	WINTER

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (374,788,793,804,825,856,1561,1562,1563,1565,1827,1831,1832,1840,1859,1890,1892,1903,1904,1905,1906,1907,1909,1928,1936,1944,1946,1947,1965,1975,1976,1996,1997,2196,2362,2696,2697,2829,3258,3260,3327,3331,3346,3349,3351,3354,3675,3685,3686,3687,3689,3692,4218,4279,4387,4788,4789,4798,4799,4954,4956,4962,4964,4970,4973,4989,4990,4992,4993,4995,5002,5004,7014,8140,8150,8151,8166,8251,8318,8326,8328,8814,8854,9069,9130,9260,9264,9265,9266,9268,9784,10433,10434,10435,10926,11291,11293,11475,11626,11627,14072,14075,14076,14648,14727,14731,14732,14734,14737,14738,14818,14846,15196,15197,15213,15316,15376,15424,15425,15447,15448,15450,15503,15512,15514,15515,15518,15557,15558,15559,15560,15561,15635,15638,15641,15642,15643,15696,15732,15743,15744,15745,15746,15747,15748,15749,15793,15912,15914,16120,16148,16510,16511,16512,16580,16582,16725,16726,16728,16786,16787,16858,16860,16865,16867,16932,16934,16935,16957,16959,16962,16963,16993,16995,16996,17003,17032,17348,17349,17391,17484,17486,17488,17490,17610,17612,17646,17648,17820,17859,17975,18037,18041,18042,18047,18132,18137,18138,18141,18153,18154,18155,18177,18190,18279,18336,18430,18498,18510,18539,18573,18655,18845,18901,18924,18928,18931,18935,19041,19057,19066,19067,19073,19079,19082,19105,19124,19125,19139,19185,19192,19207,19208,19230,19253,19254,19383,19577,19612,19731,19750,19841,19875,19879,19882,19884,19951,19954,19992,19998,20000,20001,20004,20006,20049,20089,20090,20134,20210,20212,20268,20296,20503,20597,20601,20603,20691,20752,20971,20992,21001,21393,21394,21607,21608,21647,21713,21825,21842,21843,21871,21872,21874,21879,1615,1616,1918) GROUP BY subtyp2