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 (956,1454,1455,1479,1503,1504,1505,1530,1533,1534,1673,1678,1709,1710,1711,1724,4030,4494,4500,4510,4830,5790,8417,8452,9185,9205,11098,11101,11113,11122,11125,11150,11151,14252,14585,14802,15026,16897,17104,17574,19975,3278,9285,9322,11115,11120)
GROUP BY subtyp1 |