Error in Query :
SELECT a.*,b.shortname as locname FROM cl_listings a ,cl_locations b,cl_payment c,cl_users d where a.status='active' and a.featured!='no' and b.id=a.locid and c.id=a.payment_id and a.package_id=1 and c.status='paid' and imagepath !='' and a.poster_expir>=curdate() and d.id=a.userid and d.status='active'  and a.status='active' order by rand() limit 4

Description
Can't create/write to file '/tmp/#sql_61de_0.MYI' (Errcode: 122)