WordPress database error: [Disk full (/tmp/#sql-temptable-a96c-190f3f-6ef5.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)
JOIN wpys_my_calendar_category_relationships AS r ON r.event_id = e.event_id
WHERE event_flagged <> 1 AND event_approved = 1 AND r.category_id IN (1)
AND ( DATE(occur_begin) BETWEEN '2025-03-15 00:00:00' AND '2025-03-15 23:59:59'
OR DATE(occur_end) BETWEEN '2025-03-15 00:00:00' AND '2025-03-15 23:59:59'
OR ( DATE('2025-03-15') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2025-03-15') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
GROUP BY o.occur_id ORDER BY occur_begin, event_title ASC
WordPress database error: [Disk full (/tmp/#sql-temptable-a96c-190f3f-6ef6.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)
JOIN wpys_my_calendar_category_relationships AS r ON r.event_id = e.event_id
WHERE event_flagged <> 1 AND event_approved = 1 AND r.category_id IN (1)
AND ( DATE(occur_begin) BETWEEN '2025-03-15 00:00:00' AND '2025-03-15 23:59:59'
OR DATE(occur_end) BETWEEN '2025-03-15 00:00:00' AND '2025-03-15 23:59:59'
OR ( DATE('2025-03-15') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2025-03-15') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
GROUP BY o.occur_id ORDER BY occur_begin, event_title ASC
