public function getLimitClause($limit = 0)
    {

        $query = NULL;
        $page = $this->getState("currentpage", 0);
        $limit = empty($limit) ? (int)$this->getListLimit() : $limit;
        $offset = $this->getListOffset($page, 0);

        if (!empty($limit)):
            $this->setListLimit($limit);
            $this->setListOffset($offset);
            $query = "\nLIMIT {$offset}, {$limit}\t";
        endif;

        //Return limit query
        return $query;
    }