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  , null  from  rss_item  i  inner join  rss_channels  c on (c.id = i.cid)  inner join  rss_folders  f on (f.id = c.parent)  where  not(i.unread & 8) and  not(i.unread & 4) and  1 = 1  and month(ifnull(i.pubdate,i.added))= 7  and year(ifnull(i.pubdate, i.added))= 2010  and dayofmonth(ifnull(i.pubdate,i.added))= 2  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 '/tmp2/#sql_10f5_0.MYI' (Errcode: 13)