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	94	ACCESSORIES
2	35	BASELAYERS
3	57	BOTTOMS
4	100	BY ACTIVITY
5	291	FOOTWEAR
6	39	OUTERWEAR
7	26	SKIRTS AND DRESSES
8	88	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 (60,154,159,170,171,172,174,175,180,338,349,350,378,388,390,392,419,420,422,428,432,433,437,438,442,798,810,814,821,822,823,826,1306,1307,1308,1310,1318,1319,1320,1330,1341,1342,1365,1368,1380,1383,1385,1391,1410,1425,1426,1427,1429,1430,1556,1557,1559,1560,1634,1636,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1758,1777,1792,1802,1805,1806,1812,1813,1814,1816,1817,1825,1829,1830,1838,1842,1849,1850,1851,1865,1869,1870,1882,1883,1885,1886,1887,1888,1889,1893,1894,1895,1896,1898,1945,1950,1951,1952,1956,1978,1979,1987,1992,1994,1995,1998,2003,2006,2137,2141,2149,2156,2157,2168,2171,2173,2176,2177,2180,2188,2191,2194,2195,2199,2206,2211,2213,2216,2217,2224,2225,2226,2233,2234,2334,2362,2441,2442,2443,2444,2445,2446,2805,2810,2821,2823,2849,2850,2855,2864,2866,2887,2897,2902,2946,2964,2975,2977,2978,2998,3000,3001,3002,3066,3075,3077,3080,3081,3082,3084,3086,3131,3135,3143,3161,3201,3203,3206,3215,3224,3258,3259,3260,3293,3294,3309,3310,3314,3315,3318,3320,3324,3326,3332,3338,3341,3343,3344,3345,3347,3352,3411,3432,3451,3452,3471,3497,3528,3529,3531,3546,3556,3561,3564,3591,3610,3627,3628,3635,3636,3644,3676,3690,4217,4256,4316,4330,4353,4354,4356,4364,4373,4388,4437,4442,4456,4842,4846,4847,4848,4852,4853,4895,4960,4963,4964,4972,4980,4982,4991,4998,4999,5005,5019,5021,5022,5030,5034,5213,5236,5238,5239,5242,5249,5264,5280,5281,5284,5296,5298,5301,5302,5306,5307,5313,5314,5316,5331,5333,5339,5359,5361,5363,5365,5367,5373,5375,5377,5383,5391,5407,5430,5456,5466,5479,5491,5503,5507,5526,5535,5537,5548,5551,5563,5564,5565,5566,5575,5583,5594,5627,5633,5634,5635,5636,5637,5638,5649,5650,5662,5711,5717,5719,5722,5726,5728,5732,5733,5737,5745,5748,5754,5755,5762,5771,5804,5823,5826,5827,5828,5831,5833,5839,5845,5847,5866,5867,5871,5872,5898,5900,5901,5908,5912,5914,5920,6131,6133,6139,6143,6164,6165,6168,6174,6184,6237,6239,6240,6271,6274,6302,6502,6558,6863,7256,7971,7973,8003,8005,8006,8016,8023,8038,8040,8041,8043,8050,8051,8069,8070,8142,8152,8154,8174,8178,8183,8186,8188,8192,8194,8196,8201,8202,8203,8204,8208,8210,8241,8242,8246,8253,8261,8262,8265,8266,8271,8272,8273,8274,8275,8276,8278,8279,8280,8283,8320,8327,8329,8350,8561,8566,8571,8573,8621,8623,8639,8664,8693,8723,8807,8808,8810,8812,8816,8819,8823,8826,8830,8834,8883,8891,8902,8920,8938,8941,8952,8953,8954,8961,8980,9032,9033,9034,9035,9039,9040,9050,9051,9054,9059,9071,9072,9074,9125,9126,9130,9259,9261,9263,9265,9266,9268,9400,9461,9490,9491,9492,9493,9495,9496,9497,9499,9500,9506,9525,9551,9592,9594,9595,9649,9653,9655,9658,9759,9769,9780,9781,9782,9798,9817,9853,9858,9869,9888,9889,9905,9907,9909,9929,10140,10236,10238,10243,10250,10254,10279,10281,10286,10332,10334,10338,10339,10353,10366,10397,10405,10420,10433,10434,10435,10608,10631,10687,10699,10720,10762,10921,10930,10933,10934,10979,10983,10984,11227,11269,11270,11272,11273,11276,11277,11279,11280,11281,11288,11289,11290,11304,11308,11309,11310,11311,11313,11314,11348,11363,11369,11371,11380,11381,11388,11391,11392,11394,11396,11397,11400,11401,11402,11404,11477,11529,11536,11537,11625,13949,14034,14055,14057,14065,14067,14068,14069,14070,14143,14200,14274,14275,14276,14277,14278,14307,14308,14309,14310,14323,14326,14327,14330,14331,14332,14333,14334,14335,14337,14338,14339,14425,14426,14427,14487,14488,14528,14558,14559,14562,14563,14570,14601,14634,14635,14636,14646,14647,14658,14717,14755,14765,14766,14782,14783,14784,14785,14793,14794,14795,14806,14807,14819,14828,14829,14830,14842,14899,14900,14901,14918,14926,14929,14932,14941,15055,15074,15190,15213,15214,15215,15216,15247,15249,15251,431,439,803,1292,1294,1378,1413,1784,1818,1819,1821,1822,1912,1913,1914,1916,1923,1924,1931,1933,2002,2218,2332,2347,2348,2350,2354,2359,2955,2956,2965,3127,3129,3488,3626,3629,4048,4461,4896,5295,5297,5814,5815,5837,5857,5878,5884,5885,5892,6045,6046,6048,6049,6050,6051,6054,6295,6299,6307,6310,6316,6324,6333,6337,6348,6351,7437,8080,8567,8576,8577,8578,8581,8679,8692,8790,8969,8970,8986,8997,9009,9010,9023,9131,9507,9552,9855,9857,9886,9890,10740,10741,11271,11274,11278,11324,11325,11399,11473) GROUP BY subtyp1