Помочь дописать запрос на выборку с БД для экспорта - Общие вопросы и ошибки

$query = "SELECT
                    prod.product_ean,
                    prod.`".$lang->get('meta_keyword')."` as meta_keyword,
                    prod.`".$lang->get('short_description')."` as short_description,
                    prod.product_price,
                    prod.product_quantity,
                    prod.product_manufacturer_id,
                    prod.product_thumb_image,
/*сюда вставить*/
                  FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id)
                  LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id
                  GROUP BY prod.product_id"

$query = "SELECT
                    prod.product_ean,
                    prod.`".$lang->get('meta_keyword')."` as meta_keyword,
                    prod.`".$lang->get('short_description')."` as short_description,
                    prod.product_price,
                    prod.product_quantity,
                    prod.product_manufacturer_id,
                    prod.product_thumb_image,
                    currency.currency_value,
                    GROUP_CONCAT(images.image_name)
                  FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id)
                  LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id
                  LEFT JOIN `l_jshopping_currencies` AS currency USING(currency_id)
                  LEFT JOIN `l_jshopping_products_images` as images USING (product_id)
                  GROUP BY prod.product_id"

		$query = "SELECT
                    prod.product_ean,
                    prod.product_price,
                    currency.currency_value,
                    GROUP_CONCAT(images.image_name)
                  FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id)
                  LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id
                  LEFT JOIN `#__jshopping_currencies` AS currency USING(currency_id)
                  LEFT JOIN `#__jshopping_products_images` as images USING (product_id)
                  GROUP BY prod.product_id";			

        $db->setQuery($query);
        $products = $db->loadObjectList();

        $data = array();
        $head = array("Код_товара","Цена","Категория");
        $data[] = $head;

        foreach($products as $prod){
            $row = array();
            $row[] = $prod->product_ean;
			$row[] = number_format($prod->product_price/$prod->currency_value, 0, '', '');
			$row[] = $prod->categ; /*Наверное здесь неправильно обращаюсь к id категории*/
            $data[] = $row;
        }