Array
(
    [product_in_stock] => `p`.product_in_stock
    [virtuemart_product_id] => `p`.virtuemart_product_id
)

SELECT `l`.`product_name`, `p`.product_in_stock, `p`.virtuemart_product_id FROM `joom_virtuemart_products` as p
 LEFT JOIN `joom_virtuemart_products_ru_ru` as ld ON ld.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `joom_virtuemart_products_uk_ua` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `joom_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  LEFT JOIN `joom_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  LEFT JOIN `joom_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` 
WHERE ( `pc`.`virtuemart_category_id` IN (11)  AND 
  `c`.`published` = 1  AND 
  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND 
  p.`published`="1" ) AND p.`virtuemart_product_id`!="5159" 
 AND `p`.product_in_stock  =  "1000000" 
ORDER BY `p`.product_in_stock DESC, `p`.virtuemart_product_id DESC  LIMIT 1

SELECT `l`.`product_name`, `p`.product_in_stock, `p`.virtuemart_product_id FROM `joom_virtuemart_products` as p
 LEFT JOIN `joom_virtuemart_products_ru_ru` as ld ON ld.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `joom_virtuemart_products_uk_ua` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `joom_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  LEFT JOIN `joom_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  LEFT JOIN `joom_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` 
WHERE ( `pc`.`virtuemart_category_id` IN (11)  AND 
  `c`.`published` = 1  AND 
  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND 
  p.`published`="1" ) AND p.`virtuemart_product_id`!="5159" 
AND p.`virtuemart_product_id`!="5344" AND `p`.product_in_stock  >=  "1000000" 
ORDER BY `p`.product_in_stock ASC, `p`.virtuemart_product_id ASC  LIMIT 1

virtuemart_user_id

virtuemart_user_id

_:all