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