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

Surnames > A > AJ > AJP

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
AJA AJD AJE AJI AJL AJM AJO AJP AJT AJU

Full Surname List Starting with AJP(Alphabetical)

AJPACAJA
AJPOP

Top 100 Surnames in the 2010 US Census starting with AJP

SurnameCountRankWiki?
AJPACAJA 202 91221 no
AJPOP 125 134712 no