| | |
|---|
| | | } |
|---|
| | | // wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 ) "); |
|---|
| | | // wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 )"); |
|---|
| | | wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 ) "); |
|---|
| | | wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 )"); |
|---|
| | | // wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 ) "); |
|---|
| | | // wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on specialist_id=com_sanshuo_expert.id where event_process_status=6 )"); |
|---|
| | | List<ComSanshuoExpert> comSanshuoExperts = comSanshuoExpertDao.selectList(wrapper); |
|---|
| | | for (ComSanshuoExpert comSanshuoExpert : comSanshuoExperts) { |
|---|
| | | //获取成功率 |
|---|
