Talk:Emoji/query

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

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