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