Not the best solution 😛 but this could help you: select distinct(p.ID) from wp_posts p, wp_term_relationships r, wp_term_taxonomy tt, wp_terms t WHERE p.post_author in (1, 2, 3) and r.object_id = p.ID and tt.term_taxonomy_id = r.term_taxonomy_id and tt.taxonomy = ‘category’ and tt.term_id = t.term_id and t.term_id in (1, 2, 3);
The obvious first step would be to use get_col instead of get_result. You will get an array returned straightaway so you could skip your foreach and go straight to: $args = array( ‘author__in’ => $following_users_ids, ‘posts_per_page’ => 12, ‘paged’ => $paged, ); Behind the scenes, get_col does much what you are doing but you are … Read more
You will need to do a JOIN on the users table in your old database, and also select the display name. One key thing to note here, is that I aliased dbold_posts as P, and dbold_users as U – when dealing with multiple table, it’s always best practice to specify which table you are referring … Read more
First, you’re using prepare() wrong. Should be this: $wpdb->prepare(“SELECT Active FROM testers WHERE user_id = %s”, $user_id) Or even better (%d) represents numeric value as oppose to %s which is string: $wpdb->prepare(“SELECT Active FROM testers WHERE user_id = %d”, $user_id) If you have any debugging enabled, it will throw an error from your code. Which … Read more
You can edit and run the below SQL query in your database. Make sure there are no users with the existing ID you specify. If there are change all instances in all 3 tables, currently set to 4 to another number that does not yet exist. INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, … Read more
The use of wpdb->insert and wp_insert_post both accomplish an SQL Insert, which is why you’re seeing 2 records each time. You must use only one instance of an insert method, and then Pass $my_post to WP_Query CLARIFICATION As Milo points out in his comment wpdb->insert will insert into any table, while wp_insert_post is used to … Read more
Did a little bit of searching around this site and found some links that should help you achieve your goal 1) Search all posts that match a specific title – Found this nifty code on another thread here – A use case example of the above function here 2) Updating the “tags” for a specific … Read more
You just need to return the user ID in the main select and use that as the author ID. Also I probably confused the issue previously by using echo with commas (separate arguments) rather than dots (one concatenated argument). $weekly = $wpdb->get_results ( ” SELECT u.ID, ( SELECT CONCAT_WS(‘.’, SUM(CASE WHEN p.post_date > ‘$date2’ THEN … Read more
Well, WordPress.com it’s the largest deployment of WordPress Multisite and they’re basically using the same setup (multiple tables for each site), so you could say that it’s a good strategy. This kind of setup would let you to, for instance, keep your VIP users on a dedicated box, or add multiple DB servers as the … Read more
Well, first of all, you use where post_status=”publish”. So you wouldnt need to explicitly tell the drafts not to show up by using wp_posts.post_status != ‘draft’ I think, your SQL says somthing like: Grab all posts which are published and not drafted and attached to term_id 17 OR grab all posts which are attached to … Read more