SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Aachen{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Aachen{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCountry = 'Aachen') AND (prLocation LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}/{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}/{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCountry = '/') AND (prLocation LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Haaren{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCity = 'Haaren' OR prZip = 'Haaren' OR prStreet LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Haaren{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCountry = 'Haaren') AND (prLocation LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Germany{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}Germany{ac43aecaf055c947636a9d776b091f2101dbca788bdf63673b4809b5426bdb07}' OR prCountry = 'Germany')