Combining two select posts from mysql – to get least viewed posts
This should be the SQL you’re looking for (off the top of my head, so may need some tweaking). “SELECT * FROM wp_posts LEFT JOIN wp_popularpostsdata ON (wp_posts.ID = wp_popularpostsdata.postid) LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE posts.post_type=”post” AND wp_term_taxonomy.term_id NOT IN (73) GROUP BY wp_posts.ID ORDER … Read more