How to write this query using active record?

[eluser]Unknown[/eluser]
Hi,

I have a long sql query, I want to write it using active record class, and yet, I find it too complicated to convert it, anyone can help with this? Here is the query:

SELECT haberler.hseo, haberler.hbaslik, kategori.seo, COUNT(yorum.yid) as toplam FROM haberler INNER JOIN yorum ON haberler.id = yorum.hid INNER JOIN kategori ON haberler.hkate = kategori.kid WHERE (haberler.hdurum = 1 AND yorum.durum = 1) GROUP BY haberler.hseo ORDER BY toplam DESC LIMIT 10