SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}Cancelada{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}Cancelada{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}Spain{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}Spain{3a77437c4f002e76ccc6058ba2d666bb643911077db50c46dc08748681745bb8}' OR prCountry = 'Spain')