Database error #1066

Narf is right you should work on your SQL skills before you carry on.

Your error is very basic you can not use the same table in a JOIN and a FROM clause unless you use an ALIAS.

change your join for

PHP Code:

$this->db->join('tags_meta', 'sms.id = tags_meta.sms_id', 'left');
$this->db->join('tags', 'tags_meta.tag_id = tags.id', 'left');