SELECT bl_post.id AS "bl_post.id", bl_post.tit AS "bl_post.tit", bl_post.text AS "bl_post.text", yosum85_foro.foro_users.username AS "yosum85_foro.foro_users.username", bl_post.fecha AS "bl_post.fecha", count(bl_resp.id) AS "EDW_POST_RESPUESTAS", bl_blogs.id AS "bl_blogs.id", bl_blogs.blog AS "bl_blogs.blog", bl_temas.id AS "bl_temas.id", bl_temas.tema AS "bl_temas.tema" FROM bl_post LEFT JOIN yosum85_foro.foro_users ON yosum85_foro.foro_users.user_id=bl_post.autor INNER JOIN bl_blogs ON bl_blogs.id=bl_post.blog LEFT JOIN bl_post_tema ON bl_post_tema.idpost=bl_post.id LEFT JOIN bl_temas ON bl_temas.id=bl_post_tema.idtema LEFT JOIN bl_resp ON bl_post.id=bl_resp.postid WHERE bl_post.id IN (1942,1939,1935,1932,1927,1914,1913) GROUP BY bl_temas.id, bl_post.id ORDER BY bl_post.fecha DESC no es una consulta correcta(Error writing file '/tmp/MYfd=1592' (OS errno 28 - No space left on device))