SELECT COUNT(mep_job.uid) AS jobs, SUM(TIMEDIFF(FROM_UNIXTIME(mep_job.end_date), FROM_UNIXTIME(mep_job.start_date))) AS hours, mep_job.cxl, mep_data.uid AS duid, (SUM(TIMEDIFF(FROM_UNIXTIME(mep_job.end_date), FROM_UNIXTIME(mep_job.start_date)))*mep_data.pay) AS cashflow FROM `mep_job` INNER JOIN `mep_data` ON mep_job.uid=mep_data.uid WHERE WEEK(FROM_UNIXTIME(mep_job.start_date),3)='".$x."' AND mep_job.cxl='0' AND mep_job.uid='".$_SESSION['user']['id']."' GROUP BY mep_job.uid