function lists($kind='', $offset='', $limit='', $pname='', $region='') {
        $sqlLimit = ' limit ' . $limit . ', ' . $offset;
        $sql = 'SELECT a.pid, region, supply, pname, gubun, a.regdate, count(b.aid) as cnt
FROM product_tourapp a left outer join (
	select pid, aid, count(aid)
    from apply_tourapp
    group by aid) as b on (a.pid = b.pid)
group by a.pid desc'. $sqlLimit;
        $this->db->query($sql);
		//$query=$this->db->get('product_tourapp',$limit,$offset);
        
		if ($kind == 'num_rows') {
            $result=$query->num_rows();
        } else {
            $result=$query->result();
        }
        return $result;
    }

위 코드를 시키면 

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

SELECT a.pid, region, supply, pname, gubun, a.regdate, count(b.aid) as cnt FROM product_tourapp a left outer join ( select pid, aid, count(aid) from apply_tourapp group by aid) as b on (a.pid = b.pid) group by a.pid desc limit ,

이런식으로 에러가 발생합니다. limit 변수 쪽 값 입력하는게 문제같은데 이렇게해도 안되고 저렇게해도 안되네요.

고수님들 알려주세요 부탁드립니다.