| | |
|---|
| | | |
|---|
| | | <select id="selectColumnAndCount" resultType="com.ycl.vo.message.MessageColumnSetVO" > |
|---|
| | | SELECT |
|---|
| | | count(1) as messageNumber, |
|---|
| | | t4.column_name AS columnName |
|---|
| | | count( 1 ) AS messageNumber, |
|---|
| | | t2.column_name AS columnName |
|---|
| | | FROM |
|---|
| | | `ums_message_column_set` t1 |
|---|
| | | LEFT JOIN ums_message_column_set t2 ON t1.message_column_id = t2.id |
|---|
| | | LEFT JOIN ums_message_column t4 ON t2.message_column_id = t4.id |
|---|
| | | LEFT JOIN ums_message t3 ON t2.id=t3.message_type |
|---|
| | | LEFT JOIN ums_message_column t2 ON t1.message_column_id = t2.id |
|---|
| | | LEFT JOIN ums_message t3 ON t2.id = t3.message_type |
|---|
| | | <where> |
|---|
| | | t2.is_receive=1 |
|---|
| | | t1.is_receive=1 |
|---|
| | | <if test="userId !=null"> |
|---|
| | | and t1.user_id = #{userId} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | GROUP BY |
|---|
| | | t4.column_name |
|---|
| | | t2.column_name |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | </mapper> |
|---|
