需要最有效的方法来根据日期和状态订购一些项目/活动的想法。
目前我有以下疑问。

select tevent.ID, tevent.ename, e_dates.edate, tevent.status, tevent.eactive  from tevent 
LEFT JOIN e_dates on tevent.ID=e_dates.EID) Where tevent.status <> 'delete' and tevent.eactive ='Y'  group by tevent.id order 
by (case when tevent.status = 'closed' and e_dates.edate >= curdate() then 0 
else 1 end), edates.edate desc

我用了一个案例，但它排序的状态，然后按日期，这混淆了人们。
下面是输出

+----+--------------+-----+-----------+
| ID |Edate           | Ename   | Status  | 
+----+--------------+-----+-----------+
|  2  | 2018-09-21    | Event2  | Closed  |
|  5  | 2018-09-15    | Event5  | Closed  | 
|  3  | 2018-12-12    | Event3  | Open    |
|  6  | 2018-10-25    | Event6  | Approved|
|  4  | 2018-10-25    | Event4  | Open    |
|  7  | 2018-10-15    | Event7  | Pending |
|  10 | 2018-10-01    | Event10 | Open    |
|  1  | 2018-09-30    | Event1  | Open    |
|  4  | 2018-09-30    | Event4  | Open    |
|  8  | 2018-09-01    | Event8  | Closed  |
|  11 | 2018-08-25    | Event11 | Closed  |
+----+--------------+-----+-----------+

编辑：我试图完成的是列出事件日期早于事件日期的已结束事件。ie（id 2和id 5）
但希望asc按时间顺序列出未结、已批准、待定的事件状态。
以及关闭事件，其中事件日期（edate）在底部列出的当前日期（now（））之后
例如：

+----+--------------+-----+-----------+
    | ID |Edate           | Ename   | Status  | 
    +----+--------------+-----+-----------+
    |  2  | 2018-09-21    | Event2  | Closed  |
    |  5  | 2018-09-15    | Event5  | Closed  | 
    |  1  | 2018-09-30    | Event1  | Open    |*
    |  4  | 2018-09-30    | Event4  | Open    |*
    |  10 | 2018-10-01    | Event10 | Open    |*
    |  7  | 2018-10-15    | Event7  | Pending |*
    |  4  | 2018-10-25    | Event4  | Open    |*
    |  6  | 2018-10-25    | Event6  | Approved|*
    |  3  | 2018-12-12    | Event3  | Open    |*
    |  11 | 2018-08-25    | Event11 | Closed  |    
    |  8  | 2018-09-01    | Event8  | Closed  |
    +----+--------------+-----+-----------+