SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (11098,11099,11100,11101,11106,11110,11111,11112,11113,11121,11122,11125,11130,11133,11134,11135,11136,11137,11138,11139,11150,11151,15274,17131,11093,11103,11109,11115,11120,11146)
GROUP BY subtyp1 |