Вывод статей из категории и подкатегории $query->where('catid = 162'); - Joomla 2.5: Общие вопросы

$query = $db->getQuery(true);
		$query->select('id, title, created, introtext ');
		$query->from('#__content');
		$query->where('catid = 162');
		$query->where('state = 1');
		$query->order('ordering');
		$db->setQuery($query);
		$list = $db->loadObjectList();

$query1 = $db->getQuery(true);
		$query1->select('a.id AS id, a.title AS title, a.created AS created, a.introtext AS introtext ');
		$query1->from('#__content AS a');
		$query1->innerJoin('#__categories AS b ON (b.id=a.catid)');
		$query1->where('b.parent_id = 162');
		
$query = $db->getQuery(true);
		$query->select('id, title, created, introtext ');
		$query->from('#__content');
		$query->where('catid = 162');
		$query->unionDistinct($query1);
		$query->where('state = 1');
		$query->order('ordering');
		$db->setQuery($query);
		$list = $db->loadObjectList();

$id = 162;
$cid = array();
$db = JFactory::getDbo();
$query = $db->getQuery( true );
$query->select( 'lft, rgt' )->from( '#__categories' )->where( 'id=' . $id );
$category = $db->setQuery( $query )->loadObject();

$query->clear();
$query->select( 'id' )->from( '#__categories' )->where( 'lft>=' . $category->lft )->where( 'rgt<=' . $category->rgt )->order( 'lft ASC' );
$categories = $db->setQuery( $query )->loadObjectList();

foreach ( $categories as $category ) {
	$cid[] = $category->id;
}

$query->clear();
$query->select( 'id, title, created, introtext ' )
	->from( '#__content' )
	->where( 'catid IN(' . implode( ',', $cid ). ')' )
	->where( 'state = 1' )
	->order( 'ordering' );
$list = $db->setQuery( $query )->loadObjectList();

$id = 162;
$cid = array();
$db = JFactory::getDbo();
$query = $db->getQuery( true );
$query->select( 'lft, rgt' )->from( '#__categories' )->where( 'id=' . $id );
$category = $db->setQuery( $query )->loadObject();
 
$query->clear();
$query->select( 'id' )->from( '#__categories' )->where( 'lft>=' . $category->lft )->where( 'rgt<=' . $category->rgt )->order( 'lft ASC' );
$categories = $db->setQuery( $query )->loadObjectList();
 
foreach ( $categories as $category ) {
	$cid[] = $category->id;
}
 
$query->clear();
$query->select( 'id, title, created, introtext ' )
	->from( '#__content' )
	->where( 'catid IN(' . implode( ',', $cid ). ')' )
	->where( 'state = 1' )
	->order( 'ordering' );
$list = $db->setQuery( $query )->loadObjectList();

 public static function getList(&$params)
    {
	
	    $klub_resorts = JText::sprintf('MOD_TABLERESORTS_PARAMETR_LABEL', $params->get('klub_resorts'));

	    $db	= JFactory::getDbo();
			
		$query = $db->getQuery(true);
		$query->select('id, title, params');
		$query->from('#__resort');
		$query->where('catid = 145');
		$db->setQuery($query);
		$list = $db->loadObjectList();

		return $list;
	   
    }

 public static function getList(&$params)
    {
	
	    $klub_resorts = JText::sprintf('MOD_TABLERESORTS_PARAMETR_LABEL', $params->get('klub_resorts'));

	    $db	= JFactory::getDbo();
			
		$query = $db->getQuery(true);
		$query->select('id, title, params');
		$query->from('#__resort');
		$query->where('catid = 145');
		$query->where('catid = 147');
		$query->where('catid = 146');
		$db->setQuery($query);
		$list = $db->loadObjectList();

		return $list;
	   
    }

$query->where('catid = 145 OR catid = 146 OR catid = 147');

$query->where('catid IN(145, 146, 147)');