<?php

/**
 * Category
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 * 
 * @package    okey
 * @subpackage model
 * @author     Your name here
 * @version    SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $
 */
class Category extends BaseCategory
{
 public function PostWithCategories($limit=0){
    	
		$q = NewsTable::getInstance()->createQuery('a');
		
		$q->innerJoin('a.NewsCategory nc');
		
		$q->where('nc.category_id='.$this->getId());
    	
		$q->andWhere('a.type=0')->limit($limit);
        
		$q->orderBy('a.published_at Desc');
    	
		return $q;
    }
}