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	1
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-womens
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	m
TITLE	[empty string]
TYP	Women's
WEB_TAXONOMY_ID	596
mapping	/clothing_and_footwear-womens
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Outerwear	clothing_and_footwear-womens-outerwear
2	Tops	clothing_and_footwear-womens-tops
3	Bottoms	clothing_and_footwear-womens-bottoms
4	Skirts and Dresses	clothing_and_footwear-womens-skirts_and_dresses
5	Baselayers	clothing_and_footwear-womens-baselayers
6	Footwear	clothing_and_footwear-womens-footwear
7	Accessories	clothing_and_footwear-womens-accessories
8	By Activity	clothing_and_footwear-womens-by_activity

CACHED

false

EXECUTIONTIME

SQL

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

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	14	ACCESSORIES
2	11	BASELAYERS
3	10	BOTTOMS
4	12	BY ACTIVITY
5	14	FOOTWEAR
6	14	OUTERWEAR
7	4	SKIRTS AND DRESSES
8	30	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='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (1307,1342,1422,1830,1888,1924,1951,2136,2137,2148,2979,2998,3073,3076,3100,3293,3294,3529,5221,5249,5298,5307,5316,5326,5331,5361,5365,5535,5536,5563,5564,5565,5637,5719,5732,5745,5748,5754,5755,5887,8069,9041,9150,9400,9428,9594,14068,14069,14642,15432,15735,15913,16443,16444,16659,16660,16669,16683,16784,16803,16948,17180,17857,17944,18147,18261,18957,19081,19215,19256,19331,19949,20500,20501,20569,20769,20914,20962,20963,20968,21043,21057,21059,21085,21133,21189,21233,21237,21238,21239,21314,21316,21322,21356,21402,21404,21407,21410,21440,21605,21922,21931,21932,22154,22292) GROUP BY subtyp1