SELECT DISTINCT (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 FROM `member_blog` mb, blog_rating mbr WHERE mb.member_id = mbr.rat_member_id AND mbr.review_count ='1' AND mb.blog_mem_type = '1' AND date_format(mbr.rank_date, '%Y-%m-%d') BETWEEN '2024-12-15' AND '2024-12-21' ORDER BY mb.rating_count DESC 1021 Disk full (/tmp/#sql_b292_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")