mysql多表连接，取出count值

select      

s.id ,
 s.name, qf.id qfid, s.small_pic smallPic,s.hasnum,  s.price,
 s.description, s.kind, s.unitprice, s.storage, s.sendway, s.eachnum, s.amountnum 
,count(s.id), 
IFNULL(ms.countsysgift,0)   /*mysql没有nvl函数，用这ifnull(exp,exp2)判断,*/

FROM  sys_gift s 
left join que_re_flow_gift qg on (s.id = qg.sys_giftid) 
left join que_re_flow qf on (qf.id = qg.que_re_flowid)
left join member_gift mg on s.id=mg.sys_giftid
left join 
    (select count(mg.sys_giftid) countsysgift, mg.sys_giftid from member_gift mg where mg.send_state=1 GROUP BY mg.sys_giftid) ms  /*取出count值*/
on ms.sys_giftid = s.id
where 1=1
	
GROUP BY s.id