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

true

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	201	ACCESSORIES
2	43	BASELAYERS
3	51	BOTTOMS
4	82	BY ACTIVITY
5	309	FOOTWEAR
6	57	OUTERWEAR
7	115	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,53,56,59,328,329,353,354,355,358,374,376,421,429,430,435,683,684,685,687,688,696,698,702,734,756,780,784,788,791,793,804,825,856,918,930,934,941,946,950,953,1314,1561,1562,1563,1565,1572,1578,1579,1580,1581,1585,1754,1776,1827,1831,1832,1853,1854,1859,1863,1890,1892,1903,1904,1905,1906,1928,1930,1936,1944,1946,1947,1976,1996,2007,2124,2135,2136,2137,2138,2141,2145,2146,2148,2149,2150,2156,2162,2172,2174,2182,2196,2205,2211,2214,2217,2221,2222,2223,2232,2235,2237,2240,2337,2342,2358,2362,2696,2697,2777,2781,2782,2785,2787,2790,2791,2810,2821,2823,2829,2865,2871,2895,2957,2960,2961,2972,2995,3073,3088,3089,3090,3091,3092,3093,3094,3095,3098,3104,3245,3258,3260,3327,3331,3342,3346,3349,3350,3351,3354,3379,3397,3405,3406,3407,3408,3410,3412,3515,3520,3521,3543,3544,3571,3573,3589,3599,3612,3619,3620,3623,3656,3664,3665,3666,3669,3673,3675,3685,3686,3687,3689,3692,3797,4048,4093,4138,4218,4256,4276,4279,4291,4319,4320,4321,4362,4387,4784,4785,4788,4789,4798,4799,4803,4841,4848,4871,4908,4918,4923,4934,4936,4937,4938,4948,4954,4956,4962,4964,4970,4973,4979,4981,4989,4990,4993,4995,5002,5004,5018,5027,5215,5225,5233,5235,5236,5242,5269,5270,5273,5279,5291,5294,5296,5298,5299,5300,5304,5309,5313,5324,5330,5339,5346,5360,5362,5364,5390,5405,5433,5449,5451,5471,5479,5512,5550,5551,5552,5624,5625,5640,5643,5644,5645,5653,5662,5694,5696,5697,5706,5718,5719,5722,5731,5733,5747,5752,5753,5763,5772,5773,5777,5830,5831,5845,5851,5864,5865,5866,5868,5872,5875,5876,5878,5882,5883,5884,5900,5918,6062,6063,6064,6176,6257,6309,6312,6337,6338,6340,6357,6502,6558,7014,7256,7437,8014,8030,8077,8140,8150,8151,8166,8185,8191,8195,8199,8200,8207,8251,8269,8281,8282,8318,8326,8328,8507,8517,8525,8529,8543,8545,8559,8560,8623,8639,8664,8799,8801,8802,8814,8849,8854,8867,8868,8869,8884,8902,8904,8911,8919,8966,8990,9018,9021,9022,9024,9027,9029,9042,9045,9046,9060,9063,9064,9066,9067,9069,9130,9145,9148,9149,9259,9260,9264,9265,9266,9268,9377,9399,9400,9415,9426,9427,9460,9478,9518,9524,9541,9544,9575,9597,9598,9624,9626,9651,9669,9670,9718,9746,9784,9827,9837,9849,9850,9880,9898,9906,9910,9915,9949,10140,10241,10254,10281,10286,10332,10334,10338,10433,10434,10435,10501,10608,10631,10687,10699,10718,10720,10729,10926,10931,10935,11291,11292,11293,11303,11319,11361,11362,11458,11475,11476,11543,11544,11545,11557,11579,11588,11626,11627,13924,13959,13960,13961,14072,14075,14094,14099,14101,14124,14140,14142,14199,14203,14205,14278,14281,14282,14374,14424,14509,14540,14619,14620,14623,14624,14634,14648,14677,14678,14684,14692,14727,14731,14732,14734,14738,14764,14766,14782,14784,14806,14807,14817,14818,14832,14833,14835,14836,14837,14838,14839,14840,14842,14846,15043,15089,15105,15127,15129,15136,15196,15248,15376,15415,15416,15421,15422,15424,15425,15429,15436,15447,15448,15450,15496,15498,15499,15503,15512,15514,15515,15518,15523,15524,15525,15527,15539,15557,15558,15559,15560,15561,15567,15574,15635,15638,15641,15642,15643,15663,15693,15694,15696,15698,15732,15733,15737,15739,15740,15743,15744,15745,15746,15747,15748,15749,15761,15766,15792,15793,15837,15840,15844,15845,15851,15852,15875,15893,15908,15912,15914,15931,15945,15946,15958,15993,15994,16001,16002,16005,16084,16085,16107,16112,16120,16121,16122,16123,16125,16127,16144,16148,16157,16158,16161,16162,16169,16170,16228,16248,16338,16353,16354,16365,16383,16388,16389,16418,16510,16511,16512,16520,16521,16580,16582,16599,16602,16607,16626,16635,16655,16676,16689,16725,16726,16728,16768,16769,16780,16781,16786,16787,16802,16804,16813,16822,16827,16832,16854,16858,16860,16865,16867,16877,16878,16883,16904,16905,16906,16907,16908,16920,16932,16934,16935,16944,16945,16946,16949,16951,16952,16953,16954,16955,16956,16957,16962,16963,16982,16992,16993,16995,17001,17007,17008,17009,17019,17144,17168,17287,17288,17290,17295,17348,17349,17391,17392,17473,17484,17486,17488,17490,17610,17612,17624,17628,17646,17648,17709,17710,17714,17718,17719,17720,17764,17769,17811,17850,17851,17852,17853,17854,17855,17856,17859,17862,17863,17896,17897,17898,17899,17900,17901,17902,17908,17923,17924,17928,17929,17930,17931,17932,17933,17934,17935,17958,17959,17970,17971,17972,17973,17975,18016,18025,18026,18030,18037,18041,18042,18043,18047,18132,18137,18138,18139,18141,18153,18154,18155,18156,18157,18177,18188,18190,18191,18192,18250,18264,18278,18279,18281,18295,18335,18336,18346,18353,18423,18430,18435,18489,18494,18495,18496,18497,18498,18508,18509,18510,18521,18522,18523,18533,18534,18535,18536,18539,18540,434,947,952,1294,1575,1576,1615,1616,2219,5287,5813,6988,7109,8912,9028,9355,9392,9416,9620,10736,10740,10741,11356) GROUP BY subtyp1