SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Saint%Chinian' OR name LIKE 'Saint%Chinian-Cote dAzur' OR name LIKE 'Saint%Chinian area' OR name LIKE 'Saint%Chinian city' OR name LIKE 'Saint%Chinian coast' OR name LIKE 'Saint%Chinian island'