public static function delete_product_query_transients()
{
// Increments the transient version to invalidate cache
WC_Cache_Helper::get_transient_version('product_query', true);
// If not using an external caching system, we can clear the transients out manually and avoid filling our DB
if (!wp_using_ext_object_cache()) {
global $wpdb;
$wpdb->query("\n\t\t\t\tDELETE FROM `{$wpdb->options}`\n\t\t\t\tWHERE `option_name` LIKE ('\\_transient\\_wc\\_uf\\_pid\\_%')\n\t\t\t\tOR `option_name` LIKE ('\\_transient\\_timeout\\_wc\\_uf\\_pid\\_%')\n\t\t\t\tOR `option_name` LIKE ('\\_transient\\_wc\\_products\\_will\\_display\\_%')\n\t\t\t\tOR `option_name` LIKE ('\\_transient\\_timeout\\_wc\\_products\\_will\\_display\\_%')\n\t\t\t");
}
}