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

Surnames > A > AP > APF

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
APA APE APF APG API APK APL APO APP APR APS APT APU

Full Surname List Starting with APF(Alphabetical)

APFEL
APFELBAUM
APFELBECK

Top 100 Surnames in the 2010 US Census starting with APF

SurnameCountRankWiki?
APFEL 768 30420 no
APFELBAUM 271 71886 no
APFELBECK 144 120187 no