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

Surnames > L > LI > LIQ

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
LI LIA LIB LIC LID LIE LIF LIG LII LIJ LIK LIL LIM LIN LIO LIP LIQ LIR LIS LIT LIU LIV LIW LIY LIZ

Full Surname List Starting with LIQ(Alphabetical)

LIQUE
LIQUORI

Top 100 Surnames in the 2010 US Census starting with LIQ

SurnameCountRankWiki?
LIQUORI 783 29986 no
LIQUE 178 101247 no