SELECT DISTINCT seo.keyword, prev.google AS googlePrev, prev.yahoo AS yahooPrev, prev.bing AS bingPrev, seo.google AS googleCur, seo.yahoo AS yahooCur, seo.bing AS bingCur
 FROM seo_rankingreports AS seo
 inner JOIN seo_rankingreports AS prev
 ON seo.keyword = prev.keyword AND prev.client_id = seo.client_id AND prev.campaign = seo.campaign
 WHERE seo.client_id = '284' AND seo.campaign = 'Focus' AND seo.domain = 'www.domain.com' AND prev.report_date = '2012-02-01' AND seo.report_date = '2012-03-01'