SELECT mb.blog_id, mb.blog_title, mb.description,mb.tag,mb.category_id,mb.blog_image,mb.blog_video,mb.member_id, date_format( mb.blog_date, '%d.%m.%y %H:%i' ) AS blogDate, mb.totComment AS blogRatCnt FROM `member_blog` mb, all_comment mbr WHERE mb.blog_id = mbr.blog_id AND mb.blog_mem_type = '3' AND mbr.cat_name='blog' GROUP BY mb.blog_id ORDER BY blogRatCnt DESC 1021 Disk full (/tmp/#sql_b292_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")