0

SQL=SELECT p.`virtuemart_product_id`, `l`.`product_name`,product_price FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_ru_ru` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = 51 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="1844" AND p.`virtuemart_product_id`!="1854" AND product_price >= "46103.000000" ORDER BY `product_price` ASC, `virtuemart_product_id` ASC LIMIT 1