WordPress database error: [Can't create/write to file '/var/tmp/#sql_4c1_0.MAI' (Errcode: 28)]
SELECT lbc_posts.*, CAST( lbc_tec_occurrences.start_date AS DATETIME ) AS event_date FROM lbc_posts LEFT JOIN lbc_postmeta ON ( lbc_posts.ID = lbc_postmeta.post_id AND lbc_postmeta.meta_key = '_EventHideFromUpcoming' ) JOIN lbc_tec_occurrences ON lbc_posts.ID = lbc_tec_occurrences.post_id WHERE 1=1 AND ( lbc_postmeta.post_id IS NULL AND CAST(lbc_tec_occurrences.end_date AS DATETIME) <= '2024-12-01 00:00:00' AND CAST(lbc_tec_occurrences.start_date AS DATETIME) >= '2024-10-28 00:00:00' ) AND lbc_posts.post_type = 'tribe_events' AND ((lbc_posts.post_status = 'publish')) GROUP BY lbc_tec_occurrences.occurrence_id ORDER BY lbc_tec_occurrences.start_date ASC, lbc_posts.post_date ASC