select p2.* from smcontents_ctemplates p1, smcontents_cdatarel p2 where p1.key = 'news' and p2.templid=p1.id
Out of resources when opening file './c12ihist/smcontents_cdatarel.MYD' (Errcode: 24)