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

Surnames > R > RI > RIJ

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

RIJAL
RIJO
RIJOS

Top 100 Surnames in the 2010 US Census starting with RIJ

SurnameCountRankWiki?
RIJO 894 27081 no
RIJOS 560 39281 no
RIJAL 217 86005 no