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	[empty string]
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	68	ACCESSORIES
2	42	BASELAYERS
3	65	BOTTOMS
4	94	BY ACTIVITY
5	249	FOOTWEAR
6	34	OUTERWEAR
7	25	SKIRTS AND DRESSES
8	71	TOPS

CACHED

false

EXECUTIONTIME

105

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 (54,175,349,378,388,390,419,437,438,439,442,798,799,803,810,814,815,823,824,826,1306,1307,1308,1319,1341,1342,1365,1368,1383,1385,1391,1422,1425,1426,1427,1429,1430,1556,1557,1558,1559,1560,1744,1745,1746,1747,1749,1750,1751,1752,1753,1754,1757,1758,1777,1792,1813,1816,1817,1825,1829,1830,1838,1842,1849,1851,1869,1888,1889,1893,1894,1895,1923,1924,1942,1951,1952,1956,1987,1992,1994,1995,1998,2003,2006,2136,2137,2141,2149,2156,2157,2168,2171,2173,2176,2177,2180,2191,2195,2206,2211,2212,2215,2224,2225,2226,2233,2234,2362,2441,2442,2443,2444,2445,2446,2778,2779,2799,2810,2821,2823,2850,2866,2887,2902,2945,2946,2975,2977,2981,2998,3002,3073,3075,3076,3080,3082,3086,3100,3129,3201,3206,3210,3215,3224,3235,3258,3260,3294,3302,3309,3310,3314,3318,3324,3326,3338,3347,3352,3408,3411,3471,3497,3528,3529,3531,3561,3598,3627,3628,3676,3690,4048,4217,4256,4316,4330,4388,4783,4846,4848,4852,4854,4963,4964,4991,4998,4999,5005,5019,5021,5022,5026,5034,5236,5249,5279,5281,5296,5298,5302,5306,5307,5313,5316,5331,5333,5339,5359,5361,5363,5365,5367,5373,5377,5390,5391,5407,5414,5479,5503,5526,5535,5543,5548,5551,5563,5564,5565,5566,5594,5636,5637,5638,5649,5662,5673,5700,5702,5719,5722,5726,5728,5732,5737,5745,5748,5754,5755,5823,5826,5828,5831,5833,5845,5847,5866,5871,5872,5883,5886,5898,5900,5901,5908,5912,5914,5920,6045,6064,6131,6132,6133,6134,6139,6165,6168,6174,6182,6184,6240,6295,6309,6502,6558,6863,7256,7437,8003,8005,8038,8040,8041,8069,8070,8152,8154,8183,8196,8202,8203,8208,8210,8241,8242,8246,8262,8266,8271,8272,8274,8275,8276,8278,8279,8280,8283,8320,8327,8329,8350,8545,8623,8639,8664,8679,8693,8723,8800,8807,8808,8952,8960,8961,9016,9023,9039,9041,9059,9071,9130,9150,9259,9261,9263,9265,9266,9268,9400,9421,9428,9493,9495,9499,9500,9594,9595,9658,9782,9783,9857,9858,9905,9907,9909,9927,9931,10140,10236,10243,10250,10254,10279,10286,10332,10334,10338,10339,10353,10397,10405,10420,10433,10434,10435,10608,10614,10631,10687,10699,10720,10762,10933,10934,10979,10981,10983,10984,10993,11227,11269,11273,11274,11276,11279,11280,11288,11289,11290,11299,11308,11309,11310,11311,11312,11348,11371,11388,11389,11399,11402,11404,11405,11473,11477,11529,11536,11537,11563,11625,13923,13949,13960,13987,14067,14068,14074,14125,14126,14133,14143,14177,14200,14204,14206,14244,14274,14276,14278,14309,14327,14333,14335,14339,14357,14425,14426,14427,14488,14492,14515,14516,14518,14571,14612,14616,14618,14634,14635,14636,14642,14648,14678,14683,14722,14725,14726,14728,14729,14730,14755,14765,14766,14782,14783,14784,14785,14793,14794,14795,14806,14807,14819,14828,14829,14842,14918,15055,15077,15086,15087,15090,15123,15142,15194,15198,15199,15247,15249,15251,15375,15408,15426,15430,15431,15432,15434,15435,15446,15451,15452,15453,15454,15455,15469,15473,15502,15505,15516,15517,15556,15617,15657,15695,15697,15704,15729,15730,15734,15735,15736,15738,15742,15750,15751,15752,15762,15763,15764,15767,15781,15809,15810,15881,15910,15913,15930,15946,15992,16095,16119,16301,16338,16366,16367,16384,16397,16398,16399,16400,16405,16406,16407,16408,16409,16410,16411,16412,16413,16414,16415,16424,16425,16431,16442,16443,16445,16446,16457,16458,16459,16498,16500,16508,16579,16584,16596,16597,16598,16599,16610,16612,16613,16616,16617,16618,16619,16620,16621,16622,16624,16625,16627,16653,16657,16658,16659,16660,16662,16667,16669,16680,16683,16684,16690,16724,16727,16729,16748,16750,16751,16768,16769,16782,16783,16784,16785,16788,16789,16794,16803,16805,16806,16807,16808,16810,16829,16830,16831,16834,16835,16836,16837,16838,16839,16847,16863,16870,17398,17400,17461,17472,17483,17485,17487,17489,17519,17576,17577,17578,1292,1294,1367,1418,2332,2354,5815,5837,5878,5884,5892,6049,6261,8072,8692,8790,10740,10741) GROUP BY subtyp1