title: run the query in Codeigniter
body: <p>how this query use in Codeigniter</p>
  
  <pre><code>`SELECT `messages`.`id`, left(`messages`.`message`, 150) 
       as 'message', `messages`.`message_group_id`, `messages`.`date_added` 
   FROM (`messages`) WHERE `message_group_id` = '".$messageGroupID."' 
   ORDER BY `messages`.`id` desc LIMIT 1`
  </code></pre>