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