Scalability Pro 5.93

* Hotfix for pagination page 1!

* Fixed the remove product category hierarchy option in wp-admin > products list view

* Upgraded the Remove Row Count feature
- limits itself to running against post queries with < 10 rows requested
- transforms news and magazine sites or those with mega menus where you have a dozen or so short queries for posts on your various pages
- added similar code to the Admin version of Remove Row Count
- we're seeing newpaper page load speeds drop from 12s to 1.4s uncached
* Added new tagDiv recent posts indexes for these newspaper websites

* Updated slow query log profiling to improve handling when wp-config.php cannot be edited
- for best results with the query profiling, make sure you have the db.php symlink in place and wp-config.php edited

* Hotfix for settings upgrade from yesterday1

* Added new SPRO_SQL_CALC_ROWS_FINGERPRINT definition to defines.php to allow users to decide additional WP_Queries which should have SQL_CALC_ROWS removed from the query
- Customer was using TagDiv Composer library to build their website and with 8 blocks on their page, this was adding 0.1s, 0.8s to the page generation
- by adding a fingerprint definition into their wp-config.php with this new option, those blocks have SQL_CALC_ROWS removed and speed of those queries becomes instant
- e.g. define('SPRO_SQL_CALC_ROWS_FINGERPRINT', array('td_data_source::get_wp_query', 'td-cloud-library')); // we normally only remove SQL_CALC_ROWS from the main query, but if you add stack-trace fingerprints in here, we will remove that from other queries too

* Added sort order removal compatibility with WooCommerce Product Recommendations plugin

* Fixed issue with identifying and deleting cancelled/canceled scheduled actions in woo - they use the american spelling

* Fixed a bug in the new transient cache where with some db configs it could keep on redefining the table

* Updated stored reference list tables from WP updates
- hopefully this doesn't need to happen too often, maybe I could just reference the constructor of the parent somehow to run the hash check