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