SELECT "SearchEngineID", "SearchPhrase", COUNT(*) AS c FROM hits_partitioned WHERE "SearchPhrase" <> '' GROUP BY "SearchEngineID", "SearchPhrase" ORDER BY c DESC LIMIT 10;