Select * from notification where hide=0 and timestart<=1766198971 and timestop>=1766198971 and exists(Select 1 from notification_page where idt=notification.id and name="ideas" limit 1) order by rand() limit 1

---

Disk full (/tmp/#sql_76e4_17.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")