SELECT job_id,fk_vehicle_id,e.company, e.client_id,jobstatus,DATE_FORMAT(jobdate,'%d/%m/%Y') As dispjobdate,CONCAT_WS(' ',b.first_name,b.last_name) AS engineer,jobtypes.jobtype,fk_jobstatus_id FROM `jobs` LEFT JOIN vehicles AS d ON d.vehicle_id = jobs.fk_vehicle_id LEFT JOIN clients AS e ON e.client_id = d.fk_client_id LEFT JOIN jobstatuses ON jobs.fk_jobstatus_id = jobstatuses.jobstatus_id LEFT JOIN staff AS b ON b.staff_id = jobs.fk_engineer_id LEFT JOIN staff AS c ON c.staff_id = jobs.fk_engineer_id2 WHERE job_id>0 AND e.client_id =? LIMIT 1000 Array ( [0] => )