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