SELECT mb.blog_id, mb.blog_title, mb.description,mb.tag,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 mbr.cat_name='blog' AND mb.blog_mem_type = '1' AND date_format(mbr.comment_date, '%Y-%m-%d') BETWEEN '2024-12-24' AND '2024-12-30' 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")