Smiley usage

[vampirefrog]

Here are smileys used on this forum and their numbers.

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