If you use the top 1 that you have shown, it will only return one row for the whole subquery, so you will only get one match.
If you want to get the matches for one field per row (like the last date a part was used) you can use this technique where the subquery and the matches act on each row individually, so that top 1 becomes very useful then.