SELECT * FROM TH_RECEIVE_ACTIVITIES WHERE UID=1 AND GIFTBAG=4 AND
DATE > CURDATE() AND DATE < ADDTIME(CONVERT(CURDATE(),DATETIME),'24:00:00')
SELECT ID FROM TH_ROOM WHERE TYPE = 'ME' AND PLAYER_NUM < 9 AND IS_PLAYING = 0 AND M_LEVEL = 1 ORDER BY PLAYER_NUM desc LIMIT 1