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