SQL:
SELECT
  CONCAT_WS('-',s.CatKey,d.CatKey,t.CatKey) AS CatNum,
  t.*,
  s.*
FROM `cat_titles` AS t
LEFT JOIN cat_items AS i ON i.ID_Title=t.ID
LEFT JOIN cat_depts AS d ON t.ID_Dept=d.ID
LEFT JOIN cat_supp AS s ON t.ID_Supp=s.ID
LEFT JOIN (

SELECT 
    si.ID_Item, SUM(Qty) AS QtyTotal
FROM
    stk_items AS si
        LEFT JOIN
    stk_bins AS sb ON si.ID_Bin = sb.ID
WHERE
    (si.WhenRemoved IS NULL)
        AND (sb.isForSale)
        AND (sb.isEnabled)
        AND (sb.WhenVoided IS NULL)
        
GROUP BY si.ID_Item

) AS s ON s.ID_Item=i.ID
LEFT JOIN cat_title_x_topic AS tt ON tt.ID_Title=t.ID
WHERE tt.ID_Topic=1214 ORDER BY CatNum