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

select * from lug_links,lug_cats_items where lug_cats_items.c = 392 AND `primary` = 1 AND (t1<1513609805 OR t1=0) AND (t2>1513609805 OR t2=0) AND status = 'enabled' AND en_cats = '1' AND lug_cats_items.what = 'l' AND lug_links.n = lug_cats_items.n order by pick desc,sponsored desc,dynamic_price desc,created desc limit 0,25