select shortcode, (select count(*) from statuses s where text ilike('%:' || ce.shortcode || ':%') and s.uri like '%tkz.one%' ) as total
from custom_emojis ce
where ce."domain" is null
order by total DESC
shortcodetotal
a2love1.564
gaming_heart863
net_telegram858
anime_hamtaro806
gaming_kirby5785
tkz683
lat538
mrock518
anime_doraemon364
ablobcatrave361
anime_db_vegeta2327
anime_slump288
gaming_kirby1284
pikaCheer283
pokeball278
party_parrot269
psyduck242
anime_fairy3232
verified227
charmander204
yui_shrug199
gif_cheer190
onepiece_luffy177
pikachu169
playstation158
anime_slump2157
gaming_kirby2156
nko3c156
nintendo147
juegos_mario147
anime_fairy7145
bun140
gaming1_steam137
anime_fairy4135
net_twitter132
cooldoge131
nobeko_kelian128
gaming_pacman2128
comics_marvel_logo_shield126
eeveecoffee121
iluvu117
gaming_zelda_link116
nkoThink113
gaming_moogle111
net_mastodon111
anime_spy_anya108
catto105
sonic102
xbox101
dancing_panda96
nobeko_music95
catjam93
dragonball91
otros_frog90
nkoOwO88
anime_db_goku86
gaming_kirby2286
gaming_pacman386
comics_marvel181
anime_smoon480
net_twitch80
onepiece_flag276
otros_bunny74
switch73
noviacadaver66
acnh65
anime_smoon364
eevee64
onepiece_bepo62
gaming_zelda_triad61
anime_db_vegeta60
comics_marvel_adead60
anime_toradora60
aplauso59
gaming_kirby458
bulbasaur58
anime_db_krilin58
anime_kny_tanjiro58
anime_totoro56
gaming_slime55
cine_starwars_logo53
jack53
anime_hxh_gon53
otros_grumpy53
000053
otros_bob48
anime_kny_nezuko48
gaming_kirby1548
anime_smoon247
gaming_chocobo47
comics_marvel_hespider46
cine_lotr_gandalf46
birdsite46
nobeko_judging46
anime_db_vegetto45
cine_disney_stich44
squirtle44
gif_link44
thisisfine44
gaming_crash142
gif_devil41
gaming_pacman141
otros_pizzacat40
comics_marvel_min139
tails38
anime_hxh_killua38
cine_lotr_ring38
cine_minion138
net_youtube38
gaming_pacman437
anime_kny_zenitsu37
comics_marvel_pspider37
anime_eva_shinji36
gaming_zelda_espada36
anime_fairy836
gaming_sonic635
anime_ccs34
gaming_xbox34
anime_snk133
cine_hp33
gaming_zelda_navi33
anime_eva_asuka32
anime_smoon132
onepiece_flag31
mastodon31
nyancat_rainbow31
comics_dc_batman30
anime_spy_bond229
comics_marvel_pstrange29
verified_orange29
gaming_zelda_rupee28
gaming_kirby1628
dibus_rym128
gaming_pacman1028
gaming1_epic28
anime_db_cell27
comics_marvel_min227
comics_marvel_hewolverine27
anime_kny_inosuke27
anime_eva_rei26
comics_dc126
nyancat_face26
gaming_wow25
gaming_block25
gaming_wowhorde25
comics_marvel_athor25
gaming_sword25
gaming_sonic325
net_instagram24
cine_hp124
cine_starwars_yoda24
dogno24
onepiece_zoro24
anime_bleach_ichigo24
comics_marvel_adpool24
gaming_kh124
gaming_zelda_escudo23
fediverse23
otros_kitty23
cine_starwars_r223
0w023
cine_disney_simba23
nyancat_body22
cs22
cine_starwars_chew22
cine_otros_tardis22
cine_disney_dory121
sega21
cine_minion221
gaming_kirby2021
cine_disney_chip20
otros_sp120
gaming_overwatch20
cine_starwars_bb820
anime_bnha119
net_discord19
anime_db_vegeta319
gaming_kirby1719
comics_marvel_heironman19
onepiece_franky19
wow18
gaming_max18
cine_disney_mickey18
ff14_active_err18
anime_spy_bond18
anime_initiald18
gaming_kh217
anime_db_piccolo17
anime_bnha317
anime_bnha417
anime_fma_edward17
onepiece_chopper16
musica_nirvana16
dibus_heman216
anime_haikyuu216
anime_spy_yor16
anime_fairy116
anime_hxh_hisoka15
cine_hp_hufflepuff15
onepiece_brook15
linux15
otros_sp215
comics_dc_superman15
anime_db_freezer15
otros_sp315
anime_mononoke14
anime_bleach_soul14
anime_haikyuu114
onepiece_nami13
cine_disney_rose213
cine_hp_ravenclaw13
cine_hp_slytherin13
comics_dc_super13
gaming_dott13
gaming_minecraft13
onepiece_doffy13
comics_marvel_logo_thor12
onepiece_sanji12
comics_marvel_logo_camerica12
comics_marvel_rocket12
anime_spy_loid12
cine_starwars_jedi112
gaming_stadia12
dibus_pp211
cine_disney_donald11
comics_marvel_groot11
gaming_sonic511
dibus_simp_homer11
otros_onigiri11
dibus_tmnt311
dibus_tmnt411
cine_lotr_sam11
otros_sp411
comics_marvel_gaunlet11
comics_marvel_apool11
gaming_zelda_rupee411
heart_asexual10
verified_purple10
gaming_crash210
cine_disney_dory210
anime_bleach10
cine_starwars_t110
dibus_tmnt110
dibus_simp_lisa10
verified_yellow10
dibus_simp_bart10
one10
gaming_splatoon210
verified_green10
comics_dc_flash10
gaming_geforcenow10
anime_db_krilin210
cine_disney_pots9
gaming_sonic49
cine_disney_rose9
comics_marvel_ahulk9
cine_starwars_t29
cine_disney_bella9
gaming_kirby219
gaming_zelda_rupee29
dibus_pp19
musica_greenday9
comics_dc_aqua9
futbol_realmadrid8
comics_marvel_hehulk8
gaming_creed8
anime_bnha58
cine_disney_buzz8
gaming_sonic78
anime_haikyuu48
onepiece_robin8
nkoHeart8
musica_freddy8
heart_rainbow8
dibus_heman18
cine_lotr_frodo8
comics_marvel_airon8
anime_bnha28
gaming_kirby188
onepiece_usopp7
comics_dc_harley7
anime_snk27
dibus_tmnt27
cine_disney_ariel7
verified_red7
ff14_active_warn7
dibus_simp_duff7
musica_metallica7
onepiece_yamato7
anime_smoon57
cine_disney_lamp7
gaming_kirby37
cine_disney_alf7
dibus_simp_maggie6
onepiece_roger6
onepiece_shanks6
cine_disney_buzz26
firefox6
ff14_active_ques6
dibus_pp36
gaming_sonic96
dibus_pink26
dibus_dora6
gaming_zelda_rupee36
gnu6
heart_transgender6
comics_dc_wonderwoman6
comics_dc_ivy6
comics_dc_green6
neurodiversity6
verified_multi6
anime_fairy26
anime_nausicaa6
cine_hp_gryffindor6
onepiece_ace6
onepiece_buggy6
cine_disney_flanders5
musica_dualipa5
anime_snk35
cine_disney_minnie5
gaming_splatoon15
onepiece_kaido5
net_facebook5
cine_disney_gato5
onepiece_law5
dibus_pink15
onepiece_oden5
gaming_king5
anime_smoon65
cine_disney_goofy5
vadecloud5
gaming_luna5
comics_marvel_logo_cmarvel5
tkz_one5
cine_disney_tremaine4
gaming1_battlenet4
comics_dc_cat4
futbol_barcelona4
futbol_atletico4
anime_fairy64
anime_fma_roy4
anime_haikyuu34
gaming_sonic84
anime_hxh_kurapika4
cine_disney_genio4
onepiece_kidd4
cine_starwars_t34
dibus_simp_marge4
pardino4
over184
cine_cine4
onepiece_jimbe4
gaming_boosteroid4
onepiece_niji4
musica_elvis4
musica_daft4
comics_marvel_logo_hawkeye4
futbol_getafe3
futbol_rayo3
comics_marvel_acap3
cine_disney_ali3
onepiece_sabo3
futbol_betis3
futbol_valencia3
gaming_wowally3
futbol_sevilla3
gaming_zelda_rupee53
onepiece_boa3
nkoShy3
nkoPet3
cwtiPizza3
nkoStars3
futbol_athletic3
nkoButt3
musica_elton3
nkoTrankten3
musica_madona3
dibus_tom3
ff14_afk2
futbol_realsociedad2
futbol_villareal2
futbol_girona2
futbol_celta2
futbol_cadiz2
futbol_almeria2
futbol_alaves2
ff14_busy2
futbol_palmas2
dibus_animaniacs2
comics_marvel_logo_hulk2
comics_marvel_logo_blackwidow2
logo_peertube2
musica_bowie2
musica_lana2
musica_sia2
comics_dc_teens2
nkoCool2
nkoDrink2
nkoGun2
nkoSmile2
cine_starwars_jedi22
onepiece_katakuri2
otros_onigiri22
otros_sp52
anime_hxh_hisoka32
anime_hxh_hisoka22
anime_fairy52
verified_cool2
futbol_granada2
futbol_mallorca2
futbol_osasuna2
nkoSleep1
nkoMoney1
nkoMad1
rock1
marinera1
gaming_shadow1
nkoHungry1
nkoHi1
nkoHate1
nkoFood1
gaming_plumbob1
nkoDown1
nkoMusic1
nkoBrain1
nkoAngel1
vf1
nkoAha1
comics_dc_aquaman1
onepiece_king1
nkoWat1
musica_lenon1
nkoUps1
nkoTongue1
nkoSweat1
nkoSpy1
tkzone0