SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}Haar{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}' OR prCity = 'Haar' OR prZip = 'Haar' OR prStreet LIKE '{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}Haar{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}' OR prCountry = 'Haar') AND (prLocation LIKE '{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}Germany{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}Germany{30b473333e10f94087f100f5f45d722698d679dc06870b532a8ab722b5d0de3c}' OR prCountry = 'Germany')