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