[go: up one dir, main page]

Number of available Emojis

edit

Currently: 9564, quarry

Roughly usage of each of the collections

edit
select count(*) from globalimagelinks where gil_to like "NAME%";
Twemoji (Includes Twemoji2 series also)

377423

Emoji (Google)

108635

Phantom Open Emoji

212

Fxemoji

3714

Emojione

119282


Most used Emojis

edit
SELECT il_to, c FROM (
    SELECT il_to, COUNT(*) as c
      FROM imagelinks JOIN globalimagelinks on gil_to = il_to
     WHERE il_from = (
           SELECT page_id
             FROM page
            WHERE page_title = "Emoji" AND page_namespace = 0
           )
  GROUP BY gil_to
) as T ORDER BY c DESC
Return to "Emoji/query" page.