What's wrong with this code? =/

[eluser]emily12[/eluser]
look at the bottom of the previous post (bold text). That's the database structure for the tables in question. The column names don't really matter since they can be anything. I just want to know the logic behind it lol

Here's kinda where I want to be going with it:

Code:

function get_allcomments($cmlimit) {
            $this->db->select('*');
            $this->db->from ('entertainment_comments AS p, articles_comment AS g');
            $this->db->join('users AS b', 'p.cme_articles_author = b.user_id', 'left');
            $this->db->join('entertainment AS c', 'p.cme_articles_article = c.earticleid', 'left');
            $this->db->join('articles AS k' 'g.cm_articles_article = k.articleid', 'left');
            $this->db->order_by('p.cme_articles_date, g.cm_articles_date' 'desc');
            $this->db->limit($cmlimit);
            return $this->db->get();
}

Obviously this won't work but it's where I want to go with it.