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	112	ACCESSORIES
2	36	BASELAYERS
3	50	BOTTOMS
4	79	BY ACTIVITY
5	272	FOOTWEAR
6	34	OUTERWEAR
7	64	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 (56,150,160,164,167,168,173,177,328,329,333,353,357,359,374,376,387,389,421,429,430,435,684,685,687,688,698,764,788,791,793,804,809,825,849,856,1314,1330,1561,1562,1565,1578,1579,1580,1582,1626,1754,1776,1827,1831,1832,1841,1853,1854,1859,1863,1874,1890,1891,1892,1902,1903,1904,1905,1906,1909,1920,1928,1929,1930,1935,1936,1939,1944,1946,1947,1953,1959,1965,1976,1996,2007,2092,2124,2135,2136,2137,2138,2141,2145,2146,2149,2150,2156,2157,2168,2172,2174,2175,2182,2196,2202,2205,2208,2211,2213,2214,2221,2222,2223,2232,2235,2237,2238,2239,2240,2241,2253,2338,2362,2696,2697,2777,2790,2791,2794,2805,2810,2821,2823,2854,2858,2863,2865,2912,2957,3001,3088,3089,3090,3091,3093,3094,3095,3098,3244,3245,3246,3258,3259,3260,3327,3328,3331,3336,3342,3346,3349,3350,3351,3354,3410,3412,3496,3497,3515,3516,3528,3538,3543,3544,3570,3571,3599,3600,3619,3620,3637,3638,3641,3643,3654,3662,3664,3666,3669,3673,3675,3685,3686,3687,3689,3692,3797,4048,4093,4218,4256,4276,4279,4291,4319,4320,4321,4334,4359,4362,4384,4387,4443,4784,4785,4786,4798,4799,4803,4841,4842,4848,4852,4871,4918,4923,4933,4934,4936,4937,4938,4948,4952,4954,4956,4962,4964,4966,4970,4971,4973,4979,4981,4989,4990,4992,4993,4995,5002,5004,5027,5175,5215,5233,5235,5239,5242,5249,5252,5254,5260,5264,5280,5281,5296,5298,5299,5302,5306,5309,5313,5314,5324,5325,5330,5339,5346,5358,5360,5362,5364,5390,5405,5430,5433,5437,5449,5451,5471,5473,5522,5545,5548,5583,5598,5639,5640,5641,5644,5645,5652,5653,5694,5695,5697,5706,5711,5719,5722,5731,5733,5747,5752,5753,5763,5772,5777,5830,5831,5842,5845,5851,5855,5864,5866,5868,5870,5872,5875,5882,5897,5900,5914,5918,6176,6257,6279,6308,6309,6312,6337,6338,6357,6502,6558,6863,7256,8030,8073,8077,8140,8145,8150,8151,8166,8176,8177,8185,8191,8195,8199,8200,8207,8209,8218,8251,8252,8259,8269,8281,8282,8285,8318,8326,8328,8623,8664,8791,8793,8795,8796,8799,8805,8806,8809,8811,8814,8820,8849,8854,8869,8884,8886,8902,8917,8918,8919,8928,8937,8951,8966,8981,8990,8993,9022,9029,9042,9043,9045,9046,9047,9048,9049,9060,9063,9064,9065,9066,9067,9130,9131,9148,9260,9264,9265,9266,9268,9378,9399,9400,9460,9478,9518,9544,9597,9598,9599,9603,9651,9662,9669,9670,9718,9737,9754,9764,9775,9827,9832,9836,9837,9871,9880,9906,9908,9910,9917,9920,9922,9923,10140,10234,10241,10242,10246,10254,10281,10286,10332,10334,10338,10366,10433,10434,10608,10631,10687,10699,10718,10720,10729,10922,10926,10931,10932,10935,11226,11228,11250,11291,11292,11293,11303,11305,11343,11361,11376,11377,11475,11476,11543,11544,11545,11626,11627,11628,14071,14072,14075,14094,14124,14129,14141,14142,14199,14278,14282,14284,14301,14303,14304,14305,14342,14424,14489,14503,14504,14523,14525,14526,14529,14556,14560,14561,14568,14619,14637,14684,14692,14727,14731,14732,14737,14738,14764,14765,14766,14782,14784,14806,14807,14832,14833,14834,14835,14836,14838,14839,14840,14846,14847,14925,15043,15105,15127,15196,15204,15213,15214,15215,15216,15248,15421,15422,15424,15425,15498,15503,15518,15557,15561,15633,15635,15638,15640,15641,15642,15643,15663,15792,15793,15844,15845,15846,15875,12,354,434,1292,1294,1573,1574,1575,1576,1615,1616,1907,1910,2219,2342,2798,2960,2961,2962,3393,5287,5291,5304,5664,5813,5815,5878,6988,7109,7337,7437,8079,8821,8912,8983,9021,9024,9028,9355,9416,9426,9427,9620,9851,9918,9921,10736,10740,10741,10742,10743,11356,14374,14735,14837) GROUP BY subtyp1