SELECT b.*, SUM(cc.employees) as employees, SUM(cc.salary)/SUM(cc.employees2) as average_salary, SUM(cc.hourly_rate)/SUM(cc.employees3) as average_hourly_rate, SUM(cc.ops_term_amount)/SUM(cc.employees3) as average_term_amount FROM budget_entities AS b  LEFT JOIN cache AS cc ON b.id = cc.budget_entity  WHERE 1  AND b.`url` = 'new-employees.html' GROUP BY b.id LIMIT 1;
Unknown column 'cc.budget_entity' in 'on clause'