Как вывести производителя товара? - [VM1] Модификации и хаки

$data[$row][] = $product['product_sku'];

$fieldnames = "
`#__{vm}_product`.`product_id`, 
`product_name`, 
`products_per_row`, 
`category_browsepage`, 
`category_flypage`, 
`#__{vm}_category`.`category_id`,
`#__{vm}_product`.`product_id`,
`product_full_image`, 
`product_thumb_image`, 
`product_s_desc`, 
`product_parent_id`, 
`product_publish`, 
`product_in_stock`, 
`product_sku`, 
`product_url`, 
`product_weight`, 
`product_weight_uom`, 
`product_length`, 
`product_width`, 
`product_height`, 
`product_lwh_uom`, 
`product_available_date`, 
`product_availability`, 
`#__{vm}_product`.`mdate`, 
`#__{vm}_product`.`cdate`,
`#__{vm}_manufacturer`.`manufacturer_id`,
`#__{vm}_manufacturer`.`mf_name`
";
$count_name = "COUNT(DISTINCT `#__{vm}_product`.`product_sku`) as num_rows";
$table_names = '`#__{vm}_product`, `#__{vm}_category`, `#__{vm}_product_category_xref`,`#__{vm}_shopper_group`';
$join_array = array( 'LEFT JOIN `#__{vm}_product_price` ON `#__{vm}_product`.`product_id` = `#__{vm}_product_price`.`product_id`' );
$join_array[] = 'LEFT JOIN `#__{vm}_product_mf_xref` ON `#__{vm}_product_mf_xref`.`product_id` = `#__{vm}_product`.`product_id`';
$join_array[] = 'LEFT JOIN `#__{vm}_manufacturer` ON `#__{vm}_manufacturer`.`manufacturer_id` = `#__{vm}_product_mf_xref`.`manufacturer_id`';
$where_clause = array();

// GET ALL PUBLISHED PRODUCTS FROM THAT MANUFACTURER
if (!empty($manufacturer_id)) {
//   $table_names .= ',`#__{vm}_product_mf_xref`';   
   $where_clause[]  = "`#__{vm}_manufacturer`.`manufacturer_id`='".$manufacturer_id."'";
//   $where_clause[] = "`#__{vm}_product`.`product_id`=`#__{vm}_product_mf_xref`.`product_id` ";
}

$products[$i]['manufacturer_name'] = $db_browse->f("mf_name");

// Table header

$tableheader[] = $VM_LANG->_('PHPSHOP_PRODUCT_FORM_THUMB_IMAGE');	
$tableheader[] = $VM_LANG->_('PHPSHOP_CART_PRODUKT_NAME');
$tableheader[] = $VM_LANG->_('PHPSHOP_MANUFACTURER_NAME');

//$tableheader[] = $VM_LANG->_('PHPSHOP_CART_PRICE');

$tableheader[] = $VM_LANG->_('PHPSHOP_PRODUCT_FORM_WEIGHT');
$tableheader[] = $VM_LANG->_('PRODUCT_FORM_PACKAGING');
if( _SHOW_PRICES && $auth['show_prices'] ) {
	$tableheader[] = $VM_LANG->_('PHPSHOP_CART_PRICE');
}

if( _SHOW_PRICES && $auth['show_prices'] && USE_AS_CATALOGUE != '1' ) {
	$tableheader[] = $VM_LANG->_('PHPSHOP_CART_СAUTION');
}

/*
...
бла бла бла
...
*/

foreach( $products as $product ) {
		
		foreach( $product as $attr => $val ) {
			// Using this we make all the variables available in the template
			// translated example: $this->set( 'product_name', $product_name );
			$this->set( $attr, $val );
		}
		$data[$row][] = ps_product::image_tag( $product['product_thumb_image'] )
						. 'Apt. ' . $product['product_sku'];
		
		$data[$row][] = $product['product_name'];
		
		$data[$row][] = $product['manufacturer_name'];
		
		$data[$row][] = $product['product_weight'] . ' ' . $product['product_weight_uom'];
		
		$data[$row][] = $product['product_newpackaging'];
		
		if( _SHOW_PRICES && $auth['show_prices'] ) {
			$data[$row][] = $product['product_price'];
		}
		
		if( $product['has_addtocart'] ) {
			$data[$row][] = $product['form_addtocart'];
		}
		else {
			$data[$row][] = '<a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'
							.	$product['product_details']
							.	'</a>';
		}
		
		$row++;
		
}