| | |
|---|
| | | FROM com_convenient_merchants ccm |
|---|
| | | LEFT JOIN (SELECT * FROM com_convenient_consultation_statistics WHERE statistic_date LIKE #{currentMon}) cccs ON ccm.id = cccs.merchant_id |
|---|
| | | LEFT JOIN com_convenient_service_scope ccss ON ccm.id = ccss.merchant_id |
|---|
| | | WHERE ccm.community_id = #{pageSearchDTO.communityId} AND ccm.business_status = 1 AND ccm.`name` LIKE CONCAT('%', #{pageSearchDTO.keyword}, '%') |
|---|
| | | WHERE (ccm.community_id = #{pageSearchDTO.communityId} or ccm.community_id = 0) AND ccm.business_status = 1 AND ccm.`name` LIKE CONCAT('%', #{pageSearchDTO.keyword}, '%') |
|---|
| | | AND ccm.is_del = 0 GROUP BY cccs.id |
|---|
| | | ) temp GROUP BY temp.id ORDER BY SUM(temp.consultation_volume) DESC |
|---|
| | | </select> |
|---|
