Minor changes to parsers. Use JOIN instead of LEFT JOIN.