public static function getTerminatingServers()
{
return Scalr::getDb()->GetAll("\n SELECT\n s.`server_id`, s.`client_id`, s.`env_id`, s.`platform`, s.`status`, s.`dtshutdownscheduled`,\n te.`attempts`\n FROM `servers` s\n LEFT JOIN `server_termination_errors` te ON te.`server_id` = s.`server_id`\n WHERE (s.`status` = ? OR (s.`dtshutdownscheduled` IS NOT NULL AND (s.`status` = ? OR s.`status` = ?)))\n AND (te.`server_id` IS NULL OR te.retry_after <= NOW())\n ORDER BY s.`dtshutdownscheduled`, te.`attempts`\n ", [SERVER_STATUS::TERMINATED, SERVER_STATUS::PENDING_TERMINATE, SERVER_STATUS::PENDING_SUSPEND]);
}