title: mysql row count fail
body: <p>I'm currently using SQL_calc_found_rows on a pagination page. On my local and it returns the row count as expected based on the SQL query perfectly..... We then run it on our staging, and test servers all is perfectly fine... Results of the returned row count is correct and as expected.
  However when run on our live machines the row count is wrong and always the same value. I'm totally lost and perplexed. Any help on this? Guidance?</p>