Can't create/write to file '/tmp/#sql_418_0.MYI' (Errcode: 28 - No space left on device)

select * from lug_blogs,lug_cats_items where lug_cats_items.c = 2018 AND `primary` = 1 AND (t1<1513609190 OR t1=0) AND (t2>1513609190 OR t2=0) AND status = 'enabled' AND en_cats = '1' AND lug_cats_items.what = 'b' AND lug_blogs.n = lug_cats_items.n order by created desc limit 0,25