Форум пользователей MySQL

SELECT q2.date, q1.name, q1.record, q1.increment, q2.sum, (q1.increment - q2.sum) a
from
(
SELECT
sr.*,
sl.name
FROM source_record sr
LEFT JOIN source_list sl ON sr.id_source = sl.id
JOIN (SELECT MAX(id) max_id FROM source_record GROUP BY id_source) last_rec ON sr.id=last_rec.max_id
) q1
inner join
(
SELECT
cr.date,
sl.name,
sl.id,
sum(increment) sum
FROM consumer_record cr
LEFT JOIN source_list sl ON cr.id_source = sl.id
JOIN (SELECT MAX(id) max_id FROM consumer_record GROUP BY id_consumer) last_rec ON cr.id=last_rec.max_id
GROUP BY id_source HAVING COUNT( id_source ) >1 ORDER BY id_source
) q2 on q1.id_source=q2.id