0

SQL=SELECT DISTINCT a.virtuemart_category_id AS id, a.category_description AS description, m.file_url AS categoryimg, a.category_name AS name, f.category_parent_id AS parent, 'cat' AS typ, 0 AS productnum FROM #__virtuemart_categories_ru_ru AS a LEFT JOIN #__virtuemart_category_categories AS f ON a.virtuemart_category_id = f.category_child_id LEFT JOIN #__virtuemart_categories AS b ON a.virtuemart_category_id = b.virtuemart_category_id LEFT JOIN #__virtuemart_category_medias AS cm ON a.virtuemart_category_id = cm.virtuemart_category_id LEFT JOIN #__virtuemart_medias AS m ON cm.virtuemart_media_id = m.virtuemart_media_id WHERE b.published='1' AND a.virtuemart_category_id = f.category_child_id ORDER BY b.ordering ASC

Go Back Home