SELECT id, name, parent FROM villa_loc WHERE name LIKE 'St%Dizier%Leyrenne' OR name LIKE 'St%Dizier%Leyrenne-Cote dAzur' OR name LIKE 'St%Dizier%Leyrenne area' OR name LIKE 'St%Dizier%Leyrenne city' OR name LIKE 'St%Dizier%Leyrenne coast' OR name LIKE 'St%Dizier%Leyrenne island'