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