Thanks for the reply,  the total number of records if  i remove the where clause "WHERE results.rownumber BETWEEN 1 AND 50" is 623.

I also tried running the query by removing...