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 = 'RI' order by rank asc limit 0,100 Surnames > R > RI > RIQ

Surnames > R > RI > RIQ

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
RA RC RE RH RI RM RO RU RY RZ
RI RIA RIB RIC RID RIE RIF RIG RIH RII RIJ RIK RIL RIM RIN RIO RIP RIQ RIR RIS RIT RIU RIV RIX RIZ

Full Surname List Starting with RIQ(Alphabetical)

RIQUELME
RIQUIER

Top 100 Surnames in the 2010 US Census starting with RIQ

SurnameCountRankWiki?
RIQUELME 951 25865 no
RIQUIER 154 113791 no