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