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