| | |
| | | left join com_sanshuo_expert t1 on t.specialist_id=t1.id |
| | | where t.event_process_status not in (9) |
| | | and t1.level=4 |
| | | AND app_id='wx0cef797390444b75' |
| | | AND t.app_id='wx0cef797390444b75' |
| | | </select> |
| | | <select id="expertSolveCountCenter" resultType="java.lang.Integer"> |
| | | select count(t.id) from com_sanshuo_event_info t |
| | | left join com_sanshuo_expert t1 on t.specialist_id=t1.id |
| | | where t.event_process_status not in (9) |
| | | and t1.level=2 |
| | | AND app_id='wx0cef797390444b75' |
| | | AND t.app_id='wx0cef797390444b75' |
| | | </select> |
| | | <update id="updateLog"> |
| | | update com_sanshuo_expert_event set status = 2 |