SELECT
tag
FROMtags
GROUP BYtag
ORDER 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
tag
FROMtags
GROUP BYtag
ORDER 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