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 = 'LO' order by rank asc limit 0,100 Surnames > L > LO > LOJ

Surnames > L > LO > LOJ

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
LA LE LH LI LJ LL LN LO LU LW LY LZ
LO LOA LOB LOC LOD LOE LOF LOG LOH LOI LOJ LOK LOL LOM LON LOO LOP LOR LOS LOT LOU LOV LOW LOX LOY LOZ

Full Surname List Starting with LOJ(Alphabetical)

LOJA
LOJACONO
LOJANO
LOJAS
LOJEK
LOJEWSKI
LOJKO
LOJO

Top 100 Surnames in the 2010 US Census starting with LOJ

SurnameCountRankWiki?
LOJA 1520 18272 no
LOJEWSKI 393 52736 no
LOJANO 387 53419 no
LOJEK 280 69996 no
LOJKO 230 82044 no
LOJACONO 167 106570 no
LOJO 162 109258 no
LOJAS 110 149395 no