gistfile1.txt

                    SELECT
                        PROJECTS.PROJECT_ID,
                        PROJECTS.NAME,
                        PROJECTS.COLOR_CODE,
                        PROJECTS.CHANGE_TOKEN,
                        PROJECTS.DELETED
                    FROM PROJECTS, TIMERS
                    WHERE
                        PROJECTS.DELETED = '0' AND
                        TIMERS.DELETED = '0' AND
                        PROJECTS.PROJECT_ID = TIMERS.PROJECT_ID AND
                        TIMERS.START_TIME BETWEEN datetime('now', '-14 days') AND datetime('now', '1 second')
                    GROUP BY PROJECTS.PROJECT_ID
                    ORDER BY PROJECTS.NAME