Arcadian Shop | Outdoor Specialty Store

struct
ACTION	[empty string]
BRAND	[empty string]
CHOOSEADDRESS	[empty string]
CONFIRM	NO
CURRENTPAGE	1
Color	[empty string]
DEPT	Cycling
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	cycling-accessories
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Accessories
WEB_TAXONOMY_ID	752
mapping	/cycling-accessories
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Bags & Panniers	cycling-accessories-bags_and_panniers
2	Bells & Horns	cycling-accessories-bells_and_horns
3	Bike Racks	cycling-accessories-bike_racks
4	Body Care	cycling-accessories-body_care
5	Bottles	cycling-accessories-bottles
6	Cages	cycling-accessories-cages
7	Child Seats & Trailers	cycling-accessories-child_seats_and_trailers
8	Cool Weather Accessories	cycling-accessories-cool_weather_accessories
9	Computers	cycling-accessories-computers
10	Fenders	cycling-accessories-fenders
11	Gloves	cycling-accessories-gloves
12	Helmets	cycling-accessories-helmets
13	Kickstands	cycling-accessories-kickstands
14	Lights	cycling-accessories-lights
15	Locks	cycling-accessories-locks
16	Lubes & Degreasers	cycling-accessories-lubes_and_degreasers
17	Mirrors	cycling-accessories-mirrors
18	Body Protection	cycling-accessories-body_protection
19	Pumps	cycling-accessories-pumps
20	Trainers	cycling-accessories-trainers

CACHED

false

EXECUTIONTIME

SQL

SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CYCLING' and typ='ACCESSORIES' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	60	BAGS & PANNIERS
2	12	BELLS & HORNS
3	4	BIKE RACKS
4	4	BODY CARE
5	2	BODY PROTECTION
6	10	BOTTLES
7	17	CAGES
8	2	CHILD SEATS & TRAILERS
9	30	COMPUTERS
10	20	COOL WEATHER ACCESSORIES
11	6	FENDERS
12	24	GLOVES
13	22	HELMETS
14	8	KICKSTANDS
15	13	LIGHTS
16	10	LOCKS
17	29	LUBES & DEGREASERS
18	5	MIRRORS
19	17	PUMPS
20	3	TRAINERS

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CYCLING' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (130,960,1049,1066,1076,1085,1234,1236,1275,1276,2051,2140,2142,2159,2735,2817,2822,5794,5795,5796,5801,5802,5805,5806,5836,5859,5890,5895,5916,5917,6388,6394,6417,6438,6441,6447,6457,6525,6526,6586,6587,6625,6770,6862,7024,7051,7094,7205,7233,7266,7306,7347,7417,7465,7532,7592,7593,7607,7608,7610,7667,7732,7734,7740,7750,7786,7817,7827,7830,7854,8736,8739,8741,9124,9958,9997,10144,10263,10355,10386,10391,10430,10467,10468,10472,10484,10503,10504,10506,10509,10511,10512,10514,10589,10590,10593,10624,10627,10634,10670,10698,10711,10723,10731,10739,10918,10956,10960,10961,10967,11419,11452,11482,11512,11528,11548,11558,11583,11604,11609,11618,13894,14135,14150,14160,14496,14536,14654,14685,14687,14741,14768,14841,14936,14993,14999,15052,15064,15115,15183,15186,15202,15234,15307,15308,15351,15364,15437,15488,15676,15702,15754,15778,15900,15901,15917,15932,15954,16080,16115,16117,16118,16180,16291,16310,16364,16396,16460,16491,16770,16987,17052,17060,17061,17062,17083,17148,17153,17238,17294,17330,17331,17341,17342,17388,17395,17479,17512,17536,17551,17553,17654,17661,17733,17736,17737,17771,17777,17822,17845,17875,17876,17877,17977,17978,18058,18167,18256,18326,18501,18552,18736,18838,18839,18939,19175,19204,19235,19246,19291,19293,19368,19372,19455,19477,19514,19569,19622,19635,19659,19660,19664,19666,19670,19869,19938,19940,19941,19942,19978,20035,20101,20135,20139,20387,20389,20406,20518,20650,20651,20652,20654,20655,20656,20657,20658,20660,20669,20678,20679,20772,20792,20802,20835,20907,20909,20910,20970,21009,21010,21238,21459,21460,21462,21598,21599,21601,21686,21687,21705,21715,21716,21718,21719,21720,21737,21738,21814,21959,21960,21961,21962,22063,22152,22499,7377) GROUP BY subtyp1