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