$criteria = new CDbCriteria();
 
        $pcriteria->join = 'LEFT JOIN {{position}} a ON t.id = a.id';
 
        $criteria->condition='a.posid=2';
 
        $criteria->limit='6';
 
        $criteria->order='t.inputtime desc';
 
        $positions = Download::model()->findAll($pcriteria);