SELECT b.blg_id,b.mem_id,b.title,b.description,b.posted,c.posted, MAX(c.posted) as last_com FROM blogs_comments as c JOIN blogs as b ON c.blg_id=b.blg_id
				  WHERE b.audience='0' 
				  AND b.featured='1'
				  GROUP BY c.blg_id
				  ORDER BY last_com DESC 
				  LIMIT 0,5:Disk full (/var/tmp/#sql_fb55_0); waiting for someone to free some space...