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

Surnames > B > BY > BY

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
BA BE BH BI BJ BL BO BR BS BU BY BZ
BY BYA BYB BYC BYD BYE BYF BYG BYH BYI BYK BYL BYM BYN BYO BYR BYS BYT BYU BYW BYX BYZ

Full Surname List Starting with BY(Alphabetical)

BY

Top 100 Surnames in the 2010 US Census starting with BY

SurnameCountRankWiki?
BY 225 83541 no