[Per]

SELECT 
 DISTINCT(sokningsfras) AS `sokningsfras`,
 COUNT(sokningsfras) AS `antal`
FROM 
 sokningstabell 
ORDER BY
 `antal` DESC 
GROUP BY 
 sokningsfras