Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/domains_by_client_in_plesk.sql

Created November 4, 2013 14:39
Show Gist options
  • Save siliconmeadow/7303417 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303417 to your computer and use it in GitHub Desktop.
Download ZIP
To find domain names and hosting types by client in Plesk.
Raw
domains_by_client_in_plesk.sql
SELECT domains.name, domains.htype, clients.cname
FROM domains, clients
WHERE clients.id = domains.cl_id
AND clients.id = <(an integer)>
ORDER BY domains.htype ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment