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 = 'GO' order by rank asc limit 0,100 Surnames > G > GO > GOJ

Surnames > G > GO > GOJ

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
GA GB GD GE GF GH GI GJ GL GM GN GO GR GS GU GW GY
GO GOA GOB GOC GOD GOE GOF GOG GOH GOI GOJ GOK GOL GOM GON GOO GOP GOR GOS GOT GOU GOV GOW GOY GOZ

Full Surname List Starting with GOJ(Alphabetical)

GOJCAJ
GOJKOVICH
GOJMERAC

Top 100 Surnames in the 2010 US Census starting with GOJ

SurnameCountRankWiki?
GOJCAJ 604 36970 no
GOJKOVICH 138 124548 no
GOJMERAC 102 158432 no