SELECT field1, field2, ect...
FROM (SELECT *
    FROM `Job1111`.SubmissionStatus ss
    WHERE ss.fk_ActivityStatus IN (5,12)
    AND ss.ActivityType IN (60,61,62,63,64,65,66,67,68,69,96)) ss

LEFT JOIN `Job1111`.SteelTrackerDetails std
  ON std.BidID = ss.fk_BidIDAssigned

LEFT JOIN `Job1111`.SteelShake stls
  ON ss.ActivityType = 61 AND ss.ActivityRowId = stls.ID

LEFT JOIN `Job1111`.SteelErect stle
  ON ss.ActivityType = 62 AND ss.ActivityRowId = stle.ID

LEFT JOIN `Job1111`.SteelBoltOut stlb
  ON ss.ActivityType = 63 AND ss.ActivityRowId = stlb.ID

LEFT JOIN `Job1111`.SteelImp stli
  ON ss.ActivityType = 64 AND ss.ActivityRowId = stli.ID

LEFT JOIN `Job1111`.SteelWeld stlw
  ON ss.ActivityType = 68 AND ss.ActivityRowId = stlw.ID

LEFT JOIN `Job1111`.SteelSell stlsell
  ON ss.ActivityType = 65 AND ss.ActivityRowId = stlsell.ID

LEFT JOIN `Job1111`.SteelDemo stld
  ON ss.ActivityType = 67 AND ss.ActivityRowId = stld.ID

LEFT JOIN `Job1111`.SteelMisc stlm
  ON ss.ActivityType = 96 AND ss.ActivityRowId = stlm.ID

GROUP BY std.BidID

SELECT field1, field2, ect...
FROM `Job1111`.SubmissionStatus ss

LEFT JOIN `Job1111`.SteelTrackerDetails std
  ON std.BidID = ss.fk_BidIDAssigned

LEFT JOIN `Job1111`.SteelShake stls
  ON ss.ActivityType = 61 AND ss.ActivityRowId = stls.ID

LEFT JOIN `Job1111`.SteelErect stle
  ON ss.ActivityType = 62 AND ss.ActivityRowId = stle.ID

LEFT JOIN `Job1111`.SteelBoltOut stlb
  ON ss.ActivityType = 63 AND ss.ActivityRowId = stlb.ID

LEFT JOIN `Job1111`.SteelImp stli
  ON ss.ActivityType = 64 AND ss.ActivityRowId = stli.ID

LEFT JOIN `Job1111`.SteelWeld stlw
  ON ss.ActivityType = 68 AND ss.ActivityRowId = stlw.ID

LEFT JOIN `Job1111`.SteelSell stlsell
  ON ss.ActivityType = 65 AND ss.ActivityRowId = stlsell.ID

LEFT JOIN `Job1111`.SteelDemo stld
  ON ss.ActivityType = 67 AND ss.ActivityRowId = stld.ID

LEFT JOIN `Job1111`.SteelMisc stlm
  ON ss.ActivityType = 96 AND ss.ActivityRowId = stlm.ID

WHERE ss.fk_ActivityStatus IN (5,12)
AND ss.ActivityType IN (60,61,62,63,64,65,66,67,68,69,96)
GROUP BY std.BidID