It looks like I’ve managed to work it out. I needed to: JOIN to wp_posts With the link keys: TABLE : wp_postmeta column : meta_key TABLE : wp_posts column : ID SELECT * FROM wp_terms wpt LEFT JOIN wp_termmeta wptm ON wptm.term_id = wpt.term_id AND wptm.meta_key = ‘thumbnail_id’ LEFT JOIN wp_postmeta wppm ON wppm.post_id = … Read more
That’s not what esc_sql is for, or what it should be used for. Safely Escaping Variables In SQL Queries To make variables safe for an SQL query, use $wpdb->prepare, e.g. $table_name = “{$wpdb->prefix}myTable”; $myID = 12; $wpdb->query( $wpdb->prepare( “UPDATE `$table_name` SET `your_column_1` = 1 WHERE `$table_name`.`your_column_id` = %d”, $myID ) ); Notice that $myID is … Read more
You’re probably better off doing this with wordpress functions and adding a button which would delete all posts (or even having a shortcode that, when loaded, would do it). The reason I recommend doing this instead of SQL directly is that wp_delete_post() will take all the associated meta with it, which saves you having to … Read more
You can do it easily with WP_Query: $args = array( ‘date_query’ => array( ‘relation’ => ‘OR’, array( ‘column’ => ‘post_date’, ‘after’ => ‘-2 days’ ), array( ‘column’ => ‘post_modified’, ‘after’ => ‘-2 days’ ) ) ); $query = new WP_Query( $args ); More information about date_query parameter of WP_Query. If, for some reason, you still … Read more
Your SQL doesn’t look right. It should be more like $prep = $wpdb->prepare( “SELECT * FROM {$table_name} WHERE name LIKE ‘%s'”, $city );
This removes the posts and all associated post meta data: DELETE a,b,c FROM `wp_posts` a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_author=”0″; Replace the 0 with the ID number for the post_author you wish to remove.
The Problems You risk SQL injection, with your current setup: $wpdb->users.display_name LIKE ‘$ltr%’ The following could also be a problematic part in your SQL query: AND $wpdb->usermeta.meta_value = %artist% i.e. using = instead of LIKE. You’re also missing the quotes: %\”artist\”%, to exclude e.g. bartist or fartist 😉 But you don’t need to construct this … Read more
Look at this Bulk post type conversion, there are listed SQL/WP ways to do that. Try to do that yourself first with a db copy. In phpMyAdmin there is a box to run queries, called “SQL”. You can see a demo here http://demo.phpmyadmin.net/master-config/
In your WordPress Dashboard, if you go to Tools > Export, you can select your custom post type and export only posts in that post type. It gives you the option between All Content, Posts, Pages, and your custom post types following those three options. As for SQL, well are you looking to export the … Read more
What you want is: source.id IS NULL This will match items that have no source set at all.