SELECT Count ตารางที่ไม่มีข้อมูลให้คืนค่า 0 ไม่ทราบต้องแก้ไขอย่างไรครับ

SELECT tbl_item.*, COUNT(coalesce( tbl_like.refid, 0)) AS c FROM tbl_like 
INNER JOIN tbl_item ON tbl_like.refid = tbl_item.id 
WHERE tbl_like.`status` <> '0' 
GROUP BY coalesce( tbl_like.refid, 0)
ORDER BY c DESC

SELECT t1.*, sum(coalesce( t2.like, 0)) AS c FROM t1 
left JOIN t2 on t2.refid = t1.id 
GROUP BY t1.id
ORDER BY c DESC