User:Pfctdayelise/Babel-usage

From Wikimedia Commons, the free media repository

select concat("| [[Template:",tl_title,"]] || ", count(*),"\n|-") 
from templatelinks join page on tl_from = page_id 
where page_namespace = 2 and tl_namespace = 10 
and tl_title like "User\\_%" 
group by tl_title 
order by tl_title;

Template:User_1	1
Template:User_ANI-1	3
Template:User_ANI-2	1
Template:User_BG	5
Template:User_BG-1	2
Template:User_BG-2	3
Template:User_BG-3	3
Template:User_CommonwealthE_Canadian	1
Template:User_IND_Wiki	1
Template:User_India	1
Template:User_NRI	1
Template:User_PH	2
Template:User_PH-1	1
Template:User_VG	2
Template:User_VG-0	1
Template:User_VG-1	4
Template:User_VG-2	2
Template:User_VG-3	2
Template:User_WikiProject_Macintosh	1
Template:User_admin	17
Template:User_af	1
Template:User_af-1	6
Template:User_af-2	5
Template:User_af-n	1
Template:User_als	24
Template:User_als-1	6
Template:User_als-2	5
Template:User_als-3	3
Template:User_an-1	3
Template:User_an-2	1
Template:User_ar	3
Template:User_ar-1	6
Template:User_ar-2	2
Template:User_ar-3	1
Template:User_ast	1
Template:User_ast-1	2
Template:User_ast-3	1
Template:User_aus_Bayern	1
Template:User_aus_Deutschland	1
Template:User_aus_Europa	1
Template:User_aus_Mainz	1
Template:User_aus_Niederösterreich	1
Template:User_aus_Nordrhein-Westfalen	1
Template:User_aus_Rheinland-Pfalz	1
Template:User_aus_Sachsen	1
Template:User_be	3
Template:User_be-1	3
Template:User_be-2	1
Template:User_bg	6
Template:User_bg-1	5
Template:User_bg-3	7
Template:User_bg-N	2
Template:User_blank	1
Template:User_blogat	2
Template:User_bm-1	1
Template:User_br	1
Template:User_browser:Mozilla	1
Template:User_bs-1	2
Template:User_by	3
Template:User_ca	27
Template:User_ca-1	11
Template:User_ca-2	11
Template:User_ca-3	7
Template:User_carbon	1
Template:User_cs	22
Template:User_cs-1	21
Template:User_cs-2	5
Template:User_cs-3	4
Template:User_cy-1	2
Template:User_cy-2	1
Template:User_da	27
Template:User_da-1	33
Template:User_da-2	30
Template:User_da-3	15
Template:User_de	578
Template:User_de-0	15
Template:User_de-1	305
Template:User_de-2	125
Template:User_de-3	189
Template:User_de-4	6
Template:User_dk-2	1
Template:User_el	5
Template:User_el(a)-1	1
Template:User_el(a)-2	4
Template:User_el(a)-3	1
Template:User_el-1	6
Template:User_el-2	3
Template:User_el-3	1
Template:User_en	244
Template:User_en-0	19
Template:User_en-1	340
Template:User_en-2	822
Template:User_en-3	797
Template:User_en-4	93
Template:User_en-N	12
Template:User_en-n	3
Template:User_eo	1
Template:User_eo-0	1
Template:User_eo-1	36
Template:User_eo-2	17
Template:User_eo-3	6
Template:User_eo-4	3
Template:User_es	125
Template:User_es-0	1
Template:User_es-1	213
Template:User_es-2	103
Template:User_es-3	82
Template:User_es-4	2
Template:User_et-1	4
Template:User_et-2	1
Template:User_et-N	2
Template:User_eu	1
Template:User_eu-1	4
Template:User_fa	3
Template:User_fi	29
Template:User_fi-1	4
Template:User_fi-2	1
Template:User_fi-3	8
Template:User_firefox	1
Template:User_fo-1	2
Template:User_fr	274
Template:User_fr-0	3
Template:User_fr-1	393
Template:User_fr-2	191
Template:User_fr-3	111
Template:User_fr-4	2
Template:User_fr-D	1
Template:User_fr-N	1
Template:User_fy-1	1
Template:User_ga-0	1
Template:User_ga-1	3
Template:User_ga-2	3
Template:User_gl	7
Template:User_gl-1	7
Template:User_gl-3	3
Template:User_got-2	1
Template:User_grc-1	4
Template:User_grc-2	2
Template:User_gu	1
Template:User_gu-1	1
Template:User_he	8
Template:User_he(a)-1	1
Template:User_he-1	7
Template:User_he-2	2
Template:User_he-3	2
Template:User_head	3
Template:User_hi-1	1
Template:User_hi-2	5
Template:User_hi-3	1
Template:User_hr	6
Template:User_hr-1	8
Template:User_hr-2	1
Template:User_hr-3	3
Template:User_hu	15
Template:User_hu-1	3
Template:User_hu-2	2
Template:User_hu-3	4
Template:User_hu-N	10
Template:User_hy-1	2
Template:User_ia-1	1
Template:User_id	3
Template:User_id-1	2
Template:User_id-2	1
Template:User_ipa-4	1
Template:User_is	2
Template:User_is-1	3
Template:User_is-3	2
Template:User_it	69
Template:User_it-0	7
Template:User_it-1	120
Template:User_it-2	37
Template:User_it-3	26
Template:User_it-4	1
Template:User_it-N	1
Template:User_itsalt	1
Template:User_ja	210
Template:User_ja-0	1
Template:User_ja-1	67
Template:User_ja-2	14
Template:User_ja-3	19
Template:User_ke-2	1
Template:User_kn	1
Template:User_ko	9
Template:User_ko-0	1
Template:User_ko-1	5
Template:User_ko-2	4
Template:User_ku-2	1
Template:User_la-0	2
Template:User_la-1	108
Template:User_la-2	43
Template:User_la-3	6
Template:User_lb	4
Template:User_lb-0	1
Template:User_lb-1	3
Template:User_lb-2	2
Template:User_lb-3	1
Template:User_li	1
Template:User_li-1	1
Template:User_li-3	1
Template:User_ln-1	1
Template:User_ln-3	1
Template:User_lt	3
Template:User_lt-1	1
Template:User_lt-2	1
Template:User_lt-3	1
Template:User_lv	1
Template:User_lv-1	2
Template:User_lv-3	1
Template:User_mad	1
Template:User_mff	1
Template:User_ml	1
Template:User_ms-2	2
Template:User_mt	1
Template:User_nb	1
Template:User_nb-2	4
Template:User_nb-3	4
Template:User_nds-1	12
Template:User_nds-2	5
Template:User_nl	45
Template:User_nl-0	1
Template:User_nl-1	54
Template:User_nl-2	17
Template:User_nl-3	20
Template:User_nl-N	4
Template:User_nn	6
Template:User_nn-1	8
Template:User_nn-2	8
Template:User_nn-3	13
Template:User_no	26
Template:User_no-1	23
Template:User_no-2	22
Template:User_no-3	19
Template:User_oc-1	3
Template:User_or	1
Template:User_ot-5	1
Template:User_pl	126
Template:User_pl-1	16
Template:User_pl-2	1
Template:User_pl-3	13
Template:User_pt	54
Template:User_pt-1	31
Template:User_pt-2	17
Template:User_pt-3	27
Template:User_pt-br	1
Template:User_qu-1	1
Template:User_red	1
Template:User_ro	9
Template:User_ro-1	4
Template:User_ro-2	4
Template:User_ro-3	2
Template:User_ru	46
Template:User_ru-1	96
Template:User_ru-2	24
Template:User_ru-3	17
Template:User_ru-4	1
Template:User_sa-2	1
Template:User_sah	1
Template:User_sc	1
Template:User_sc-2	1
Template:User_sc-3	1
Template:User_scn-1	1
Template:User_scn-2	1
Template:User_sco-2	1
Template:User_se-2	1
Template:User_sh	3
Template:User_sh-3	1
Template:User_si-2	1
Template:User_sk	7
Template:User_sk-1	6
Template:User_sk-2	8
Template:User_sk-3	2
Template:User_sl	7
Template:User_sl-1	2
Template:User_sl-2	1
Template:User_sp-2	1
Template:User_sq	2
Template:User_sq-2	1
Template:User_sr	5
Template:User_sr-1	5
Template:User_sr-2	1
Template:User_sr-3	1
Template:User_sr-4	1
Template:User_sr-5	1
Template:User_structurist	1
Template:User_style	4
Template:User_sv	55
Template:User_sv-0	1
Template:User_sv-1	52
Template:User_sv-2	52
Template:User_sv-3	15
Template:User_ta	1
Template:User_ta-1	1
Template:User_ta-N	1
Template:User_taiwan	1
Template:User_th	3
Template:User_th-1	2
Template:User_th-2	1
Template:User_th-3	2
Template:User_tr	8
Template:User_tr-1	6
Template:User_tr-2	6
Template:User_tr-3	4
Template:User_tt-1	1
Template:User_uk	4
Template:User_uk-1	13
Template:User_uk-2	4
Template:User_uk-3	3
Template:User_vec	1
Template:User_vi-2	1
Template:User_vn-1	1
Template:User_wa	1
Template:User_wa-1	2
Template:User_wa-2	1
Template:User_wa-4	1
Template:User_win	5
Template:User_xh-1	1
Template:User_yi-1	1
Template:User_zea-3	1
Template:User_zh	37
Template:User_zh-0	1
Template:User_zh-1	22
Template:User_zh-2	16
Template:User_zh-3	13
Template:User_zh-4	1
Template:User_zh-N	4
Template:User_zh-min-nan	4
Template:User_zh-min-nan-1	5
Template:User_zh-min-nan-2	3
Template:User_zh-min-nan-3	4
Template:User_zh-yue	12
Template:User_zh-yue-3	1
Template:User_zodiac:Scorpio	1