0
SQL=SELECT l.*
FROM `#__virtuemart_categories_ru_ru` as l
INNER JOIN `#__virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `#__virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 1348 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY c.ordering,category_name ASC
Go Back Home