WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql_4b6_0.MYI' (Errcode: 28)]
SELECT
`p`.*,
`e`.`post_id`,
`i`.`id` AS `instance_id`,
`i`.`start` AS `start`,
`i`.`end` AS `end`,
`e`.`timezone_name` AS `timezone_name`,
`e`.`allday` AS `event_allday`,
`e`.`recurrence_rules`,
`e`.`exception_rules`,
`e`.`recurrence_dates`,
`e`.`exception_dates`,
`e`.`venue`,
`e`.`country`,
`e`.`address`,
`e`.`city`,
`e`.`province`,
`e`.`postal_code`,
`e`.`instant_event`,
`e`.`show_map`,
`e`.`contact_name`,
`e`.`contact_phone`,
`e`.`contact_email`,
`e`.`contact_url`,
`e`.`cost`,
`e`.`ticket_url`,
`e`.`ical_feed_url`,
`e`.`ical_source_url`,
`e`.`ical_organizer`,
`e`.`ical_contact`,
`e`.`ical_uid`,
`e`.`longitude`,
`e`.`latitude`
FROM
wp_ai1ec_events e
INNER JOIN
wp_posts p
ON ( `p`.`ID` = `e`.`post_id` )
INNER JOIN
wp_ai1ec_event_instances i
ON ( `e`.`post_id` = `i`.`post_id` )
WHERE
post_type = 'ai1ec_event'
AND
i.end > 1630450800 AND i.start < 1633042800
AND post_status = 'publish'
GROUP BY
`i`.`id`
ORDER BY
`e` . `allday` DESC,
`i` . `start` ASC,
`p` . `post_title` ASC
