12 vmdebug getneighbors = Var0: 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 (64) 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`!="5481"
AND `p`.product_in_stock = "2147483647"
ORDER BY `p`.product_in_stock DESC, `p`.virtuemart_product_id DESC LIMIT 1