I am attempting to create a report that will list all closed tickets totaling the "total time taken" from worklog activities only.  By using the query below, tickets with multiple work log entries are listed multiple times (one for each worklog entry)

SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", wof.UDF_CHAR2 AS "Client", ct.TIMESPENT AS "Time Spent" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE (wo.ISPARENT='1')