SELECT Proj.*,tbl_employee.emp_name, tbl_employee.emp_photo, tbl_client.client_name FROM tbl_employee, tbl_client ,tbl_project_card_trello, tbl_project_task_history Pth LEFT JOIN tbl_project Proj ON (Pth.pth_projid=Proj.proj_id) LEFT JOIN tbl_project_task_history PthD ON (Pth.pth_projid = PthD.pth_projid AND Pth.pth_id < PthD.pth_id) WHERE Pth.pth_projid=Proj.proj_id AND PthD.pth_id IS NULL and tbl_employee.emp_id = Proj.proj_head_empid and tbl_client.client_id=Proj.client_id and Proj.proj_id = pct_proj_id and (Proj.proj_status=2 or pct_tstatus = '') and pct_dep_id = '' and FIND_IN_SET(, Proj.proj_team) order by Proj.proj_id desc