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-mens
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Men's
WEB_TAXONOMY_ID	673
mapping	/clothing_and_footwear-mens
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Outerwear	clothing_and_footwear-mens-outerwear
2	Tops	clothing_and_footwear-mens-tops
3	Bottoms	clothing_and_footwear-mens-bottoms
4	Baselayers	clothing_and_footwear-mens-baselayers
5	Footwear	clothing_and_footwear-mens-footwear
6	Accessories	clothing_and_footwear-mens-accessories
7	By Activity	clothing_and_footwear-mens-by_activity

CACHED

false

EXECUTIONTIME

SQL

SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CLOTHING AND FOOTWEAR' and typ='MEN''S' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	281	ACCESSORIES
2	46	BASELAYERS
3	52	BOTTOMS
4	62	BY ACTIVITY
5	311	FOOTWEAR
6	63	OUTERWEAR
7	138	TOPS

CACHED

false

EXECUTIONTIME

121

SQL

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (3,12,53,59,141,329,354,359,374,376,391,421,429,430,435,683,684,685,687,688,696,698,733,756,764,780,784,788,793,804,825,856,918,930,941,946,947,950,953,1561,1562,1563,1565,1572,1578,1580,1581,1585,1753,1827,1831,1832,1840,1853,1859,1863,1890,1892,1903,1904,1905,1906,1907,1909,1928,1930,1936,1944,1946,1947,1965,1975,1976,1997,2007,2124,2136,2137,2138,2141,2145,2146,2147,2148,2162,2182,2196,2205,2217,2221,2222,2223,2232,2235,2240,2337,2342,2357,2362,2696,2697,2777,2780,2781,2782,2785,2787,2790,2791,2821,2829,2895,2922,2945,2960,2961,2977,2995,3073,3088,3092,3094,3095,3098,3104,3245,3258,3260,3327,3331,3342,3346,3349,3351,3354,3379,3405,3406,3407,3408,3412,3497,3510,3511,3512,3515,3521,3528,3529,3537,3543,3544,3564,3571,3573,3589,3599,3612,3620,3623,3625,3641,3656,3658,3664,3665,3666,3669,3673,3675,3685,3686,3687,3689,3692,3797,3918,4048,4218,4279,4387,4785,4788,4789,4798,4799,4803,4846,4918,4936,4937,4938,4954,4956,4962,4964,4970,4973,4981,4989,4990,4992,4993,4995,5002,5004,5215,5225,5233,5235,5236,5242,5249,5269,5270,5273,5279,5299,5300,5302,5304,5309,5312,5313,5316,5324,5330,5337,5339,5346,5358,5360,5362,5364,5405,5433,5438,5449,5451,5479,5550,5552,5605,5625,5644,5645,5652,5662,5694,5696,5697,5706,5718,5719,5722,5731,5733,5742,5744,5752,5753,5772,5773,5777,5851,5864,5865,5866,5868,5874,5875,5876,5878,5882,5884,5900,6060,6062,6063,6064,6176,6357,6502,6988,7014,7109,7437,7989,8029,8030,8140,8150,8151,8166,8199,8200,8251,8318,8326,8328,8517,8543,8545,8559,8623,8639,8664,8799,8802,8814,8820,8849,8854,8867,8902,8904,8911,8919,8990,9018,9021,9022,9028,9045,9046,9060,9063,9069,9130,9145,9149,9260,9264,9265,9266,9268,9377,9392,9399,9400,9415,9427,9460,9518,9544,9575,9624,9626,9718,9784,9822,9827,9837,9849,9898,9915,9949,10254,10281,10286,10334,10338,10433,10434,10435,10501,10608,10631,10687,10718,10720,10729,10760,10788,10805,10817,10841,10855,10856,10874,10877,10926,11291,11362,11376,11475,11557,11578,11579,11588,11589,11592,11626,11627,13901,13911,13959,13960,13961,14032,14072,14075,14076,14099,14101,14124,14140,14255,14256,14281,14287,14374,14619,14620,14622,14624,14648,14677,14678,14692,14727,14731,14732,14734,14737,14738,14782,14806,14817,14818,14836,14838,14839,14842,14846,14962,15105,15135,15196,15197,15316,15376,15422,15424,15425,15429,15447,15448,15450,15496,15499,15503,15512,15514,15515,15518,15523,15527,15539,15557,15558,15559,15560,15561,15574,15635,15638,15641,15642,15643,15693,15696,15698,15732,15743,15744,15745,15746,15747,15748,15749,15793,15844,15845,15851,15852,15893,15908,15912,15914,15945,15958,15994,16013,16015,16017,16019,16020,16021,16022,16085,16112,16120,16121,16122,16123,16125,16148,16157,16169,16170,16215,16216,16217,16219,16221,16248,16338,16353,16354,16418,16422,16510,16511,16512,16580,16582,16599,16602,16607,16635,16655,16725,16726,16728,16768,16769,16780,16781,16786,16787,16802,16804,16822,16827,16832,16858,16859,16860,16865,16867,16883,16905,16906,16919,16932,16934,16935,16946,16949,16951,16953,16954,16957,16959,16962,16963,16993,16995,16996,17003,17009,17017,17019,17028,17032,17144,17174,17199,17287,17288,17348,17349,17391,17399,17484,17486,17488,17490,17522,17610,17612,17624,17646,17648,17680,17702,17710,17713,17714,17718,17719,17720,17807,17808,17811,17820,17850,17851,17852,17853,17859,17862,17863,17896,17897,17899,17901,17908,17923,17926,17927,17928,17929,17930,17932,17934,17935,17958,17959,17971,17972,17973,17975,18002,18016,18025,18037,18041,18042,18043,18047,18132,18137,18138,18141,18153,18154,18155,18156,18177,18188,18190,18192,18225,18227,18228,18234,18235,18236,18239,18249,18250,18251,18264,18278,18279,18281,18282,18283,18286,18295,18336,18346,18353,18377,18378,18380,18381,18423,18430,18435,18466,18467,18489,18496,18497,18498,18509,18510,18522,18534,18535,18539,18540,18573,18655,18657,18667,18669,18672,18673,18674,18676,18677,18707,18741,18745,18772,18774,18801,18803,18809,18811,18812,18845,18901,18924,18928,18931,18935,18951,18954,18955,18974,18977,19041,19057,19066,19067,19069,19071,19073,19079,19082,19087,19094,19105,19124,19125,19139,19185,19192,19194,19207,19208,19230,19253,19254,19255,19260,19268,19269,19277,19279,19282,19309,19353,19354,19355,19383,19411,19473,19492,19497,19515,19516,19517,19518,19577,19589,19612,19646,19731,19831,19832,19833,19841,19860,19861,19875,19879,19881,19882,19884,19931,19950,19951,19954,19992,19995,19998,20000,20001,20004,20006,20026,20029,20049,20053,20054,20062,20073,20074,20075,20076,20077,20078,20089,20090,20134,20151,20152,20153,20154,20156,20179,20185,20186,20188,20199,20200,20212,20215,20216,20217,20221,20222,20245,20246,20261,20262,20263,20264,20265,20266,20267,20268,20292,20293,20294,20295,20296,20298,20299,20302,20303,20304,20317,20320,20321,20322,20323,20324,20326,20327,20328,20329,20330,20335,20338,20339,20340,20341,20342,20343,20344,20345,20346,20347,20348,20350,20351,20352,20371,20373,20374,20376,20378,20380,20382,20385,20403,20409,20412,20413,20414,20415,20416,20417,20418,20454,20455,20456,20457,20458,20465,20466,20474,20475,20476,20495,20497,20498,20499,20503,20515,20516,20521,20568,20570,20593,20595,20596,20597,20601,20603,20623,20625,20626,20627,20628,20635,20636,20690,20691,20692,20693,20694,20695,20696,20735,20750,952,1576,1615,1616,3487,8912,9355,10875,11356,19629) GROUP BY subtyp1