SELECT markers.id, markers.ts, markers.addresstre, markers.addresscinque, markers.addresssei, markers.azienda, comments.idcomment, comments.comment, users.azienda FROM markers LEFT JOIN comments ON markers.id = comments.idcomment JOIN users ON markers.azienda = users.azienda WHERE users.azienda='aziendauno'
così?