plugins/finder/categories/categories.php
protected function getListQuery($query = null)
	{
		$db = JFactory::getDbo();

		// Check if we can use the supplied SQL query.
		$query = $query instanceof JDatabaseQuery ? $query : $db->getQuery(true)
			->select('a.id, a.title, a.alias, a.description AS summary, a.extension')
			->select('a.created_user_id AS created_by, a.modified_time AS modified, a.modified_user_id AS modified_by')
			->select('a.metakey, a.metadesc, a.metadata, a.language, a.lft, a.parent_id, a.level')
			->select('a.created_time AS start_date, a.published AS state, a.access, a.params');

		// Handle the alias CASE WHEN portion of the query.
		$case_when_item_alias = ' CASE WHEN ';
		$case_when_item_alias .= $query->charLength('a.alias', '!=', '0');
		$case_when_item_alias .= ' THEN ';
		$a_id = $query->castAsChar('a.id');
		$case_when_item_alias .= $query->concatenate(array($a_id, 'a.alias'), ':');
		$case_when_item_alias .= ' ELSE ';
		$case_when_item_alias .= $a_id . ' END as slug';
		$query->select($case_when_item_alias)
			->from('#__categories AS a')
			->where($db->quoteName('a.id') . ' > 1');

		return $query;
	}
protected function getListQuery($query = null)
	{
		$db = JFactory::getDbo();

		// Check if we can use the supplied SQL query.
		$query = $query instanceof JDatabaseQuery ? $query : $db->getQuery(true)
			->select('a.id, a.title, a.alias, a.description AS summary, a.extension')
			->select('a.created_user_id AS created_by, a.modified_time AS modified, a.modified_user_id AS modified_by')
			->select('a.metakey, a.metadesc, a.metadata, a.language, a.lft, a.parent_id, a.level')
			->select('a.created_time AS start_date, a.published AS state, a.access, a.params');

		// Handle the alias CASE WHEN portion of the query.
		$case_when_item_alias = ' CASE WHEN ';
		$case_when_item_alias .= $query->charLength('a.alias', '!=', '0');
		$case_when_item_alias .= ' THEN ';
		$a_id = $query->castAsChar('a.id');
		$case_when_item_alias .= $query->concatenate(array($a_id, 'a.alias'), ':');
		$case_when_item_alias .= ' ELSE ';
		$case_when_item_alias .= $a_id . ' END as slug';
		$query->select($case_when_item_alias)
			->from('#__categories AS a')
			->where($db->quoteName('a.id') . ' > 1');

		return $query;
	}
protected function getListQuery ( $ query = null ) { $ db = JFactory :: getDbo ( ) ; // Check if we can use the supplied SQL query. $ query = $ query instanceof JDatabaseQuery ? $ query : $ db -> getQuery ( true ) -> select ( 'a.id, a.title, a.alias, a.description AS summary, a.extension' ) -> select ( 'a.created_user_id AS created_by, a.modified_time AS modified, a.modified_user_id AS modified_by' ) -> select ( 'a.metakey, a.metadesc, a.metadata, a.language, a.lft, a.parent_id, a.level' ) -> select ( 'a.created_time AS start_date, a.published AS state, a.access, a.params' ) ; // Handle the alias CASE WHEN portion of the query. $ case_when_item_alias = ' CASE WHEN ' ; $ case_when_item_alias .= $ query -> charLength ( 'a.alias' , '!=' , '0' ) ; $ case_when_item_alias .= ' THEN ' ; $ a_id = $ query -> castAsChar ( 'a.id' ) ; $ case_when_item_alias .= $ query -> concatenate ( array ( $ a_id , 'a.alias' ) , ':' ) ; $ case_when_item_alias .= ' ELSE ' ; $ case_when_item_alias .= $ a_id . ' END as slug' ; $ query -> select ( $ case_when_item_alias ) -> from ( '#__categories AS a' ) -> where ( $ db -> quoteName ( 'a.id' ) . ' > 1' ) ; return $ query ; }
Method to get the SQL query used to retrieve the list of content items.

@param   mixed  $query  A JDatabaseQuery object or null.

@return  JDatabaseQuery  A database object.

@since   2.5
Method to get the SQL query used to retrieve the list of content items .