SELECT projects__list.*, imgs.filename as filename from projects__list JOIN ( SELECT * FROM projects__images WHERE id IN ( SELECT id FROM projects__images GROUP BY nid order by sort desc ) ) AS imgs ON projects__list.id = imgs.nid where 1=1 and type3<>17 order by rand() limit 6
Error writing file '/tmp/MYfd=543' (OS errno 28 - No space left on device)