Select * from news where photo!="" and hide=0 and type="news" and flag_main=4 and id!=530698 and timenews<1719397174 and timepublic<1719397174 order by rand() limit 3
Disk full (/tmp/#sql_2fd_3.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>=1719310774 and timenews<1719397174 and timepublic<1719397174 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>=1719310774 and timenews<1719397174 and timepublic<1719397174 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>=1719310774 and timenews<1719397174 and timepublic<1719397174 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_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")