SELECT workbooks.WID,
workbooks.BreakdownService,
workbooks.JobSheetNo,
workbooks.Customer,
CONCAT_WS(',',Address1,Town,PostCode) as Address,
workbooks.appointmentdate,
Count(JID) as JobCount 
FROM workbooks
LEFT JOIN jobs on workbooks.wid=jobs.wid
WHERE ifnull(workbooks.finished,0)=0 
and workbooks.techid=:pTechID
GROUP BY workbooks.WID,
workbooks.BreakdownService,
workbooks.JobSheetNo,
workbooks.Customer,
CONCAT_WS(',',Address1,Town,PostCode)
ORDER BY workbooks.appointmentdate