SELECT * 
 FROM c_photo 

 INNER JOIN c_member  ON c_member.m_id=c_photo.f_member  
 INNER JOIN c_contest  ON c_contest.c_id=c_photo.f_contest   
 WHERE ( f_isactive = 1 )  
 
 
 ORDER BY f_date DESC, f_id DESC  
 LIMIT 948, 12 [nativecode=3 ** Error writing file '/tmp/MYakAsnG' (Errcode: 28 - No space left on device)]