List all active domains: SELECT name FROM domains WHERE status = '0'

List all suspended domains: SELECT name FROM domains WHERE status = '16'

List all expired (hosting) domains: SELECT name FROM domains WHERE status = '256'

List all domains with backup/restore in progress: SELECT name FROM domains WHERE status = '4'

List all domains suspended by client: SELECT name FROM domains WHERE status = '64'