I have this query : which returns ALL records from the ID’s I was thinking of using CURDATE as in order to get last records but when a record is not modified a day (they usually do but sometimes this is not the case) I’m loosing the records . How would I modify the query to get the last entry