path: root/todo/sqlite

restructure queries to avoid the use of right and full outer joins so we support sqlite again.  see http://www.sqlite.org/omitted.html for what else to avoid in queries