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