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, (SELECT COUNT(*) FROM #__virtuemart_product_categories AS ax LEFT JOIN #__virtuemart_products AS bp ON ax.virtuemart_product_id = bp.virtuemart_product_id WHERE ax.virtuemart_category_id = a.virtuemart_category_id AND bp.published='1' ) AS productnum FROM #__virtuemart_categories_en_gb 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
You may not be able to visit this page because of:
- 1an out-of-date bookmark/favourite
- 2a search engine that has an out-of-date listing for this site
- 3a mistyped address
- 4you have no access to this page
- 5The requested resource was not found.
- 6An error has occurred while processing your request.
Please try one of the following pages: Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below..
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, (SELECT COUNT(*) FROM #__virtuemart_product_categories AS ax LEFT JOIN #__virtuemart_products AS bp ON ax.virtuemart_product_id = bp.virtuemart_product_id WHERE ax.virtuemart_category_id = a.virtuemart_category_id AND bp.published='1' ) AS productnum FROM #__virtuemart_categories_en_gb 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