SELECT * FROM (SELECT * FROM `room` where active=1 and virtual=0 and showflat=0 and (enddate='0000-00-00' or enddate>'2026-05-20') and (startdate='0000-00-00' or startdate<='2026-05-20') ORDER BY `id` DESC LIMIT 20) as x order by rand() limit 2
Disk full (/var/tmp/#sql_77a8_2); waiting for someone to free some space...