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