SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Herzogenrath{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCity = 'Herzogenrath' OR prZip = 'Herzogenrath' OR prStreet LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Herzogenrath{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCountry = 'Herzogenrath') AND (prLocation LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}/{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}/{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCountry = '/') AND (prLocation LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Kohlscheid{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCity = 'Kohlscheid' OR prZip = 'Kohlscheid' OR prStreet LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Kohlscheid{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCountry = 'Kohlscheid') AND (prLocation LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Germany{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}Germany{e1fbfe1c93adf932e1f835b97be1da31b3612ed4240d53b2e453c4eac5af3c3f}' OR prCountry = 'Germany')