original query ...


SELECT 
	wfc.workflow_case_id, 
	wfc.workflow_id, 
	wf.name,
	i2.value as workflow_case_status, 
	wfc.workflow_case_status_item_id,
	wfc.workflow_case_item_id, 
	i.value as workflow_case, 
	wfc.aux_id as customer_id, 
	wfc.workflow_case_initator_user_id, 
	wfc.date_created, 
	wfc.last_changed 
FROM 
	fw_workflow_case wfc 
LEFT JOIN 	fw_workflow wf 	ON 	wfc.workflow_id = wf.workflow_id 
LEFT JOIN 	fw_item i	ON 	wfc.workflow_case_item_id = i.item_id 
LEFT JOIN 	fw_item i2 	ON 	wfc.workflow_case_status_item_id = i2.item_id 
LEFT JOIN 	fw_service s  	ON 	wfc.aux_id = s.customer_id  
LEFT JOIN 	fw_user u  	ON 	s.person_id = u.person_id   
WHERE 	
     u.login = 441235720316 
ORDER BY last_changed desc, date_created desc;









mysql> SELECT
    -> wfc.workflow_case_id,
    -> wfc.workflow_id,
    -> wf.name,
    -> wfc.workflow_case_status_item_id,
    -> wfc.workflow_case_item_id,
    -> i.value as workflow_case,
    -> wfc.aux_id as customer_id,
    -> wfc.workflow_case_initator_user_id,
    -> wfc.date_created,
    -> wfc.last_changed
    -> FROM
    -> fw_workflow_case wfc
    -> LEFT JOIN fw_workflow wf ON wfc.workflow_id = wf.workflow_id
    -> LEFT JOIN fw_item insert ON wfc.workflow_case_status_item_id = i.item_id
    -> LIMIT 5;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert ON wfc.workflow_case_status_item_id = i.item_id
LIMIT 5' at line 15