After running several test the top 1000... will not work with the query.

The user name and date is being queried, member quired is not one of the 1000 returned therefore, no items selected.

When I run it with the udf random it works.