Can't create/write to file '/tmp/mysqltmp/#sql_4d2_0.MYI' (Errcode: 2)

select * from lug_videos,lug_cats_items where lug_cats_items.c = 321 AND `primary` = 1 AND (t1<1412113980 OR t1=0) AND (t2>1412113980 OR t2=0) AND status = 'enabled' AND en_cats = '1' AND lug_cats_items.what = 'v' AND lug_videos.n = lug_cats_items.n order by created desc limit 0,16