Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/num_mailboxes_of_client.sql

Created November 4, 2013 14:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save siliconmeadow/7303559 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303559 to your computer and use it in GitHub Desktop.
Download ZIP
To find the number of mailboxes a client has on a Plesk server
Raw
num_mailboxes_of_client.sql
SELECT COUNT( mail.mail_name )
FROM clients, domains, mail
WHERE clients.id =2
AND clients.id = domains.cl_id
AND domains.id = mail.dom_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment