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