SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Pays%de%la%Loire' OR name LIKE 'Pays%de%la%Loire-Cote dAzur' OR name LIKE 'Pays%de%la%Loire area' OR name LIKE 'Pays%de%la%Loire city' OR name LIKE 'Pays%de%la%Loire coast' OR name LIKE 'Pays%de%la%Loire island'