elect p.shipid,
p.shipname,
c.DESC ContactShipCOM,
a.DESC SpacialCoordiantes
FROM PROFILE p
LEFT JOIN contact c ON p.id = c.profileid
AND c.ord = 1
LEFT JOIN address a ON p.id = a.profileid
AND a.ord = 1
WHERE p.shipid = \'Rocinante\'
AND c.show=\'The Expanse\'