select b.*,t.* from (select RECOMMEND_ID,count(RECOMMEND_ID ) as sum from BO_EU_SUPPLIER_RECOMMEND group by RECOMMEND_ID) t left join BO_EU_SUPPLIER_RECOMMEND b on t.RECOMMEND_ID=b.RECOMMEND_ID where ???

select b.*,t.* from (select RECOMMEND_ID,count(RECOMMEND_ID ) as sum from BO_EU_SUPPLIER_RECOMMEND group by RECOMMEND_ID) t left join BO_EU_SUPPLIER_RECOMMEND b on t.RECOMMEND_ID=b.RECOMMEND_ID where ???