Mysql запрос к прошлому периоду в одной таблице

SELECT t1.title, t2.sum, t3.sum
FROM      (
           SELECT title
           FROM `table`
           WHERE `date` > DATE(NOW()) - INTERVAL 2 DAY
          ) t1
LEFT JOIN (
           SELECT title, sum
           FROM `table`
           WHERE `date` = DATE(NOW()) - INTERVAL 1 DAY
          ) t2 ON t1.title = t2.title
LEFT JOIN (
           SELECT title, sum
           FROM `table`
           WHERE `date` = DATE(NOW())
          ) t3 ON t1.title = t3.title