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