I've got ISPConfig running, serving just over 300 domains. One of the problems I have to deal with occasionally is that sometimes the customer name and the domain name aren't related. If I have to change some user settings for "midwestthingamajig.com" and have a customer entry named "Midwest Thingamajig Company" my task is easy. But if a customer named "Zaphod Beebblebrox" owns domain "starsearchersclub.net", I could be clicking client records for quite a while until I stumble across Herr Beebblebrox's entry. What SQL query can I issue to display isp_isp_kunde.kunde_anrede, kunde_firma, kunde_name, etc given a domain name of "starsearchersclub.net"? Or as a more generalized question, I know how to print a list of domain names; how would I print a list of clients, with the domains configured for each? Or a list of the domains configured, with the client controlling each? Any or all of the those queries would be a huge help. I'm still trying to come to terms with the way that everything is tied together through the various tables.