354
154
132
117
58
25
23
21
15
14
14
12
12
12
12
11
11
10
10
9
8
8
7
5
4
4
3
3
3
3
3
3
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
And here is the query:
Code: Select all
SELECT s.code, count(p.post_id) as num_posts
FROM phpbb3_smilies s
JOIN phpbb3_posts p ON p.post_text LIKE CONCAT('%<!-- s', s.code, ' -->%')
GROUP BY s.smiley_id
ORDER BY num_posts DESC