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