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

---

Disk full (/tmp/#sql_32e_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!=552865 and timenews>=1750075124 and timenews<1750161524 and timepublic<1750161524 order by show_count desc, id desc limit 4) UNION (Select * from news where photo!="" and hide=0 and type="analytics" and flag_ya_hide=0 and timenews>=1750075124 and timenews<1750161524 and timepublic<1750161524 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>=1750075124 and timenews<1750161524 and timepublic<1750161524 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 2

---

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