sf.sql

SELECT
   CNTC.ContactID,
   CF.FocusInstanceID,
   group_concat(DISTINCT Country.name SEPARATOR ', ') AS country,
   group_concat(DISTINCT EquityInstrument.name SEPARATOR ', ') AS equityInstrument,
FROM
   ContactFocus AS CF 
   JOIN
      Contact AS CNTC 
      ON CF.ContactID = CNTC.ContactID 
   LEFT JOIN
      ContactFocusCountry 
      ON CF.ContactID = ContactFocusCountry.ContactID 
   LEFT JOIN
      Country 
      ON Country.CountryID = ContactFocusCountry.CountryID 
   LEFT JOIN
      ContactFocusEquityInstrument 
      ON CF.ContactID = ContactFocusEquityInstrument.ContactID 
   LEFT JOIN
      EquityInstrument 
      ON EquityInstrument.EquityInstrumentID = ContactFocusEquityInstrument.EquityInstrumentID 
WHERE
   CNTC.ContactID = 433504 
GROUP BY
   CF.FocusInstanceID;