SELECT pagename, COUNT(DISTINCT ipaddress) AS visit_count FROM log_visitors GROUP BY pagename ORDER BY visit_count DESC;
Źródło: https://stackoverflow.com/questions/1841426/is-it-possible-to-group-by-multiple-columns-using-mysql