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	139	ACCESSORIES
2	65	BASELAYERS
3	58	BOTTOMS
4	75	BY ACTIVITY
5	260	FOOTWEAR
6	56	OUTERWEAR
7	12	SKIRTS AND DRESSES
8	82	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 (51,338,350,378,419,420,431,432,433,439,442,783,795,798,799,803,810,814,826,918,930,941,946,950,953,1305,1319,1342,1367,1368,1383,1391,1418,1425,1426,1429,1430,1556,1558,1559,1560,1744,1745,1747,1749,1750,1751,1752,1754,1758,1777,1792,1825,1829,1830,1835,1836,1849,1851,1865,1869,1882,1887,1888,1889,1893,1923,1924,1926,1931,1942,1951,1952,1992,1994,2002,2003,2006,2136,2137,2141,2149,2156,2160,2170,2171,2173,2176,2180,2195,2206,2211,2212,2215,2217,2224,2225,2226,2233,2234,2362,2441,2442,2443,2444,2445,2446,2810,2821,2823,2829,2954,2955,2957,2965,2975,2990,2998,3000,3073,3075,3076,3080,3082,3086,3100,3201,3206,3210,3215,3258,3260,3294,3301,3302,3309,3314,3324,3326,3338,3343,3347,3352,3379,3406,3408,3518,3522,3531,3543,3609,3622,3627,3656,3676,3690,3918,4048,4217,4256,4316,4330,4388,4783,4841,4848,4908,4957,4960,4963,4964,4968,4980,4991,4998,4999,5005,5019,5021,5022,5034,5236,5242,5279,5298,5307,5331,5333,5334,5339,5359,5361,5363,5365,5367,5377,5390,5391,5446,5455,5535,5551,5563,5594,5610,5612,5637,5638,5662,5696,5702,5719,5722,5726,5728,5732,5733,5737,5745,5748,5751,5754,5755,5771,5823,5826,5828,5831,5833,5845,5847,5866,5871,5878,5898,5900,5908,5912,5920,6045,6046,6047,6050,6054,6057,6062,6063,6064,6067,6131,6132,6133,6134,6139,6184,6222,6261,6265,6275,6295,6309,6316,6322,6502,6558,7256,7437,8003,8024,8034,8063,8070,8152,8154,8183,8202,8203,8210,8241,8242,8246,8262,8266,8272,8278,8279,8283,8320,8327,8329,8350,8623,8639,8664,8679,8692,8693,8723,8790,8800,8952,8960,8961,8962,9016,9023,9041,9055,9062,9130,9147,9150,9261,9263,9265,9266,9268,9372,9400,9493,9495,9499,9594,9721,9783,9858,9885,9890,9899,9907,9927,9931,10140,10254,10279,10286,10332,10334,10338,10339,10353,10397,10405,10420,10433,10434,10435,10608,10614,10631,10687,10699,10720,10741,10762,10851,10853,10888,10934,11269,11274,11280,11288,11289,11290,11297,11299,11309,11310,11311,11389,11473,11477,11529,11556,11563,11588,11589,11593,11625,13901,13909,13910,13923,13949,13960,13987,14067,14068,14069,14073,14125,14126,14133,14143,14177,14200,14206,14244,14278,14333,14357,14425,14514,14515,14517,14522,14571,14601,14612,14613,14618,14634,14635,14636,14642,14648,14678,14722,14726,14728,14729,14730,14755,14766,14782,14783,14784,14785,14794,14806,14807,14819,14828,14842,14918,15079,15086,15088,15090,15121,15122,15198,15199,15249,15251,15375,15410,15417,15418,15426,15428,15431,15432,15433,15434,15446,15451,15452,15453,15454,15455,15473,15502,15505,15508,15509,15516,15517,15553,15556,15574,15637,15657,15658,15695,15697,15704,15725,15726,15735,15750,15751,15752,15760,15767,15856,15881,15883,15898,15910,15913,15945,15946,15992,16015,16021,16022,16059,16093,16094,16097,16098,16100,16119,16126,16143,16157,16158,16161,16216,16219,16224,16301,16338,16366,16384,16397,16399,16400,16406,16408,16411,16457,16459,16498,16500,16507,16508,16581,16583,16597,16599,16603,16610,16612,16615,16617,16621,16627,16628,16631,16653,16654,16657,16658,16660,16662,16669,16690,16723,16724,16727,16729,16748,16750,16751,16768,16769,16782,16784,16795,16803,16805,16806,16807,16809,16810,16817,16828,16835,16861,16862,16863,16866,16868,16876,16879,16880,16881,16884,16886,16888,16929,16933,16937,16939,16947,16958,16961,16980,16994,16997,16998,17001,17002,17021,17024,17182,17193,17276,17279,17282,17283,17284,17285,17286,17461,17472,17483,17485,17487,17489,17519,17520,17521,17576,17609,17611,17614,17615,17620,17621,17622,17623,17625,17626,17627,17629,17647,17649,17650,17707,17708,17712,17715,17751,17752,17811,17817,17840,17841,17849,17857,17858,17860,17867,17893,17895,17903,17904,17906,17907,17909,17910,17913,17915,17917,17922,17923,17940,17941,17944,17949,17950,17951,17952,17953,17957,17968,17969,17975,18000,18027,18029,18035,18036,18038,18120,18121,18122,18124,18125,18126,18127,18133,18134,18150,18171,18178,18185,18186,18187,18226,18227,18228,18234,18235,18237,18250,18261,18262,18271,18272,18277,18287,18311,18313,18314,18334,18341,18375,18379,18380,18384,18386,18387,18388,18391,18392,18393,18394,18395,18396,18398,18399,18400,18413,18417,18427,18428,18429,18494,18495,18499,18502,18511,18532,18533,18534,18535,18537,18538,18558,18615,18616,18617,18656,18658,18669,18673,18674,18677,18679,18689,18690,18770,18773,18813,18814,18815,18843,18913,1294,2332,5837,6049,10740) GROUP BY subtyp1