Skip to content

Instantly share code, notes, and snippets.

@c1982
Created July 20, 2012 14:12
Show Gist options
  • Save c1982/3150939 to your computer and use it in GitHub Desktop.
Save c1982/3150939 to your computer and use it in GitHub Desktop.
SELECT domains.name, hosting.fp_adm, accounts.password, clients.login,
clients.passwd, dom_level_usrs.passwd As DomainPass, domains.status As Status
FROM domains
LEFT JOIN hosting ON hosting.dom_id = domains.id
LEFT JOIN sys_users ON hosting.sys_user_id = sys_users.id
LEFT JOIN accounts ON accounts.id = sys_users.account_id
LEFT JOIN clients ON clients.id = domains.cl_id
LEFT JOIN dom_level_usrs ON dom_level_usrs.dom_id = domains.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment