This is a fix for the query introduced in #11731 where the LIMIT is applied to a list of sorted names, potentially ignoring more recently used names if the number of results exceed 100.

First we select all the unique names with their values and latest dates, then we re-sort that list by date and select the 100 most recent ones.

Alternatively, we could remove the limit entirely.