me la controllli perfavore perchè non mi va

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 ORDER BY markers.ts DESC JOIN users ON markers.azienda = users.azienda