$query = "SELECT #__virtuemart_categories_en_gb.category_name,#__virtuemart_products.virtuemart_product_id,#__virtuemart_products_en_gb.product_name,#__virtuemart_products.product_sku, #__virtuemart_products.published AS product_publish";
$query.= " FROM #__virtuemart_products, #__virtuemart_product_categories, #__virtuemart_categories, #__virtuemart_categories_en_gb, #__virtuemart_products_en_gb WHERE ";
$query .= " #__virtuemart_categories.virtuemart_category_id=#__virtuemart_product_categories.virtuemart_category_id ";
$query .= "AND #__virtuemart_products.virtuemart_product_id=#__virtuemart_product_categories.virtuemart_product_id ";
$query .= "AND #__virtuemart_products.product_parent_id=0 ";