SELECt id FROM tblWHERe date >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAYAND date < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY

SELECt id FROM tblWHERe date >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAYAND date < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY