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