SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (1827,1831,1832,1840,1859,1890,1892,1903,1904,1905,1906,1907,1909,1928,1936,1944,1946,1947,14727,14731,14732,14734,14737,14738,15196,15197,15557,15558,15559,15560,15561,15635,15638,15641,15642,15643,18037,18041,18042,18047,18177,18924,18928,18931,18935,19875,19879,19882,1918)
GROUP BY subtyp1 |