SELECT
article.MakaleID,
article.MakaleKat,
article.MakaleKatID,
article.MakaleBaslik,
article.MakaleYazi,
article.MakaleTiklanma,
article.MakaleYayinlamaTarihi,
administrator.YoneticiKulAdi,
administrator.YoneticiKulResim,
category.KategoriAdi,
  
COUNT(comment.YaziID) AS Yorumsayisi // Kac Adet Yorum Yazıldıgını Ogrenmek İçin  yazdım
  
FROM
article
LEFT JOIN category ON category.KategoriID = article.MakaleKat
LEFT JOIN administrator ON administrator.YoneticiID = article.YoneticiID
LEFT JOIN comment ON article.MakaleID = comment.YaziID // Makale tablomla Yorum Tablomdaki YaziID lerini birleştirdim
 
GROUP BY 1
ORDER BY article.MakaleID DESC