How to add data from another table?

Question

MySQL

Hello. I make such a request (based on codeigniter with its orm, but I think it will be clear)

$this->db->where('id_sender', $id_contact);
    $this->db->where('id_recipient', $id_user);
    $this->db->limit(5);
    $this->db->order_by('id', 'desc');
    $data = $this->db->get('messages');

Now I need to add data from the icons table, I do this:

$data = $this->db->query("SELECT
      a.*,
      b.*,
      FROM messages AS a LIMT 5

      LEFT JOIN icons AS b ON b.name = a.content

      WHERE (a.id_sender = $id_contact AND a.id_recipient = $id_user) ORDER BY a.id DESC");

But there's a mistake somewhere, I can't figure out where.
Thank you in advance.

Answer 1

The word LIMIT is not correctly spelled and it seems to be at the very end of the request.