FROM "missions" LEFT JOIN submissions ON submissions.mission_id = missions.id
INNER JOIN members ON members.id = submissions.member_id
Quick look here but having submissions as part of the inner join with members defeats the attempt at left joining it with missions. You might need to add parentheses to put the joins in the correct order, or something. Why it gives zero results we cannot say without a self-contained example.