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