MYSQL ERROR: Disk full (/tmp/#sql_1aa961_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Query: SELECT *, CONCAT(date_date, ' ', date_time) AS datetime,date_format(date_date, '%M %e, %Y ') AS date_show_date , time_format(date_time, '%h:%i %p') AS date_time_show,date_format(last_modified, '%M %e, %Y %h:%i %p') AS last_modified , date_format(date_expire, '%M %e, %Y ') AS date_expire_show FROM ms_calendar LEFT JOIN ms_blog_cats_connect ON ms_calendar.date_id=ms_blog_cats_connect.con_prod LEFT JOIN ms_blog_categories ON ms_calendar.date_cat=ms_blog_categories.cat_id WHERE date_public='1' AND date_type='news' AND (ms_calendar.date_cat='100' OR ms_blog_cats_connect.con_cat='100' ) AND page_under='0' AND CONCAT(date_date, ' ', date_time)<='2021-01-22 10:08:47' AND private<='1' AND (date_expire='0000-00-00' OR date_expire>='2021-01-22' ) AND date_id!='0' GROUP BY date_id ORDER BY page_order ASC