The Error returned was:
Disk full (/tmp/#sql_b37_2.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)
SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.short_story) as short_story, p.xfields, p.title, p.category, p.alt_name FROM joy_post p LEFT JOIN joy_post_extras e ON (p.id=e.news_id) WHERE p.date >= ‘2023-06-30 10:35:34’ – INTERVAL 7 DAY AND p.date < '2023-06-30 10:35:34' AND approve=1 ORDER BY news_read DESC LIMIT 0,1
المصدر أمن – IQ News