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	164	ACCESSORIES
2	56	BASELAYERS
3	72	BOTTOMS
4	67	BY ACTIVITY
5	327	FOOTWEAR
6	73	OUTERWEAR
7	15	SKIRTS AND DRESSES
8	135	TOPS

CACHED

false

EXECUTIONTIME

100

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 (51,52,54,60,141,338,350,378,419,420,422,425,431,433,436,437,439,442,795,798,799,803,810,814,826,918,930,941,946,950,953,1306,1308,1314,1319,1341,1368,1383,1422,1425,1427,1429,1556,1557,1558,1559,1560,1744,1752,1753,1758,1777,1792,1825,1829,1830,1835,1836,1851,1865,1869,1882,1887,1888,1889,1893,1923,1924,1931,1934,1945,1951,1952,1956,1992,2003,2006,2136,2137,2141,2148,2149,2160,2173,2176,2194,2206,2217,2224,2225,2226,2233,2234,2362,2441,2442,2443,2444,2445,2446,2821,2829,2945,2954,2955,2957,2961,2965,2977,2991,2995,2998,3000,3073,3075,3076,3077,3080,3082,3086,3100,3127,3129,3132,3201,3206,3210,3215,3235,3258,3260,3293,3294,3302,3309,3314,3324,3326,3343,3347,3352,3379,3406,3408,3497,3528,3529,3543,3564,3609,3622,3627,3635,3650,3658,3659,3676,3690,3918,4048,4217,4388,4783,4846,4957,4960,4964,4968,4991,4998,4999,5005,5019,5021,5022,5026,5034,5236,5242,5249,5279,5302,5312,5313,5316,5326,5331,5334,5339,5359,5361,5365,5377,5390,5391,5442,5446,5455,5479,5535,5565,5592,5594,5610,5637,5638,5662,5696,5700,5702,5709,5719,5722,5726,5728,5732,5733,5745,5748,5751,5754,5755,5762,5771,5833,5866,5871,5878,5898,5900,5908,5912,6044,6045,6046,6047,6050,6054,6056,6060,6062,6063,6064,6067,6131,6132,6133,6134,6139,6184,6261,6265,6295,6316,6319,6322,6502,7437,8024,8069,8152,8154,8183,8202,8203,8241,8242,8246,8262,8266,8272,8278,8280,8283,8320,8327,8329,8532,8533,8545,8623,8639,8664,8679,8692,8723,8790,8800,8952,8960,8961,8962,9023,9041,9055,9062,9130,9147,9150,9261,9263,9265,9266,9268,9400,9495,9568,9721,9783,9858,9870,9890,9898,9899,9904,9927,9931,10254,10279,10286,10334,10338,10353,10397,10405,10420,10433,10434,10435,10608,10614,10631,10687,10720,10762,10853,10888,10934,10979,10981,10983,10993,11269,11274,11278,11280,11288,11290,11297,11298,11313,11402,11404,11473,11529,11563,11578,11588,11589,11593,11625,13901,13910,13923,13949,13960,13987,14067,14068,14073,14125,14126,14133,14143,14177,14229,14244,14255,14362,14425,14515,14571,14601,14612,14621,14635,14642,14648,14678,14722,14726,14728,14729,14730,14755,14782,14785,14806,14807,14828,14829,14842,14918,14929,15055,15079,15090,15122,15199,15225,15251,15375,15423,15426,15428,15431,15432,15433,15434,15446,15451,15452,15453,15454,15455,15472,15475,15502,15508,15509,15516,15517,15553,15555,15556,15574,15617,15637,15657,15658,15683,15697,15704,15725,15726,15729,15734,15735,15736,15741,15742,15750,15751,15752,15760,15776,15856,15881,15883,15895,15910,15911,15913,15945,15992,16015,16021,16022,16092,16093,16094,16097,16098,16100,16119,16126,16143,16157,16216,16224,16301,16366,16399,16400,16401,16405,16406,16408,16413,16425,16431,16459,16498,16500,16505,16507,16508,16581,16583,16597,16599,16603,16611,16615,16616,16618,16627,16628,16631,16654,16658,16669,16684,16724,16727,16729,16748,16750,16752,16768,16769,16782,16783,16784,16789,16803,16805,16806,16807,16808,16809,16817,16828,16837,16838,16861,16862,16863,16866,16870,16872,16879,16880,16881,16884,16886,16887,16888,16928,16933,16936,16937,16939,16947,16958,16959,16961,16980,16994,16997,16998,17001,17002,17020,17021,17023,17028,17121,17180,17182,17193,17199,17274,17277,17279,17284,17461,17472,17483,17485,17487,17489,17519,17520,17521,17609,17611,17615,17620,17621,17623,17625,17647,17649,17650,17671,17675,17678,17679,17680,17707,17708,17751,17752,17811,17817,17840,17841,17848,17857,17858,17860,17906,17912,17913,17917,17923,17939,17947,17950,17952,17953,17968,17975,18000,18027,18028,18029,18035,18038,18121,18124,18125,18126,18127,18133,18134,18140,18145,18147,18148,18149,18150,18175,18178,18185,18186,18187,18189,18227,18228,18234,18235,18237,18261,18262,18263,18271,18272,18276,18277,18298,18311,18312,18313,18314,18334,18375,18379,18380,18384,18386,18387,18388,18389,18390,18391,18392,18393,18394,18395,18396,18397,18398,18400,18413,18417,18427,18428,18429,18442,18468,18469,18511,18532,18533,18534,18535,18537,18538,18558,18615,18616,18617,18656,18658,18689,18690,18713,18714,18715,18717,18743,18773,18793,18813,18822,18823,18824,18844,18846,18898,18917,18923,18926,18927,18929,18956,18957,18983,18985,18987,18988,19007,19008,19009,19011,19031,19040,19042,19068,19069,19071,19075,19076,19103,19122,19126,19127,19128,19129,19130,19142,19143,19152,19160,19161,19168,19186,19193,19209,19211,19212,19214,19215,19218,19231,19248,19253,19254,19256,19295,19331,19332,19333,19334,19352,19353,19363,19366,19367,19381,19382,19384,19407,19420,19423,19425,19427,19475,19492,19497,19520,19583,19591,19613,19617,19628,19630,19732,19765,19767,19768,19810,19827,19829,19830,19834,19858,19876,19878,19880,19885,19901,19902,19921,19948,19949,19952,19953,19955,19956,19958,19959,19960,19961,19968,19969,19970,19971,19972,19973,19974,20027,20028,20050,20051,20055,20059,20060,20079,20081,20082,20083,20084,20086,20087,20129,20132,20143,20144,20146,20147,20148,20149,20150,20155,20160,20172,20173,20174,20175,20176,20177,20178,20180,20181,20182,20183,20193,20194,20197,20198,20202,20203,20204,20213,20219,20247,20248,20264,20267,20269,20286,20288,20290,20291,20293,20294,20295,20297,20316,20318,20319,20325,20336,20337,20343,20353,20354,20355,20356,20357,20365,20366,20367,20368,20369,20375,20377,20379,20381,20383,2332,3487,6048,6049,6052,9913,16099,19629,19994) GROUP BY subtyp1