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 = 'HA' order by rank asc limit 0,100 Surnames > H > HA > HA

Surnames > H > HA > HA

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
HA HE HI HJ HL HM HN HO HR HS HT HU HV HW HY
HA HAA HAB HAC HAD HAE HAF HAG HAH HAI HAJ HAK HAL HAM HAN HAO HAP HAQ HAR HAS HAT HAU HAV HAW HAX HAY HAZ

Full Surname List Starting with HA(Alphabetical)

HA

Top 100 Surnames in the 2010 US Census starting with HA

SurnameCountRankWiki?
HA 18156 1987 no