Skip to content

Smiley usage

Technical discussion which is not directly related to VGM files. Talk about Hardware and Software.

Moderator: Staff

Smiley usage

Post by vampirefrog »

Here are smileys used on this forum and their numbers.

:) 354
:D 154
:P 132
;) 117
:( 58
:wink: 25
:mrgreen: 23
:beer: 21
:-) 15
:shock: 14
:O_o: 14
:3 12
:o 12
:oops: 12
:roll: 12
8| 11
:lol: 11
:| 10
:bash: 10
:ihih: 9
:thumbup: 8
:? 8
:hurr: 7
:fly: 5
:devious: 4
:cry: 4
:x 3
:hide: 3
;-) 3
:bump: 3
:?: 3
:-( 3
:wave: 2
:shy: 2
:penguin: 2
:number1: 2
:world: 2
:omg: 2
:lemming: 2
:disco: 2
:heart: 2
:clap: 2
:2: 2
:silence: 2
:spy: 1
:sumo: 1
:wine2: 1
:magnifying: 1
:lift2: 1
:headphones: 1
:artist2: 1
:hamtaro: 1
:bath: 1
:wall: 1
:duck3: 1
:drool: 1
:perfect: 1
:chicken2: 1
:dead: 1
:google: 1
:runaway: 1
:toilet: 1
:banana: 1
:hellokitty3: 1
:blues2: 1
:joy: 1
:game: 1
:notes: 1
:grr: 1
:wine: 1
:heel: 1
:homer: 1
:emoticons: 1
:computer: 1
:party2: 1
:cop: 1
:book: 1
:hatsoff: 1
:monkey2: 1
:omg2: 1
:help: 1
:matrix: 1
:love: 1
:cry2: 1
:xmas: 1
:music2: 1
:mad: 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