| | |
|---|
| | | " AND create_at <![CDATA[<=]]> #{screenEventDTO.endTime} " + |
|---|
| | | " </if> " + |
|---|
| | | "), 0 ) AS yesEventSSPTotal " + |
|---|
| | | " IFNULL(( SELECT count( id ) FROM com_act_easy_photo WHERE del_tag = 0 AND handle_status IS NOT NULL AND community_id = #{screenEventDTO.communityId} ), 0 ) AS eventSSPTotal, " + |
|---|
| | | " IFNULL(( SELECT count( id ) FROM com_act_easy_photo WHERE del_tag = 0 AND handle_status = 2 AND community_id = #{screenEventDTO.communityId} ), 0 ) AS yesEventSSPTotal " + |
|---|
| | | "FROM " + |
|---|
| | | " `event` AS e " + |
|---|
| | | " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + |
|---|
