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 = 'AE' order by rank asc limit 0,100 Surnames > A > AE > AER

Surnames > A > AE > AER

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
AEB AED AEG AEH AEI AEL AEM AEP AER AES

Full Surname List Starting with AER(Alphabetical)

AERNI
AERTS
AERY

Top 100 Surnames in the 2010 US Census starting with AER

SurnameCountRankWiki?
AERTS 533 40909 no
AERY 344 58876 no
AERNI 321 62359 no