SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Hagen{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCity = 'Hagen' OR prZip = 'Hagen' OR prStreet LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Hagen{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCountry = 'Hagen') AND (prLocation LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}/{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}/{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCountry = '/') AND (prLocation LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Emst{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCity = 'Emst' OR prZip = 'Emst' OR prStreet LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Emst{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCountry = 'Emst') AND (prLocation LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Germany{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}Germany{47b168e1172ee22cbb22b11905bde4819aeced431cc9517c349cbde4b92f94ec}' OR prCountry = 'Germany')