You are trying this in the same db copy that you posted, or in your original db? If in the original, that is not what I have to play with. That might...
No prompt for me. Here's some of the query results. Maybe I broke something when I posted, because I entered line feeds in the sql. Reposted below.
...
You will get multiple records with repeating data because of grouping. Taking the first of the last 4 fields shown as an example, for every revision...