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

Surnames > M > MI > MIQ

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

MIQUELI
MIQUELON

Top 100 Surnames in the 2010 US Census starting with MIQ

SurnameCountRankWiki?
MIQUELI 109 150452 no
MIQUELON 100 160975 no