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