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))