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