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