This should do it: $querystr = “SELECT comment_count, ID, post_title FROM $wpdb->posts wposts, $wpdb->comments wcomments WHERE wposts.ID = wcomments.comment_post_ID AND wposts.post_status=”publish” AND wcomments.comment_approved=’1′ AND wcomments.comment_date > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 YEAR) GROUP BY wposts.ID ORDER BY comment_count DESC LIMIT 0 , 10 “;
You can easily sort by native post fields, so try something like this: $posts = get_posts( array( ‘numberposts’ => 10, ‘orderby’ => ‘comment_count’, ) );
As in the comments, it’s not clear why you can’t use the options: dashboard -> settings -> reading -> Blog pages show at most [] posts However, if it is necessary that this be done via altering the query (say to target only specific pages, or archives) then this should really be done on pre_get_post: … Read more
Got it <?php query_posts(‘posts_per_page=2’ . ‘&paged=’ . get_query_var(‘paged’)); if (have_posts()) : ?> <?php while (have_posts()) : the_post(); ?> as simple as that.
If you want to change your array to exclude sticky, then this should work get_posts( array( ‘post__not_in’ => get_option( ‘sticky_posts’ ), ‘posts_per_page’ => 1 ) );
Your examples are showing two different thing The first one is looping over categories and the second is looping over posts, so the answer in this case is simple and depends on what you need to loop over (posts or categories). No if you meant when should you use query_posts() vs. get_posts() vs. WP_Query then … Read more
The meta tag Google is searching for has to be put into the head section of your HTML. You cannot change this section in a post editor. If you don’t want to edit your theme files: Install the plugin Magic Widgets and activate it (Plugins/Add new). Got to Design/Widgets and drag the Widget Unfiltered Text … Read more
You can’t concatenate an array onto query_string like that. See Digging Into WordPress’s post about looping for the right format. Alternately, you can use array_merge() like on the query_posts Codex page. Consider using wp_reset_query() after your loop. Sometimes you’ll also see people save the original $query_string to a new variable, modify $query_string, and then reset … Read more
I’ve done a few templates that essentially are on one page. I used this code as the starting block for all of them: <?php $my_wp_query = new WP_Query(); $all_wp_pages = $my_wp_query->query(array(‘post_type’ => ‘page’,’posts_per_page’ => -1)); foreach ($all_wp_pages as $value){ $post = get_page($value); $slug = $post->post_name; $title = $post->post_title; $content = apply_filters(‘the_content’, $post->post_content); }; ?> It … Read more
The code you’ve provided doesn’t actually print out the list of pages; it just creates the query for them. Assuming you have additional code for displaying them, the easiest way to accomplish what you want in a plugin is to build that list, then add them using the_content filter. I would probably create the list … Read more