SELECT c.*, 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 companies AS c  LEFT JOIN cache AS cc ON c.id = cc.company  WHERE 1  AND `` = '' GROUP BY  LIMIT 1;

SELECT * FROM employees   WHERE 1  AND first_name LIKE 'state%' AND last_name LIKE 'attorney%' AND `` = '' LIMIT ;

SELECT * FROM companies   WHERE 1  AND `` = '' LIMIT ;

SELECT * FROM companies   WHERE 1  AND `` = '' LIMIT ;

SELECT * FROM companies   WHERE 1  AND `` = '' LIMIT 1;