Debugging your query is always a good option, so I would try some variations of your query, to see that it actually uses the fields you believe it does.
For me with a small set of test files, this produced:
(Why is the list, in there? )
And then slowly add in the other bits and pieces, until you’ll get your wanted output. In my case, I added a where last_check, and that worked, so then I added a where last_check and last_check < date(today) - dur(7 days) and it also worked.
So it seems like it should work, but you might have some issue related to date formatting, so please check that and possibly run the query above and show us the output.
It would be even more helpful, if you do the debug version without the where clause, and with the addition of the elements from the where clause as I suggested in my previous reply.
We know that for you the complete version doesn’t work, but we need more information to help you determine why it doesn’t work, and doing the query without the where clause, and adding those fields used, could be one way to enlighten us all.
That’s a good catch @mnvwvnm, which further illustrates why it’s so good to see the larger debug table so one could see which data is actually used in the queries!
See my first reply. It doesn’t limit the output so you get too much information, but it’s helpful to see that you actually get what you expect to get.
In your particular case, if we’ve seen that earlier on, we would have caught on the fact that your last_check inline field is actually links, and not just pure strings.
Doing debug variations of your table, is always helpful to properly verify that you actually get what you think you’re getting, instead of just assuming what you’re getting.