SELECT * FROM
( SELECT 
  SUM(pr.sched_hrs) AS SchedHrs,
  pr.AgentId,
  SUM(pr.payroll_time) AS PRTime,
  LEFT(CONCAT(pr.payroll_time / pr.sched_hrs * 100), 5) AS TPS_Hours
FROM
  payroll pr
WHERE
  DATE_FORMAT(pr.SumDate, '%Y-%m-%d') BETWEEN '2008-01-28' AND '2008-01-30'
GROUP BY
  pr.AgentId,
  LEFT(CONCAT(pr.payroll_time / pr.sched_hrs * 100), 5)
) AS pr
  
JOIN  
  
(SELECT 
        qa.d_date,
        qa.d_empid,
    LEFT (CONCAT(Avg (qa.d_score)), 2) AS TPS_QA
FROM
  dish_qa qa
WHERE 
DATE_FORMAT(qa.d_date, '%Y-%m-%d') = '2008-01-28'
GROUP BY
        qa.d_empid) AS qa
ON qa.d_empid = pr.AgentId
        
JOIN
(SELECT 
  FORMAT((((sum(talk_sec)) + (sum(pause_sec)) + (sum(wait_sec)) + (sum(dispo_sec))) / 3660), 2) AS TalkTime,
  vdl.`user`
FROM
  vicidial_agent_log vdl
WHERE
  DATE_FORMAT(event_time, '%Y-%m-%d') = '2008-01-30' AND
  pause_sec < 48800 AND 
  wait_sec < 48800 AND 
  talk_sec < 48800 AND 
  dispo_sec < 48800
GROUP BY
  vdl.`user`
) AS vdl
ON vdl.user = pr.AgentId
  
  
JOIN  
(
SELECT 
  UPGRADES.seller,
  COUNT(UPGRADES.seller) AS Sales,
  UPGRADES.`timestamp`
FROM
  UPGRADES 
WHERE
DATE_FORMAT(UPGRADES.`timestamp`, '%Y-%m-%d') = '2008-01-30'
GROUP BY 
UPGRADES.seller) AS sellers
ON sellers.seller = pr.AgentId