| | |
|---|
| | | + " event_category = 1 " + " AND event_type = 6 " + " AND event_status = 2 " |
|---|
| | | + " AND egd3.grid_community_id = #{communityId} " + " ), " + " 0 " + " ) AS eventTSTotal, " |
|---|
| | | + " IFNULL(( " + " SELECT " + " count( e4.id ) " + " FROM " + " `event` AS e4 " |
|---|
| | | + " LEFT JOIN event_grid_data AS egd4 ON egd4.id = e4.grid_id " + " WHERE " + " event_category = 1 " |
|---|
| | | + " AND event_type = 4 " + " AND event_status = 2 " + " AND egd4.grid_community_id = #{communityId} " |
|---|
| | | + " LEFT JOIN event_grid_data AS egd4 ON egd4.id = e4.grid_id " + " WHERE " + " event_category = 2 " |
|---|
| | | + " AND event_status = 2 " + " AND egd4.grid_community_id = #{communityId} " |
|---|
| | | + " ), " + " 0 " + " ) AS eventBWDTotal, " + " IFNULL(( " + " SELECT " + " count( e5.id ) " + " FROM " |
|---|
| | | + " `event` AS e5 " + " LEFT JOIN event_grid_data AS egd5 ON egd5.id = e5.grid_id " + " WHERE " |
|---|
| | | + " event_category = 1 " + " AND event_type = 2 " + " AND event_status = 2 " |
|---|
