This is my current query:

PHP Code:
    $select '    SELECT 
                items.itemID, 
                itemTitle, 
                itemSKULadies, 
                itemSKUMen, 
                itemDescLadies, 
                itemDescMen,  
                itemPrice, 
                itemColours, 
                categories.category, 
                suppliers.supplier, 
                itemTypes.itemType, 
                sizesMen.size AS Msize, 
                sizesLadies.size AS Lsize, 
                sc.subcategories,
                ss.siteSections'
;
    
$from   '    FROM items 
                LEFT JOIN categories ON categories.catID=items.catID 
                LEFT JOIN suppliers ON suppliers.supplierID=items.supplierID 
                LEFT JOIN itemTypes ON itemTypes.itemTypeID=items.itemTypeID 
                LEFT JOIN sizesMen ON sizesMen.sizeMenID=items.sizeMenID 
                LEFT JOIN sizesLadies ON sizesLadies.sizeLadiesID=items.sizeLadiesID 
                LEFT JOIN
                (SELECT item_to_subcat.itemID,
                GROUP_CONCAT(subcategories.subcategory SEPARATOR ", ") AS subcategories
                FROM item_to_subcat
                INNER JOIN subcategories ON subcategories.subcatID = item_to_subcat.subcatID
                 GROUP BY item_to_subcat.itemID ) AS sc ON sc.itemID = items.itemID
                LEFT JOIN
                (SELECT item_to_siteSection.itemID, GROUP_CONCAT(siteSections.siteSection SEPARATOR ", ") AS siteSections
                 FROM item_to_siteSection
                 INNER JOIN siteSections ON siteSections.siteSectionID = item_to_siteSection.siteSectionID
                 GROUP BY item_to_subcat.itemID ) AS ss ON ss.itemID = items.itemID'

I can't see where I copied it incorrectly?