Failed to execute the SQL query

select  i.title,  c.title, c.id, i.unread, i.url, i.enclosure, i.author, i.description, c.icon,  unix_timestamp(ifnull(i.pubdate,i.added)) as ts,  i.pubdate is not null as ispubdate, i.id, r.rating   from  news_item  i  left join  news_rating  r on (i.id = r.iid),  news_channels  c,  news_folders  f  where  i.cid = c.id and  f.id=c.parent and  not(c.mode & 8) and  not(i.unread & 8) and  not(i.unread & 4) and  i.author like 'By_NICHOLAS_BAKALAR'  and  1=1  order by  ts desc, f.position asc, c.position asc , ts desc, i.id asc limit  0, 100

Error 1: Can't create/write to file '/tmp/#sql_7be_0.MYI' (Errcode: 5)