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