Выгрузка товаров в Яндекс.Маркет для VirtueMart 3.x, VirtueMart 4 - страница 23 - [VM2&3] Импорт-экспорт данных

$query = 'SELECT DISTINCT a.virtuemart_product_id, a.product_parent_id, a.product_sku, a.virtuemart_vendor_id, a.product_in_stock, b.product_name, b.product_s_desc, d.product_tax_id, d.product_discount_id, d.product_price, d.product_override_price, d.override, d.product_currency, e.mf_name, e.virtuemart_manufacturer_id, g.virtuemart_category_id FROM (#__virtuemart_product_categories g LEFT JOIN (#__virtuemart_product_prices d RIGHT JOIN ((#__virtuemart_product_manufacturers f RIGHT JOIN #__virtuemart_products a ON f.virtuemart_product_id = a.virtuemart_product_id) LEFT JOIN #__virtuemart_manufacturers_'.$lang.' e ON f.virtuemart_manufacturer_id = e.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_products_'.$lang.' b ON b.virtuemart_product_id = a.virtuemart_product_id) ON d.virtuemart_product_id = a.virtuemart_product_id) ON g.virtuemart_product_id = a.virtuemart_product_id) WHERE a.published = 1 AND d.product_price > 0 AND b.product_name <> \'\' AND g.virtuemart_category_id NOT IN ('.EXCLUDE_CAT.') AND a.virtuemart_product_id NOT IN ('.EXCLUDE_PROD.') GROUP BY a.virtuemart_product_id';

1111 - Invalid use of group function SQL=SELECT DISTINCT a.virtuemart_product_id, a.product_parent_id, a.product_sku, a.virtuemart_vendor_id, a.product_in_stock, b.product_name, b.product_s_desc, d.product_tax_id, d.product_discount_id, MIN(d.product_price), d.product_override_price, d.override, d.product_currency, e.mf_name, e.virtuemart_manufacturer_id, g.virtuemart_category_id FROM (#__virtuemart_product_categories g LEFT JOIN (#__virtuemart_product_prices d RIGHT JOIN ((#__virtuemart_product_manufacturers f RIGHT JOIN #__virtuemart_products a ON f.virtuemart_product_id = a.virtuemart_product_id) LEFT JOIN #__virtuemart_manufacturers_ru_ru e ON f.virtuemart_manufacturer_id = e.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_products_ru_ru b ON b.virtuemart_product_id = a.virtuemart_product_id) ON d.virtuemart_product_id = a.virtuemart_product_id) ON g.virtuemart_product_id = a.virtuemart_product_id) WHERE a.published = 1 AND MIN(d.product_price) > 0 AND b.product_name <> '' AND g.virtuemart_category_id NOT IN (126,127) AND a.virtuemart_product_id NOT IN (0) GROUP BY a.virtuemart_product_id
			
			You may not be able to visit this page because of:
			
				an out-of-date bookmark/favourite
				a search engine that has an out-of-date listing for this site
				a mistyped address
				you have no access to this page
				The requested resource was not found.
				An error has occurred while processing your request.
			
			Please try one of the following pages:
			
				Home Page
			
			If difficulties persist, please contact the System Administrator of this site and report the error below.
			
			Invalid use of group function SQL=SELECT DISTINCT a.virtuemart_product_id, a.product_parent_id, a.product_sku, a.virtuemart_vendor_id, a.product_in_stock, b.product_name, b.product_s_desc, d.product_tax_id, d.product_discount_id, MIN(d.product_price), d.product_override_price, d.override, d.product_currency, e.mf_name, e.virtuemart_manufacturer_id, g.virtuemart_category_id FROM (#__virtuemart_product_categories g LEFT JOIN (#__virtuemart_product_prices d RIGHT JOIN ((#__virtuemart_product_manufacturers f RIGHT JOIN #__virtuemart_products a ON f.virtuemart_product_id = a.virtuemart_product_id) LEFT JOIN #__virtuemart_manufacturers_ru_ru e ON f.virtuemart_manufacturer_id = e.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_products_ru_ru b ON b.virtuemart_product_id = a.virtuemart_product_id) ON d.virtuemart_product_id = a.virtuemart_product_id) ON g.virtuemart_product_id = a.virtuemart_product_id) WHERE a.published = 1 AND MIN(d.product_price) > 0 AND b.product_name <> '' AND g.virtuemart_category_id NOT IN (126,127) AND a.virtuemart_product_id NOT IN (0) GROUP BY a.virtuemart_product_id

<?php
$loadForShopperGroupId = 11;
$productModel = VmModel::getModel('product');
$shoppergroupsprices = $productModel->loadProductPrices($product->virtuemart_product_id,$quantity,array($loadForShopperGroupId),true);

foreach ($shoppergroupsprices as $sgPrice) {
    if ($sgPrice['virtuemart_shoppergroup_id'] == $loadForShopperGroupId) {
        $clubprice = $sgPrice['product_price'];
        if ($sgPrice['override']==1) {
            $clubprice = $sgPrice['product_override_price'];
        } else if ($sgPrice['override']==-1) {
            //get VatTax
            $total_vat_tax = 0;
            foreach ($product->prices['VatTax'] as $vat_tax) {
                $total_vat_tax = $total_vat_tax + $vat_tax[1];
            }
            $total_vat_tax = 1 + ($total_vat_tax / 100);
            $clubprice = $sgPrice['product_override_price'] * $total_vat_tax;
        }
        echo 'Member price: '. $this->currency->priceDisplay($clubprice,0,1,false,2,'Member price' );
    }
}
?>