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	135	ACCESSORIES
2	39	BASELAYERS
3	67	BOTTOMS
4	90	BY ACTIVITY
5	278	FOOTWEAR
6	27	OUTERWEAR
7	93	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='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (3,12,56,59,150,160,164,177,328,329,353,354,355,358,374,376,387,389,421,429,430,435,684,688,696,734,756,788,791,793,804,809,825,856,1561,1562,1563,1565,1578,1579,1580,1581,1585,1753,1754,1776,1827,1831,1853,1854,1859,1863,1904,1905,1928,1929,1936,1944,1946,1947,1953,1959,1965,1975,1976,1996,1997,2007,2124,2135,2136,2137,2138,2141,2145,2146,2147,2149,2150,2156,2157,2162,2168,2172,2174,2182,2196,2205,2208,2211,2214,2221,2222,2223,2232,2235,2237,2240,2241,2362,2696,2697,2777,2778,2781,2787,2790,2810,2821,2823,2858,2863,2865,2912,2945,2946,2977,3073,3088,3089,3090,3091,3092,3093,3094,3095,3104,3245,3258,3260,3327,3328,3331,3336,3342,3346,3349,3350,3351,3354,3397,3398,3408,3410,3412,3496,3497,3515,3520,3528,3529,3538,3544,3550,3589,3599,3604,3620,3623,3638,3640,3643,3664,3666,3669,3675,3685,3686,3687,3689,3692,3797,4048,4093,4218,4256,4276,4279,4291,4319,4320,4321,4334,4362,4387,4443,4784,4788,4789,4798,4799,4803,4846,4848,4852,4854,4898,4918,4923,4924,4934,4936,4937,4938,4948,4954,4956,4964,4970,4971,4979,4981,4989,4990,4992,4993,4995,5002,5004,5018,5027,5215,5225,5233,5235,5236,5249,5269,5270,5273,5279,5281,5291,5294,5296,5298,5299,5300,5302,5304,5306,5313,5316,5324,5327,5330,5339,5360,5362,5364,5390,5405,5439,5449,5451,5471,5473,5479,5512,5522,5548,5550,5551,5552,5553,5596,5598,5625,5640,5644,5645,5652,5653,5655,5662,5694,5697,5706,5718,5719,5722,5731,5742,5744,5747,5752,5753,5763,5772,5777,5830,5831,5842,5845,5851,5864,5865,5866,5868,5872,5875,5876,5882,5883,5900,5914,5918,6064,6176,6257,6309,6312,6357,6502,6558,6863,7256,7437,8011,8014,8030,8038,8073,8077,8140,8145,8150,8151,8166,8185,8191,8195,8207,8209,8218,8251,8252,8259,8269,8281,8282,8318,8326,8328,8517,8543,8545,8623,8639,8664,8791,8799,8809,8849,8854,8868,8869,8884,8919,8928,8990,9021,9022,9027,9029,9043,9045,9046,9047,9060,9063,9064,9066,9067,9069,9130,9145,9148,9149,9259,9260,9264,9265,9266,9268,9377,9399,9400,9426,9427,9460,9478,9518,9524,9544,9575,9597,9598,9651,9669,9670,9746,9764,9773,9784,9827,9832,9837,9849,9880,9906,9908,9910,9949,10140,10234,10241,10242,10246,10254,10281,10286,10332,10334,10338,10433,10434,10435,10501,10608,10631,10687,10699,10718,10720,10729,10922,10926,10931,10932,10935,11226,11228,11250,11291,11292,11293,11303,11305,11319,11361,11362,11373,11475,11476,11545,11626,11627,11628,13924,13959,13960,14094,14099,14101,14124,14140,14142,14199,14203,14205,14278,14281,14282,14283,14286,14287,14299,14303,14304,14305,14374,14424,14489,14491,14540,14560,14619,14620,14624,14634,14637,14648,14674,14677,14678,14683,14684,14690,14692,14727,14731,14732,14734,14737,14738,14764,14765,14766,14782,14784,14806,14807,14817,14818,14832,14833,14834,14835,14836,14837,14838,14839,14840,14842,14846,14847,15043,15089,15105,15127,15196,15204,15248,15376,15422,15424,15425,15429,15436,15447,15448,15450,15498,15503,15512,15514,15518,15523,15524,15526,15539,15557,15558,15560,15561,15567,15573,15638,15640,15643,15663,15694,15696,15732,15733,15737,15739,15740,15743,15744,15745,15746,15747,15748,15749,15761,15766,15792,15793,15844,15845,15851,15852,15875,15908,15909,15912,15914,15931,15946,15958,15994,16001,16002,16005,16107,16112,16120,16121,16122,16144,16148,16162,16169,16170,16228,16239,16338,16354,16365,16383,16388,16389,16418,16419,16420,16421,16422,16423,16447,16520,16521,16580,16582,16584,16599,16601,16626,16671,16672,16674,16675,16676,16677,16678,16679,16680,16681,16685,16689,16726,16728,16749,16768,16769,16780,16781,16786,16787,16791,16793,16802,16804,16812,16813,16822,16823,16825,16826,16832,16833,16845,16846,16848,16849,16854,16857,16860,16956,16982,17032,17144,17167,17168,17169,17171,17172,17173,17174,17175,17176,17177,17178,17195,17295,17296,17348,17349,17391,17392,17397,17399,17456,17473,17484,17486,17488,17490,17592,434,1292,1294,1575,1576,1577,1615,1616,2219,2798,5287,5664,5813,5815,5878,5884,6988,7109,8912,9028,9355,9416,9620,10736,10740,10741,10742,11356) GROUP BY subtyp1