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	146	ACCESSORIES
2	42	BASELAYERS
3	54	BOTTOMS
4	79	BY ACTIVITY
5	276	FOOTWEAR
6	31	OUTERWEAR
7	70	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,168,173,177,328,329,345,353,354,355,357,358,374,376,387,389,421,429,430,435,683,684,685,688,696,698,734,756,784,788,791,793,804,809,825,849,856,1561,1562,1565,1572,1578,1579,1580,1582,1585,1754,1776,1827,1831,1832,1841,1853,1854,1859,1863,1890,1904,1905,1906,1928,1929,1930,1935,1944,1946,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,2239,2240,2241,2362,2696,2697,2777,2778,2781,2785,2787,2790,2794,2796,2805,2810,2821,2823,2854,2858,2863,2865,2912,2957,2960,3001,3073,3088,3089,3090,3091,3092,3093,3094,3095,3098,3104,3245,3246,3258,3259,3260,3327,3328,3331,3336,3342,3346,3349,3350,3351,3354,3379,3397,3398,3407,3408,3410,3412,3496,3497,3515,3520,3528,3538,3544,3570,3571,3573,3589,3599,3620,3623,3637,3638,3643,3654,3658,3662,3663,3664,3666,3669,3675,3685,3686,3687,3692,3797,4048,4093,4218,4256,4276,4279,4291,4319,4320,4321,4334,4359,4362,4384,4387,4443,4784,4786,4788,4789,4798,4799,4803,4848,4852,4918,4923,4924,4934,4936,4937,4938,4948,4956,4962,4964,4966,4970,4971,4973,4979,4981,4989,4990,4992,4993,4995,5002,5004,5027,5215,5225,5233,5235,5242,5264,5269,5270,5273,5280,5281,5291,5294,5296,5299,5300,5302,5304,5306,5309,5314,5324,5325,5339,5346,5358,5360,5362,5364,5390,5405,5433,5439,5449,5451,5471,5473,5522,5545,5548,5583,5598,5625,5639,5640,5641,5644,5645,5652,5653,5662,5694,5697,5706,5707,5719,5722,5731,5733,5747,5752,5753,5763,5772,5773,5777,5830,5831,5842,5845,5851,5855,5864,5868,5870,5872,5875,5882,5897,5900,5914,5918,6064,6176,6257,6308,6309,6312,6337,6357,6502,6558,6863,7014,7256,7437,7989,8030,8031,8077,8140,8145,8150,8151,8166,8176,8177,8185,8191,8195,8200,8207,8209,8251,8252,8259,8269,8281,8282,8285,8318,8326,8328,8507,8516,8517,8525,8529,8543,8545,8623,8664,8791,8795,8799,8805,8806,8809,8814,8849,8854,8869,8884,8902,8911,8918,8919,8928,8990,8993,9021,9022,9027,9029,9042,9043,9045,9046,9047,9048,9049,9060,9063,9064,9065,9066,9067,9069,9130,9131,9145,9148,9149,9259,9260,9264,9265,9266,9268,9377,9396,9399,9400,9426,9427,9460,9478,9518,9524,9575,9597,9598,9599,9624,9626,9651,9669,9670,9746,9764,9784,9827,9832,9837,9849,9850,9868,9880,9906,9908,9910,9949,10140,10234,10241,10242,10246,10254,10281,10286,10332,10334,10338,10433,10434,10501,10608,10631,10687,10699,10718,10720,10729,10922,10926,10931,10932,10935,11226,11228,11250,11291,11292,11293,11303,11305,11343,11361,11362,11376,11377,11458,11475,11476,11543,11544,11545,11626,11627,11628,13924,13959,13960,13961,14020,14071,14072,14075,14094,14099,14101,14124,14129,14140,14141,14142,14199,14203,14205,14278,14281,14282,14284,14303,14304,14342,14424,14489,14508,14560,14561,14568,14619,14620,14624,14637,14648,14684,14727,14731,14732,14737,14738,14764,14765,14782,14784,14806,14807,14832,14833,14834,14835,14836,14837,14838,14839,14840,14846,14847,14925,15043,15089,15105,15126,15127,15131,15204,15215,15248,15376,15413,15415,15421,15422,15424,15425,15429,15436,15496,15497,15503,15514,15518,15523,15524,15525,15526,15527,15539,15540,15561,15567,15573,15574,15633,15635,15638,15640,15643,15663,15732,15733,15737,15739,15740,15743,15744,15745,15746,15747,15748,15749,15759,15761,15766,15792,15793,15844,15845,15846,15851,15852,15875,15908,15909,15912,15914,15931,15944,15946,15994,16001,16002,16005,16107,16112,16120,16121,16122,16125,16144,16148,16162,16169,16170,16228,16239,16338,16353,16354,16365,16388,16389,16475,16520,16521,434,1292,1294,1573,1574,1576,1577,1581,1615,1616,2219,2798,5287,5813,5815,5878,6988,7109,7337,8079,8912,9028,9355,9416,9620,10736,10740,10741,10742,10743,11356,14374) GROUP BY subtyp1