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 = 'OI' order by rank asc limit 0,100 Surnames > O > OI > OIE

Surnames > O > OI > OIE

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
OA OB OC OD OE OF OG OH OI OJ OK OL OM ON OO OP OQ OR OS OT OU OV OW OX OY OZ
OI OIE OIL OIN OIS OIT OIU

Full Surname List Starting with OIE(Alphabetical)

OIE
OIEN

Top 100 Surnames in the 2010 US Census starting with OIE

SurnameCountRankWiki?
OIEN 955 25793 no
OIE 349 58182 no