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