Select * from news where photo!="" and hide=0 and type="news" and flag_main=4 and id!=530698 and timenews<1719397014 and timepublic<1719397014 order by rand() limit 3

---

Disk full (/tmp/#sql_2fd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Select tmp.* from ( (Select * from news where photo!="" and hide=0 and type="news" and flag_ya_hide=0 and id!=530698 and timenews>=1719310614 and timenews<1719397014 and timepublic<1719397014 order by show_count desc, id desc limit 6) UNION (Select * from news where photo!="" and hide=0 and type="analytics" and flag_ya_hide=0 and timenews>=1719310614 and timenews<1719397014 and timepublic<1719397014 and flag_reclame=0 and flag_zakaz=0 order by show_count desc, id desc limit 1) UNION (Select * from news where photo!="" and hide=0 and type="read" and flag_ya_hide=0 and timenews>=1719310614 and timenews<1719397014 and timepublic<1719397014 and flag_reclame=0 and flag_zakaz=0 order by show_count desc, id desc limit 1) ) as tmp where 1 order by rand() limit 3

---

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