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