EetstarZ

SELECT * FROM members WHERE roomno IN ("102","103","104","105","106","107","108","109") ORDER BY roomno
SELECT * FROM updates ORDER BY id DESC LIMIT 1
SELECT * FROM shoppinglist
SELECT * FROM changelog WHERE DATEDIFF(NOW(), date) < 7 ORDER BY date DESC
SELECT * FROM members WHERE roomno = "102"
SELECT DATEDIFF(NOW(), MAX(date)) daysago FROM cookpart WHERE `102` != 0 && date <= NOW()