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

Surnames > M > MI > MIW

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

MIWA

Top 100 Surnames in the 2010 US Census starting with MIW

SurnameCountRankWiki?
MIWA 232 81458 no