| | |
|---|
| | | 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 = ${communityId} or ccm.community_id = 0) AND ccm.business_status = 1 and ccm.is_del = 0 and ccm.`name` != '犇师傅维修中心' GROUP BY cccs.id |
|---|
| | | WHERE ccm.area_code=#{areaCode} and ( ccm.community_id = ${communityId} or ccm.community_id = 0) AND ccm.business_status = 1 and ccm.is_del = 0 and ccm.`name` != '犇师傅维修中心' GROUP BY cccs.id |
|---|
| | | ) temp GROUP BY temp.id ORDER BY SUM(temp.consultation_volume) DESC |
|---|
| | | </select> |
|---|
| | | <select id="getClassifyMerchants" resultType="com.panzhihua.common.model.vos.community.convenient.ConvenientMerchantVO"> |
|---|
