SELECT UNIX_TIMESTAMP(l.TimeDate) time , AVG(l.intemp) , AVG(n.intemp) , DATE_FORMAT(l.TimeDate, '%Y-%m-%d-%H') dates FROM values.temps l LEFT JOIN values.net n ON DATE_FORMAT(l.TimeDate, '%Y-%m-%d-%H') = DATE_FORMAT(n.TimeDate, '%Y-%m-%d-%H') WHERE YEARWEEK('2017-01-17 00:00:00',1) = YEARWEEK(l.TimeDate,1) GROUP BY dates ORDER BY dates ASC