Select *, (Select fname from news_photo where news_photo.idt=news.id order by tomain desc, id asc limit 1) as fname from news order by date desc limit 2560,40

---

Got error 24 "Too many open files" from storage engine MyISAM