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

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 prev
 left JOIN seo_rankingreports AS seo
 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.domain1.com' AND prev.report_date = '2012-02-01' AND seo.report_date = '2012-03-01';



SELECT DISTINCT seo.keyword, prev.google AS googlePrev, prev.yahoo AS yahooPrev, prev.bing AS bingPrev, cur.google AS googleCur, cur.yahoo AS yahooCur, cur.bing AS bingCur FROM seo_rankingreports AS seo left JOIN (SELECT keyword,google,yahoo,bing FROM seo_rankingreports WHERE client_id = '179' AND campaign = 'All Keywords' AND domain = 'www.domain2.com' AND report_date = '2011-01-01') AS prev ON seo.keyword = prev.keyword inner JOIN (SELECT keyword,google,yahoo,bing FROM seo_rankingreports WHERE client_id = '179' AND campaign = 'All Keywords' AND domain = 'www.domain2.com' AND report_date = '2011-02-01') AS cur ON seo.keyword = cur.keyword;

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 prev left JOIN seo_rankingreports AS seo ON seo.keyword = prev.keyword AND prev.client_id = seo.client_id AND prev.campaign = seo.campaign WHERE seo.client_id = '179' AND seo.campaign = 'All Keywords' AND seo.domain = 'www.domain2.com' AND prev.report_date = '2011-01-01' AND seo.report_date = '2011-02-01';

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 prev left JOIN seo_rankingreports AS seo ON seo.keyword = prev.keyword AND prev.client_id = seo.client_id AND prev.campaign = seo.campaign WHERE seo.client_id = '179' AND seo.campaign = 'All Keywords' AND seo.domain = 'www.domain2.com' AND prev.report_date = '2011-02-01' AND seo.report_date = '2011-03-01';