What is the implementation principle of the weekly change table?

what is the implementation of the weekly change table?

how did bilibili"s new schedule be realized?

how is the data obtained?

Apr.14,2022
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eab550-47e0d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eab550-47e0d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?