Try to cut the query in smaller parts, using temporary tables. Having sub queries is always time, memory and cpu consuming.
That should do the trick.
Related Posts:
- How does WordPress handle MySQL row lock errors?
- $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
- Help With MySQL to WPDB Query Conversion
- Creating mySQL procedure with $wpdb
- 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
- WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
- Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
- Insert data from .sql file in wordpress plugin
- WordPress Backend HA (Automatic failover)
- DB Query not working in Plugin
- Way to send multiple values for column to MySQL?
- WordPress plugin: efficient way to store large data
- Plugin generating unexpected output – on WP mysql dump import
- Can’t create tables with my plugin
- Integrating Custom Database with WordPress
- How to display results from a data table with an encrypted user id?
- How to get the custom field value using SQL query
- Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
- I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
- WordPress UPDATE queries on MySQL database stuck
- Resetting AUTO_INCREMENT primary key
- Create Database Tables on Plugin Activation hook
- Linking Plugin Files to WP
- how to search through plugin in wordpress cimy-user-extra-fields?
- Get all the related data from WordPress DB
- How to display blog posts only authored by the administrator
- How can I delete the options from DB when the plugin is deleted?
- Get plugin directory from a theme
- category_name not working (not showing up in sql query debug)
- What happens when two plugins have the same 3rd party class included into them?
- add_rewrite_rule, plugin activation and plugin deactivation
- Custom admin column disappearing when using Quick Edit [duplicate]
- Create page when plugin is activated
- Update Multiple Post Meta for the Same Post In One call?
- Allowing Custom Capability to Manage Plugin Options
- wp_insert_user – how to send verification email before logging in
- Custom plugin settings: clicking “save changes” does not display success message
- How to un-attach rich text editor from named textarea elements
- How can I translate the name of my Plugin for other languages?
- how to not show plugin in admin area
- Getting User email on logout. wp_logout
- How can I filter blog name?
- Logs to check when the plugin was first installed for the first time
- Can a plugin add to header/footer/body content?
- Detect if a plugin was included in a certain page
- Admin page: form with enctype=”multipart/form-data” does not transfer its data
- How do I add a custom sub menu menu under Woo-commerce marketing?
- How to load plugin after page is loaded – pagespeed issues
- How to create custom tables in WordPress using my own plugin?
- How to modify WCMP Rest API response?
- Making a Template for a CPT created by a plugin
- Woocommerce dependent plugin
- External CSS in WordPress Plugin [closed]
- User Session and Stored Cookies not get removed
- get 404 when accessing wp-admin/plugin-install.php
- Woocommerce Minimum Price for a Composite Product to add in cart
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- add tabs in rdp-plugin/includes/settings.php and get settings saved
- Plugin Development Form Self Submission
- How To Extend A WordPress Plugin Without Losing Your Changes [duplicate]
- Does a blank plugin come with any overhead?
- WPDB: Update table
- Why is my custom post type not being activated on plug-in activation?
- Check filter defined or not?
- How to generate an all in one WordPress New content, plugin and theme update report on a website? [closed]
- Why WP_Screeen doesn’t show all options with admin_body_class
- License validate function
- wp_enqueue_style on template_redirect level?
- Built a second plugin but it overwrote the first one
- Symlink a plugin in local development, works but got Debug error message – Windows 10
- Custom Post Type template for homepage
- How can i export and import my plugin option WordPress
- Remove all messages, when untrash a post
- Why won’t wp_enqueue_script work within any plugin file?
- Help to Create a Simple Plugin to make a post
- Error using wordpress functions inside a plugin class
- How to resolve warning for `unstableOnSplit` prop on a DOM element in block editor
- Rename a folder via HTML POST request
- add tags to wordpress post using REST API
- path of wp-content directory when we are on some plugin
- how to do Thematic like this website using wordpress?
- Add Custom Field to Post Pages via Plugin
- Timing issue with is_amp_endpoint()
- Is it possible to change plugin’s Admin Panel Url?
- Can I add content before post content without using the_content filter
- Why is the WordPress update_option not working in this code?
- what is the best way to create a premium plugin while also protecting your code
- hide load more button if there are no posts left to display
- Force download a file within plugin file
- How can I use multi Media Uploader in a plugin?
- Is it possible to run javascript on plugin deactivated?
- Gutenberg: Dynamic Block – Show saved data in the editor
- How to fix ‘Call to undefined function do_settings()’ error?
- How can I save the selected page in the dropdown after anyone clicks on Save Changes?
- Update Content for a Custom Block Toolbar Button
- How can I save the selected page in the dropdown after anyone clicks on Save Changes?
- Wrong block appender button showing
- Uncaught Error: Cannot use object of type stdClass while showing the list using WP_List_Table
- WordPress Throwing Deprecated Errors on its own Files
- plugin doesn’t retrieve data from database