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