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	126	ACCESSORIES
2	32	BASELAYERS
3	58	BOTTOMS
4	94	BY ACTIVITY
5	292	FOOTWEAR
6	30	OUTERWEAR
7	102	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,165,166,167,168,173,177,328,329,333,353,357,359,374,376,387,389,391,421,429,430,435,684,685,688,698,764,788,791,793,804,809,825,843,846,849,851,856,1051,1052,1307,1330,1380,1561,1562,1563,1565,1572,1578,1579,1580,1582,1583,1584,1585,1626,1747,1749,1751,1753,1754,1776,1827,1831,1840,1841,1845,1853,1854,1863,1874,1890,1891,1892,1902,1904,1905,1906,1944,1946,1953,1958,1959,1965,1975,1976,1996,1997,2007,2092,2124,2135,2137,2138,2141,2145,2146,2147,2149,2150,2156,2157,2162,2168,2172,2174,2175,2177,2182,2196,2199,2202,2205,2208,2210,2211,2213,2214,2216,2217,2221,2222,2223,2232,2235,2237,2238,2239,2240,2241,2242,2244,2247,2253,2338,2362,2696,2697,2777,2790,2791,2794,2805,2810,2821,2823,2851,2854,2858,2863,2865,2877,2912,2946,2977,3001,3088,3089,3090,3091,3093,3094,3095,3098,3243,3244,3245,3246,3258,3259,3260,3327,3328,3331,3334,3336,3342,3346,3349,3350,3351,3354,3371,3410,3412,3496,3497,3515,3516,3528,3529,3538,3544,3547,3550,3564,3591,3599,3600,3604,3619,3620,3623,3637,3638,3640,3641,3643,3664,3669,3675,3685,3686,3687,3689,3692,3797,3879,4093,4138,4218,4256,4270,4276,4279,4291,4303,4319,4320,4321,4334,4359,4362,4384,4387,4430,4437,4442,4443,4784,4785,4786,4788,4789,4798,4799,4803,4842,4846,4847,4848,4852,4853,4895,4918,4923,4931,4933,4934,4936,4937,4938,4942,4947,4948,4952,4954,4956,4962,4964,4966,4970,4971,4973,4979,4981,4989,4990,4992,4993,4995,5002,5004,5018,5032,5033,5215,5233,5235,5236,5238,5239,5242,5249,5252,5254,5260,5264,5280,5281,5284,5296,5298,5299,5301,5302,5305,5306,5309,5313,5314,5316,5324,5325,5339,5358,5360,5362,5364,5380,5405,5430,5437,5456,5471,5472,5473,5479,5522,5548,5550,5551,5552,5553,5575,5583,5598,5639,5640,5641,5643,5644,5645,5652,5653,5655,5657,5658,5662,5671,5695,5697,5706,5711,5719,5722,5731,5733,5742,5743,5744,5745,5747,5748,5752,5753,5762,5763,5772,5773,5777,5818,5830,5831,5842,5845,5851,5855,5864,5865,5866,5868,5869,5870,5872,5875,5882,5896,5897,5900,5914,5918,6153,6164,6176,6257,6281,6308,6312,6357,6502,6558,6863,7256,7974,8011,8014,8030,8038,8075,8077,8140,8145,8150,8151,8166,8176,8177,8185,8191,8195,8199,8200,8207,8209,8218,8249,8251,8252,8259,8260,8268,8269,8281,8282,8285,8318,8326,8328,8623,8639,8664,8791,8793,8795,8796,8799,8805,8806,8809,8811,8814,8820,8849,8854,8884,8886,8902,8916,8917,8918,8928,8937,8951,8966,8990,8993,9029,9042,9043,9045,9046,9047,9048,9049,9060,9063,9064,9065,9066,9067,9130,9148,9259,9260,9264,9265,9266,9268,9378,9395,9399,9400,9460,9478,9518,9551,9560,9597,9598,9599,9603,9643,9651,9662,9670,9718,9737,9754,9764,9775,9832,9836,9837,9871,9880,9906,9908,9910,9917,9920,9922,10140,10232,10234,10235,10241,10242,10245,10246,10254,10281,10286,10332,10334,10338,10366,10433,10434,10435,10608,10631,10687,10699,10718,10719,10720,10729,10922,10926,10931,10932,10935,11226,11228,11250,11291,11292,11293,11303,11305,11318,11319,11321,11343,11361,11372,11373,11374,11376,11377,11378,11379,11382,11383,11384,11385,11387,11475,11476,11626,11627,11628,14075,14094,14124,14129,14141,14142,14199,14278,14279,14280,14281,14283,14284,14285,14286,14288,14289,14298,14301,14303,14304,14305,14340,14342,14424,14489,14491,14523,14525,14526,14529,14553,14554,14556,14560,14561,14568,14602,14634,14637,14684,14743,14764,14765,14766,14782,14784,14796,14806,14807,14817,14818,14842,14846,14847,14925,14961,14962,15043,15105,15192,15204,15213,15214,15215,15216,15248,12,354,434,1292,1294,1573,1574,1575,1576,1615,1616,1907,1910,1920,1928,1929,1930,1935,2218,2219,2342,2798,2960,3129,3337,3393,4048,4461,4462,4890,4896,5287,5291,5295,5304,5707,5813,5815,5857,5878,5884,6310,6324,6337,6348,6988,7109,7337,7437,8073,8074,8079,8821,8912,8981,8983,9021,9022,9024,9028,9131,9355,9416,9426,9427,9552,9620,9851,9877,9918,9921,10736,10737,10740,10741,10742,10743,11356,11458,14374,14744) GROUP BY subtyp1