SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Nord%Pas%de%Calais' OR name LIKE 'Nord%Pas%de%Calais-Cote dAzur' OR name LIKE 'Nord%Pas%de%Calais area' OR name LIKE 'Nord%Pas%de%Calais city' OR name LIKE 'Nord%Pas%de%Calais coast' OR name LIKE 'Nord%Pas%de%Calais island'