permissions2csv.sql

SELECT permission.permission,
  (SELECT 1 FROM account2permission
      WHERE permission.id = account2permission.permissionid
      AND account.id = account2permission.accountid),
      account.comment
FROM account, permission
WHERE account.accounttypeid != 5
ORDER BY permission.permission,account.id;