état des lieux de sortie: locataire plus joignable

SELECT u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, p.likes, g.g_id, g.g_user_title, o.user_id AS is_online FROM bb_posts AS p INNER JOIN bb_users AS u ON u.id=p.poster_id INNER JOIN bb_groups AS g ON g.g_id=u.group_id LEFT JOIN bb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.id IN (1867229,1867230,1867231,1867232,1867233,1867234,1867235,1867236,1867237,1867238,1867239,1867248,1867249,1867250,1867251,1867252,1867254,1867255,1867256,1867258,1867229) ORDER BY p.id ASC<==req Disk full (/var/tmp/#sql_7c0_0); waiting for someone to free some space...