SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}Haan{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}Haan{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}' OR prCountry = 'Haan') AND (prLocation LIKE '{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}Germany{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}Germany{93cb4f19520e9df87af3f330854863442e0177b3da9c895d179ff4b4e126fbaf}' OR prCountry = 'Germany')