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 > HAO

Surnames > H > HA > HAO

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 HAO(Alphabetical)

HAO

Top 100 Surnames in the 2010 US Census starting with HAO

SurnameCountRankWiki?
HAO 2452 12622 no