WHMCS 删除用户无效产品SQL命令

查找已经被删除的产品服务
SELECT * FROM tblhosting WHERE domainstatus = 'Terminated'

删除已经被删除的产品服务
DELETE FROM tblhosting WHERE domainstatus = 'Terminated'

查找已经被取消的产品服务
SELECT * FROM tblhosting WHERE domainstatus = 'Cancelled'

删除已经被取消的产品服务
DELETE FROM tblhosting WHERE domainstatus = 'Cancelled'