SELECT
tagFROMtagsGROUP BYtagORDER BY COUNT(*) DESC LIMIT 50
Wo liegt das Problem?
Probier mal:
SELECT
tag,
COUNT(*)
FROM
tags
GROUP BY
tag
ORDER BY
COUNT(*) DESC
LIMIT
0,
50
SELECT
tagFROMtagsGROUP BYtagORDER BY COUNT(*) DESC LIMIT 50
Wo liegt das Problem?
Probier mal:
SELECT
tag,
COUNT(*)
FROM
tags
GROUP BY
tag
ORDER BY
COUNT(*) DESC
LIMIT
0,
50