[eluser]FREEZA[/eluser]
Hello community!
How could i write this code in active record codeigniter syntax?
Code:
SELECT u.uid, u.picture, u.name, u.gender,
e.id as entry_id, e.content, DATE_FORMAT(e.datum, "%d.%m.%Y %H:%i Uhr") AS datum, e.anonym,
d.id, d.name as kategorie_name,d.color,
COUNT(c.id) AS anzahl_kommentare
FROM user u
INNER JOIN entry e ON ( e.uid = u.uid )
LEFT JOIN comment c ON ( c.e_id = e.id )
LEFT JOIN cat d ON ( d.id = e.cat_id )
GROUP BY u.uid, u.picture,
e.id, e.content, e.datum, e.anonym
ORDER BY e.datum DESC LIMIT 6';
Any idea?