select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'MI' order by rank asc limit 0,100 Surnames > M > MI > MIA

Surnames > M > MI > MIA

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
MA MB MC ME MG MH MI MJ MK ML MN MO MP MR MU MW MY
MI MIA MIC MID MIE MIF MIG MIH MII MIJ MIK MIL MIM MIN MIO MIQ MIR MIS MIT MIU MIV MIW MIX MIY MIZ

Full Surname List Starting with MIA(Alphabetical)

MIA
MIAH
MIAL
MIALE
MIAN
MIANECKI
MIANI
MIANO
MIAO
MIARA
MIARECKI
MIARS
MIAZGA

Top 100 Surnames in the 2010 US Census starting with MIA

SurnameCountRankWiki?
MIAH 2456 12602 no
MIAN 1735 16544 no
MIAO 1677 16953 no
MIANO 1643 17239 no
MIA 632 35582 no
MIAZGA 453 46902 no
MIAL 243 78567 no
MIARS 221 84748 no
MIANI 182 99378 no
MIALE 177 101737 no
MIARA 158 111426 no
MIARECKI 124 135593 no
MIANECKI 119 140157 no