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 > MIV

Surnames > M > MI > MIV

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 MIV(Alphabetical)

MIVILLE

Top 100 Surnames in the 2010 US Census starting with MIV

SurnameCountRankWiki?
MIVILLE 262 73911 no