Untitled

sqlString = "SELECT t.id as id, t.parent, t.children, t.title, t.tag, " +
                "t.folder, t.context, t.goal, t.added, t.modified as modified, " +
                "t.duedate, t.startdate, " +
                "t.duetime, t.starttime, t.reminder, t.repeat, t.completed, " +
                "t.rep_advanced, t.status, " +
                "t.star, t.priority, t.length, t.timer, t.note, t.value, " +
                "f.id as folderId, f.label as folderLabel, f.value " +
                "as folderValue, f.privy as folderPrivy, " +
                "CASE WHEN t.folder=0 THEN '0' ELSE f.sortorder END as sortorder, " +
                "f.archived as folderArchived, f.modified " +
                "as folderModified";
        sqlString += " FROM tasks t";
        sqlString += " LEFT OUTER JOIN folders f ON t.folder=f.value";