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