SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Lamalou%les%Bains' OR name LIKE 'Lamalou%les%Bains-Cote dAzur' OR name LIKE 'Lamalou%les%Bains area' OR name LIKE 'Lamalou%les%Bains city' OR name LIKE 'Lamalou%les%Bains coast' OR name LIKE 'Lamalou%les%Bains island'