SQL query to remove first image in all posts
SQL query to remove first image in all posts
mysql
How to count post meta key values for all posts in database
You have a structural problem with your data. Serialized data in the database is terrible if you need to search over pieces of that serialized data. There is no reliable, efficient, and certainly no easy, SQL query to search over serialized data. “serialization” is a PHP mechanism. It isn’t SQL. To the database that is … Read more
Splash pages on a high traffic site
Splash pages on a high traffic site
How to make an sql query to exclude everything but custom taxonomy terms in table wp_terms?
If you take a look at get_terms() documentation it accepts search argument, which will perform LIKE match against term name and slug.
retrieve wordpress post-meta using php not wordpress functions
The reverse mechanism should work. I assume you are trying the get post metadata with the post row. $resultat = mysqli_query($con,”SELECT * FROM wp_postmeta LEFT JOIN wp_post ON wp_postmeta.post_id = wp_post.ID WHERE wp_post.post_type=”shop_order””); However, there will be a lots of duplication. If one post have 100 metadata, you are also getting the post row 100 … Read more
Get a list of the last posts grouped by author and filtered by category
Get a list of the last posts grouped by author and filtered by category
Slow WordPress admin panel with a total query time of 1664ms
What host service are you using? I had the same issue using Dreamhost, where you can adjust the memory limit for the server you are using on the hosts panel. Doing this solved the issue for us. Also, a possible issue could be your SQL server, switching to another SQL server may resolve your issue. … Read more
How to connect database table to each registered wordpress user.
How to connect database table to each registered wordpress user.
Custom MySQL Query for Post and Post Meta
You have to use JOIN for that. Try it like this: $wpdb->get_results(“SELECT tags.*, $wpdb->posts.*, $wpdb->postmeta.* FROM tags INNER JOIN $wpdb->posts ON tags.charity_id = $wpdb->posts.ID INNER JOIN $wpdb->postmeta ON tags.charity_id = $wpdb->postmeta.post_id WHERE tags.charity_id = $charity_id” );
How to change the publishing date of each posts?
If you need to modify the publish date for hundreds of posts then your best bet without a plugin or homemade solution is through a MySQL query.