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	2
PAYMETHOD	CC
PERPAGE	[empty string]
PPSUCCESS	NO
PRICE	100-to-150
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
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Men's
WEB_TAXONOMY_ID	673
mapping	/clothing_and_footwear-mens
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Outerwear	clothing_and_footwear-mens-outerwear
2	Tops	clothing_and_footwear-mens-tops
3	Bottoms	clothing_and_footwear-mens-bottoms
4	Baselayers	clothing_and_footwear-mens-baselayers
5	Footwear	clothing_and_footwear-mens-footwear
6	Accessories	clothing_and_footwear-mens-accessories
7	By Activity	clothing_and_footwear-mens-by_activity

CACHED

true

EXECUTIONTIME

SQL

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

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	8	ACCESSORIES
2	13	BASELAYERS
3	23	BOTTOMS
4	14	BY ACTIVITY
5	55	FOOTWEAR
6	12	OUTERWEAR
7	18	TOPS

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (784,1996,2137,2141,2147,2182,2777,2821,3073,3092,3104,3246,3346,3349,3354,3379,3589,3623,3625,3664,3669,3689,4954,4973,4993,4995,5004,5330,5337,5645,5706,5722,5753,5772,5864,5865,5884,8639,8904,9021,9022,9045,9046,9060,9145,9149,9377,9392,10286,10718,10736,11475,11557,11626,13961,14281,14619,14620,14648,14692,14842,14846,15105,15135,15448,15539,15696,15698,15793,16112,16510,16511,16512,16580,16582,16725,16813,16832,16934,16935,16951,16962,16963,16995,17610,17612,17646,17859,18016,18132,18188,18510,18655,18845,18901,18955,18975,19057,19073,19124,19185,19192,19208,19612,19750,19998,20090,20156,20185,20210,20212,20335,20374,20409,20495,20568,20593,20596,20694,20695,20696,20881,20882,21021,21061,21069,21075,21078,21079,21243,21244,21247,21248,21253,21256,21392,21607,21608,21871,21872,21874,21879) GROUP BY subtyp1