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