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