这条sql如何优化

[ecshop528]

explain select art.article_id,art.title ,art.link2 from article art , (select a.article_id from article_goods a , (select b.goods_id from article_goods b where b.article_id='133') c where a.goods_id=c.goods_id and a.article_id <> '133' group by article_id) tmp where art.article_id= tmp.article_id limit 4


1 PRIMARY <derived2> ALL 5
1 PRIMARY art eq_ref PRIMARY PRIMARY 3 tmp.article_id 1
2 DERIVED <derived3> ALL 3 Using temporary; Using filesort
2 DERIVED a range article_id,article_id_gid article_id_gid 3 114 Using where; Using index; Using join buffer
3 DERIVED b ref article_id,article_id_gid article_id_gid 3 5 Using index

[rucypli]

贴出来这几个表的建表语句