#mySQL 5.0.5
multi-table
select
a.macd_id as midy1,a.macd_date as mdatey1,a.macd_r5 as r5y1,a.macd_r9 as r9y1,a.macd_r14 as r14y1,a.macd_ks9 as mks9y1,a.macd_ds9 as mds9y1,a.macd_dif1226 as mdif1226y1,a.macd_macd9 as macd9y1,
b.macd_id as midy2,b.macd_date as mdatey2,b.macd_r5 as r5y2,b.macd_r9 as r9y2,b.macd_r14 as r14y2,b.macd_ks9 as mks9y2,b.macd_ds9 as mds9y2,b.macd_dif1226 as mdif1226y2,b.macd_macd9 as macd9y2,
c.macd_id as midy3,c.macd_date as mdatey3,c.macd_r5 as r5y3,c.macd_r9 as r9y3,c.macd_r14 as r14y3,c.macd_ks9 as mks9y3,c.macd_ds9 as mds9y3,c.macd_dif1226 as mdif1226y3,c.macd_macd9 as macd9y3,
d.macd_id as midy4,d.macd_date as mdatey4,d.macd_r5 as r5y4,d.macd_r9 as r9y4,d.macd_r14 as r14y4,d.macd_ks9 as mks9y4,d.macd_ds9 as mds9y4,d.macd_dif1226 as mdif1226y4,d.macd_macd9 as macd9y4
from macd a join macd b, macd c join macd d
where a.macd_id=b.macd_id
and a.macd_id=c.macd_id
and a.macd_id=d.macd_id
and a.macd_date='2012-02-24'
and b.macd_date='2012-02-23'
and c.macd_date='2012-02-22'
and d.macd_date='2012-02-21'
and a.macd_dif1226<>''
and b.macd_dif1226<>''
and c.macd_dif1226<>''
and d.macd_dif1226<>''
and a.macd_r14<-70
limit 60
