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