SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (3347,4960,7437,8183,10338,10631,14073,14229,14782,15090,15881,16861,16866,16939,16958,16994,17002,17650,18186,18615,19068,19384,19885,20002,20005,20027,20365,20504,20505,20507,20602,20912,20972,20993,21395,21396,21877)
GROUP BY subtyp1 |