ah sorry I wasn't aware there was a difference between them!

I managed to get it working now by adding a ORDER BY count DESC LIMIT 1 to the end to return only the highest value. If there's a better way...