title: Stop further randomisation with flask paginate
body: <p>I've created a demo website which queries a database and then paginates the results. The user might want to set the results to be returned in a random order. The problem I have is that if the user chooses the random option, when they start to click through the results pages, the results are randomised for each page which causes a repetition of the returned results. Is there a simple way to stop this happening?
  The randomisation is done as part of the sql query i.e order by rand(). If you want to see what I mean, the website is namelessfashion.co.uk </p>