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	72
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	176	ACCESSORIES
2	49	BASELAYERS
3	96	BOTTOMS
4	76	BY ACTIVITY
5	323	FOOTWEAR
6	47	OUTERWEAR
7	22	SKIRTS AND DRESSES
8	123	TOPS

CACHED

false

EXECUTIONTIME

136

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 (350,378,419,420,425,431,433,436,437,439,442,783,795,798,799,803,804,810,826,918,930,946,950,953,1306,1308,1318,1319,1341,1368,1383,1422,1425,1427,1429,1430,1556,1557,1558,1559,1560,1744,1750,1751,1752,1753,1754,1758,1777,1825,1829,1830,1835,1836,1869,1882,1887,1888,1889,1893,1923,1924,1931,1934,1945,1951,1952,1956,1992,1998,2006,2136,2137,2141,2148,2156,2160,2173,2176,2194,2206,2224,2225,2226,2233,2234,2332,2362,2441,2442,2443,2444,2445,2446,2779,2821,2829,2915,2945,2955,2975,2977,2998,3001,3002,3073,3076,3077,3080,3082,3086,3100,3201,3206,3210,3215,3235,3258,3260,3293,3294,3302,3309,3314,3324,3347,3352,3379,3406,3408,3497,3529,3549,3556,3560,3622,3627,3635,3650,3676,3690,4217,4388,4846,4847,4854,4957,4960,4964,4968,4991,4998,4999,5005,5019,5021,5022,5026,5034,5221,5236,5249,5279,5298,5301,5302,5307,5313,5316,5326,5331,5339,5361,5363,5365,5383,5391,5414,5461,5479,5535,5551,5563,5564,5565,5594,5637,5638,5649,5662,5673,5696,5719,5722,5726,5728,5732,5745,5748,5754,5755,5762,5771,5871,5887,5898,5900,5912,5920,6045,6046,6047,6048,6050,6054,6062,6067,6131,6132,6133,6134,6139,6240,6265,6293,6295,6316,6502,7437,8003,8005,8069,8152,8154,8183,8202,8203,8241,8242,8246,8262,8266,8278,8283,8320,8327,8329,8623,8639,8664,8679,8692,8723,8790,8800,8905,8952,8960,8961,8962,9023,9041,9062,9130,9147,9150,9261,9263,9265,9266,9268,9400,9495,9568,9593,9783,9858,9899,9927,9931,10254,10279,10286,10334,10338,10353,10397,10405,10420,10433,10434,10435,10608,10614,10631,10687,10720,10760,10841,10853,10874,10934,10979,10981,10983,10984,10985,10993,11269,11278,11288,11290,11309,11311,11312,11313,11402,11404,11563,11578,11589,11590,11593,11625,13909,13910,13949,14067,14068,14069,14073,14125,14133,14143,14177,14229,14244,14255,14275,14425,14488,14492,14515,14571,14601,14612,14635,14642,14648,14678,14683,14722,14726,14728,14729,14730,14755,14782,14785,14806,14828,14829,14842,14929,15055,15079,15090,15198,15199,15213,15216,15251,15375,15431,15432,15433,15434,15446,15451,15452,15453,15454,15455,15475,15502,15516,15517,15553,15555,15556,15617,15637,15657,15658,15697,15725,15726,15729,15734,15735,15736,15741,15742,15750,15752,15760,15763,15830,15856,15881,15883,15895,15910,15913,15945,16013,16015,16017,16019,16021,16022,16058,16087,16093,16094,16097,16098,16119,16126,16143,16157,16216,16219,16221,16224,16366,16399,16400,16401,16405,16406,16408,16410,16442,16443,16444,16498,16500,16505,16507,16508,16581,16583,16597,16611,16618,16628,16631,16658,16659,16660,16669,16683,16684,16724,16727,16729,16748,16750,16752,16768,16782,16783,16784,16789,16794,16795,16803,16805,16806,16807,16808,16817,16828,16829,16831,16835,16836,16861,16863,16866,16870,16872,16879,16884,16933,16936,16939,16947,16948,16958,16959,16961,16994,16997,16998,17002,17180,17182,17194,17199,17284,17483,17485,17487,17489,17519,17520,17521,17609,17611,17620,17621,17623,17625,17647,17650,17671,17680,17751,17752,17811,17840,17857,17858,17860,17895,17913,17944,17975,18027,18029,18035,18038,18127,18133,18134,18140,18145,18147,18150,18175,18185,18186,18187,18189,18227,18228,18234,18236,18237,18250,18261,18263,18276,18298,18312,18314,18376,18379,18380,18382,18384,18386,18388,18390,18393,18395,18413,18417,18427,18429,18442,18469,18511,18535,18537,18538,18541,18615,18616,18617,18656,18669,18672,18673,18709,18712,18713,18714,18717,18773,18793,18813,18822,18823,18824,18846,18913,18926,18927,18929,18956,18962,18964,18976,18985,18987,18988,19007,19008,19009,19011,19031,19032,19033,19035,19036,19038,19040,19042,19068,19069,19071,19076,19103,19122,19126,19127,19129,19130,19142,19143,19152,19160,19161,19164,19167,19168,19186,19193,19209,19210,19211,19212,19214,19215,19218,19231,19248,19249,19253,19254,19256,19295,19297,19332,19334,19352,19353,19363,19366,19367,19379,19380,19381,19382,19384,19414,19423,19475,19492,19497,19519,19555,19557,19584,19591,19613,19628,19732,19751,19765,19810,19830,19858,19876,19878,19880,19885,19948,19949,19952,19953,19970,19972,19994,19997,20002,20003,20005,20027,20028,20051,20059,20132,20150,20172,20177,20202,20203,20204,20211,20213,20223,20224,20267,20286,20293,20294,20297,20316,20325,20337,20353,20365,20368,20375,20377,20383,20393,20396,20465,20468,20490,20493,20500,20501,20504,20505,20506,20507,20508,20514,20522,20524,20538,20569,20577,20579,20597,20602,20635,20636,20684,20686,20691,20697,20698,20713,20769,20770,20771,20820,20843,20857,20871,20875,20876,20904,20905,20906,20912,20914,20934,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20972,20981,20982,20986,20993,21000,21002,21015,21057,21059,21066,21085,21086,21087,21088,21089,21090,21091,21112,21113,21114,21115,21116,21117,21118,21120,21121,21123,21124,21125,21126,21127,21128,21130,21131,21132,21133,21134,21135,21136,21137,21138,21140,21231,21232,21233,21234,21235,21236,21238,21239,21240,21241,21242,21259,21269,21271,21272,21273,21276,21277,21278,21280,21281,21282,21283,21284,21285,21286,21288,21314,21315,21316,21317,21318,21319,21353,21354,21355,21356,21357,21358,21359,21360,21361,21362,21363,21364,21365,21366,21367,21368,21389,21390,21395,21396,21572,21576,21578,21581,21582,21585,21590,21592,21594,21595,21606,21609,21714,21715,21741,21786,21823,21824,21827,21842,21843,21873,21875,21876,21877,21878,21880,21883,2973,2979,6049,9913,19629) GROUP BY subtyp1