Why doesn't CodeIgniter's order_by() affect query()?
Why doesn't order_by() work in the following CodeIgniter script?
$this->db
->order_by("id", "desc")
->query('SELECT @rownum:=@rownum+1 rownum, t.* FROM (SELECT @rownum:=0) r, hotel_submits t');