VirtueMart 1.1.3 stable - выгрузка товаров в яндекс.маркет - страница 6 - [VM1] Импорт-экспорт данных

 $query = "

SELECT

           if ($product_discount_id == "0")
             {
              echo"<price>$product_price</price>\n";
             }
           else
            {
вот тут должны быть какие то запросы по идее....
              {
                $product_price = $product_price - $product_price * product_discount_id / 100;
                echo"<price>$product_price</price>\n";
              }
            }

$query = "
SELECT
	$tb_product.product_id,
	$tb_product.product_name,
	$tb_manufacturer.mf_name,
	$tb_manufacturer.manufacturer_id,
	$tb_category.category_name,
	$tb_category.category_id,
	$tb_product_category_xref.category_id,
	$tb_price.product_price,
	$tb_product.product_sku,
	$tb_product.product_in_stock,
	$tb_product.product_unit,
	$tb_product.product_full_image,
	$tb_product.product_s_desc, $tb_product.product_desc,
	$tb_product.product_weight
FROM
	($tb_product_category_xref
RIGHT JOIN ($tb_price
RIGHT JOIN (($tb_product_mf_xref
RIGHT JOIN $tb_product
ON $tb_product_mf_xref.product_id = $tb_product.product_id)
LEFT JOIN $tb_manufacturer
ON $tb_product_mf_xref.manufacturer_id = $tb_manufacturer.manufacturer_id)
ON $tb_price.product_id = $tb_product.product_id)
ON $tb_product_category_xref.product_id = $tb_product.product_id)
LEFT JOIN $tb_category
ON $tb_product_category_xref.category_id = $tb_category.category_id
WHERE $tb_product.product_publish='Y'";

echo"<vendor>".$row[$i]['mf_name'] ."</vendor>\n";