$query = $db->getQuery(true);
$query->select('a.virtuemart_product_id, a.product_name, a.product_desc, a.slug as sluggy, p.product_price, c.virtuemart_category_id, cn.slug, m.virtuemart_media_id, ms.file_url')
->from('#__virtuemart_products_ru_ru as a');
$query->join('LEFT', '#__virtuemart_product_prices AS p ON p.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_product_categories AS c ON c.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_categories_ru_ru AS cn ON cn.virtuemart_category_id = c.virtuemart_category_id');
$query->join('LEFT', '#__virtuemart_product_medias AS m ON m.virtuemart_product_id = a.virtuemart_product_id');
$query->join('LEFT', '#__virtuemart_medias AS ms ON ms.virtuemart_media_id = m.virtuemart_media_id');
$query->setLimit('1');
$db->setQuery($query);