WHMCS export hosting services

whmcs-export.sql

SELECT tblhosting.domain, tblservers.name, tblhosting.domainstatus, tblproducts.name , CONCAT(tblclients.firstname, ' ', tblclients.lastname) AS Client, tblclients.status AS Clientstatus
FROM tblhosting 
LEFT JOIN tblproducts ON tblhosting.packageid = tblproducts.id
LEFT JOIN tblservers ON tblhosting.server = tblservers.id
LEFT JOIN tblclients ON tblhosting.userid = tblclients.id
WHERE tblhosting.domainstatus IN ('Active', 'Suspended')
ORDER BY tblservers.id ASC
INTO OUTFILE '/tmp/whmcs.csv';