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