Question Commandline utilities

Just use this SQL query:

select clients.login, domains.name from domains,clients where domains.cl_id=clients.id and type='reseller';
 
Or you can get a list of domains belonging to a specific reseller:

select clients.pname, domains.name from domains,clients where domains.cl_id=clients.id and type='reseller'and pname='John Doe';
 
Back
Top