SELECT * FROM re_1 WHERE L_HotSheetDate  > DATE_SUB(NOW(), INTERVAL 1 WEEK) <BR><BR>