SELECT subtyp_1, web_url
FROM tb_web_taxonomy
WHERE dept='CYCLING' and typ='MEN''S BIKE CLOTHING' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY'
ORDER BY sort_position
query
RESULTSET
query
ITEMCOUNT
SUBTYP1
1
13
BIBS, SHORTS & TIGHTS
2
5
BIKE SHOES
3
7
JERSEYS & JACKETS
CACHED
false
EXECUTIONTIME
30
SQL
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='MENS BIKE CLOTHING' and upper(subtyp1)<>'EMPTY' and style_id IN (2137,2141,2147,2821,5864,5865,5884,8639,10286,10718,10736,11557,14842,15105,15933,16395,16633,17271,18057,19179,19233,19314,19315,20363,21650)
GROUP BY subtyp1