Something

SELECT       hr.lname                              AS Last_Name,       hr.fname                              AS First_Name,       SUM(pr.payroll_time)                  AS SumOfpayroll_time,       hr.max_hours                          AS max_hours,       LEFT (CONCAT(pr.payroll_time /                    pr.max_hours * 100), 2)  AS TPS_Hours,       LEFT (CONCAT(AVG(qa.d_score)), 2)     AS TPS_QA,       SUM(   up.hbo            + up.starz            + up.showtime            + up.cinemax)                     AS CountOfCampaign  FROM           echostar.UPGRADES AS up      JOIN ecreek.dish_qa    AS qa       JOIN ecreek.agent_hr   AS hr      JOIN ecreek.payroll    AS pr ON (     pr.AgentId = hr.AgentID                                        AND pr.AgentId = qa.d_empid                                        AND pr.SumDate = qa.d_date                                        AND pr.AgentID = up.AgentID ) WHERE 1 = 1   AND DATE_FORMAT(pr.SumDate, '%Y-%m-%d')        BETWEEN '$date2' AND '$date1'   AND up.`timestamp`        BETWEEN '$date2' AND '$date1' GROUP BY hr.lname,         hr.fnameLIMIT 100;