alpha version of dashboard, fixed sql syntax errors