Original dotProject query:
--------------------------
mysql> SELECT t.*, CONCAT_WS(' ',contact_first_name,contact_last_name) AS creator FROM task_log t, tasks LEFT JOIN users AS u ON user_id = task_log_creator LEFT JOIN contacts ON user_contact = contact_id LEFT JOIN projects ON project_id = task_project WHERE task_log_task = task_id AND task_project = 1 AND task_log_date >= '2006-08-07 00:00:00';
ERROR 1054 (42S22): Unknown column 'task_log_creator' in 'on clause'
Switched table names in FROM:
-----------------------------
mysql> SELECT t.*, CONCAT_WS(' ',contact_first_name,contact_last_name) AS creator FROM tasks, task_log t LEFT JOIN users AS u ON user_id = task_log_creator LEFT JOIN contacts ON user_contact = contact_id LEFT JOIN projects ON project_id = task_project WHERE task_log_task = task_id AND task_project = 1 AND task_log_date >= '2006-08-07 00:00:00';
ERROR 1054 (42S22): Unknown column 'task_project' in 'on clause'
Using:
------
mysql Ver 14.12 Distrib 5.0.18, for redhat-linux-gnu (i386) using readline 5.0