SELECT COUNT(article) as cnt, farbe FROM mytable GROUP BY farbe;