select *
from (
SELECT
	res.id,
	res.title,
	sum(case when res.report_week = 1 then res.total_minutes else 0 end) week_1,
	sum(case when res.report_week = 2 then res.total_minutes else 0 end) week_2,
	sum(case when res.report_week = 3 then res.total_minutes else 0 end) week_3,
	sum(case when res.report_week = 4 then res.total_minutes else 0 end) week_4,
	sum(case when res.report_week = 5 then res.total_minutes else 0 end) week_5,
	sum(case when res.report_week = 6 then res.total_minutes else 0 end) week_6,
	sum(total_minutes) as total
FROM
	(
	SELECT
		WEEK(report.report_date,6) as report_week,
		sum(total_minutes) as total_minutes,
		dg.title,
		dg.id
	FROM report_2015_1 as report
		INNER JOIN data_gateway as dg on dg.id = report.gateway_id
	WHERE report_date >= CURDATE() - INTERVAL 5 WEEK
		and dg.title IS NOT NULL
		and dg.is_deleted = false
	GROUP BY dg.id, report_week
	) as res
GROUP BY res.id
) report_top
order by week_5 desc, week_6 desc
limit 3;