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
4
BAGS & PANNIERS
2
1
BIKE RACKS
3
1
BOTTLES
4
3
CAGES
5
1
CHILD SEATS & TRAILERS
6
1
COOL WEATHER ACCESSORIES
7
2
GLOVES
8
3
KICKSTANDS
9
1
LIGHTS
10
1
LOCKS
11
5
LUBES & DEGREASERS
12
1
MIRRORS
CACHED
false
EXECUTIONTIME
19
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 (1066,1236,1275,1276,6653,10355,10391,10512,10670,15371,16117,16491,17153,17388,17822,19235,19477,19664,19978,20035,20653,20654,20658,21459)
GROUP BY subtyp1