My Calendar

WordPress database error: [Disk full (/tmp/#sql-temptable-a96c-18ed94-54a3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT *, UNIX_TIMESTAMP( CONVERT_TZ( `occur_begin`, '+00:00', '+05:30' ) ) AS ts_occur_begin, UNIX_TIMESTAMP( CONVERT_TZ( `occur_end`, '+00:00', '+05:30' ) ) AS ts_occur_end FROM wpys_my_calendar_events AS o JOIN wpys_my_calendar AS e ON (event_id=occur_event_id) JOIN wpys_my_calendar_categories AS c ON (event_category=category_id) WHERE event_flagged <> 1 AND event_approved = 1 AND ( DATE(occur_begin) BETWEEN '2025-06-30 00:00:00' AND '2025-08-03 23:59:59' OR DATE(occur_end) BETWEEN '2025-06-30 00:00:00' AND '2025-08-03 23:59:59' OR ( DATE('2025-06-30') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) OR ( DATE('2025-08-03') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) ) GROUP BY o.occur_id ORDER BY occur_begin, event_title ASC