Сортировка категорий в модуле mod_virtuemart_categories - [VM1] Дизайн, оформление

	function __construct()
	{
		$this->_buildTree();
		$this->_active = JRequest::getInt('category_id', 0);
	}

	/**
	 * method to get categories from table
	 *
	 * @access private
	 * @return array
	 */
	function _load()
	{
		$database =& JFactory::getDBO();

		$query = 'SELECT c.category_id as id, x.category_parent_id as parent, c.category_name as name, c.category_thumb_image as image '
						.'FROM #__vm_category AS c '
						.'LEFT JOIN #__vm_category_xref AS x '
						.'ON c.category_id = x.category_child_id '
						.'WHERE c.category_publish = "Y" '
						.'ORDER BY x.category_parent_id, c.list_order '
						;

		$database->setQuery($query);

		return $database->loadObjectList();
	}