Select mb.hudsovet_id,mb.hudsovet_title ,mb.description,mb.member_id,mb.tag,date_format(mb.added_date,'%d.%m.%y %H:%i') AS HudDate, mb.totComment AS blogCmdCnt FROM `member_hudsovet` mb, all_comment mbr WHERE mb.hudsovet_id = mbr.blog_id AND mbr.cat_name='huds' AND date_format(mbr.comment_date, '%Y-%m-%d') BETWEEN '2024-12-15' AND '2024-12-21' GROUP BY mb.hudsovet_id ORDER BY blogCmdCnt DESC 1021 Disk full (/tmp/#sql_b292_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")