#wp_query

Get all posts by post meta key and meta value

Description

For some situations, we need to get all the posts which have specific meta key and meta value.

We can do it with the help of the WP_Query class.

Example

Note: I’m giving you an imaginary example just for a reference to understand, In which situation you can use below code snippet.

Suppose,

We have a custom post type properties.

We have 15 properties are published.

We…

original source : http://beebell.co.uk/wordpress-queries-when-to-use-wp_query-get_posts-query_posts-pre_get_posts/

When you’re creating a custom theme, at some point you may to want to bring back a set of results other than what WordPress defaults to. The question is, do you use WP_Query,get_posts,  query_posts or pre_get_posts?

Scenario 1 – You just need an archive page

Soluion: None of the above

If something can be accomplished without writing code, let WordPress do it for you.

If you want to move your main blog posts archive (ie. list of all your posts, usually just the excerpts) from the front page to another page (eg. a page entitled ‘Blog’), all you need to do is: a) create a new page called ‘Blog’ b) Go to Settings > Reading and select ‘Front page displays: A static page’ and select your posts page:

If you want an archive or single page for a custom post type, use the relevant templates from the template hierarchy. Eg. For a custom post type ‘books’, use archive-books.php.  The default loop will display all ‘books’ posts, and each individual post will be displayed with single-books.php.  The exact link will depend on your permalink structure. If you’re using the ‘post name’ option (see Seetings > Permalinks) then http://yourdomain/books will automatically load your books archive template.

Scenario 2 – Your page already utilises a loop and you need an additional loop

Solutions: WP_Query or get_posts()

The difference between the two is that WP_Query returns an object and get_posts returns an array.  If the content you want is fairly lightweight, for example a list of titles, then you can use get_posts and loop through the array with a foreach.  If you want a fully blown WordPress Loop and the ability to use template tags such as the_content(), go for theWP_Query option.

Scenario 3 – you want to alter the main loop

Solutions: query_posts() or pre_get_posts

By the time Worpress loads your template and runs the code in your template, it has already run a query on the database and is holding the results ready for you to use in the loop.  If you use query_posts to modify the results, WordPress throws away the previous results and runs another query on the database to bring back your results.

Because of this, it is generally recommended to hook into pre_get_posts instead. To do this you would create a function in your theme’s functions.php.  This enables you to alter the query before it is run. However, this affects all of the queries on your site, front-end and admin, if you’re not careful.  Therefore you need to put in checks to make sure it’s not an admin page/it is the main loop/it is in fact the template you wanted to affect.

In this example I have created a custom post type called ‘product’, and have a custom field called ‘colour’. My wordpress front page is set to ‘Your latest posts’. WordPress will use the home.php template to disply this if it is available. Here I am altering the query for the home page to only show Products that are red:

function bb_red_things( $query ) { if ( is_home() ) {        // Set post type to 'product'        $query->set( 'post_type', 'product' );        // Limit to products with a custom field 'colour' set to 'red' $query->set( 'meta_key', 'colour'); $query->set( 'meta_value', 'red');    } } add_action( 'pre_get_posts', 'bb_red_things' );

original source : http://wordpress.stackexchange.com/questions/50761/when-to-use-wp-query-query-posts-and-pre-get-posts

You are right to say:

Never use query_posts anymore

pre_get_posts

pre_get_posts is a filter, for altering any query. It is most often used to alter only the 'main query':

add_action('pre_get_posts','wpse50761_alter_query'); function wpse50761_alter_query($query){      if( $query->is_main_query() ){        //Do something to main query      } }

(I would also check that is_admin() returns false - though this may be redundant.). The main query appears in your templates as:

if( have_posts() ):    while( have_posts() ): the_post();       //The loop    endwhile; endif;

If you ever feel the need to edit this loop - use pre_get_posts. i.e. If you are tempted to use query_posts() - use pre_get_posts instead.

WP_Query

The main query is an important instance of a WP_Query object. WordPress uses it to decide which template to use, for example, and any arguments passed into the url (e.g. pagination) are all channelled into that instance of the WP_Query object.

For secondary loops (e.g. in side-bars, or 'related posts' lists) you'll want to create your own separate instance of the WP_Query object. E.g.

$my_secondary_loop = new WP_Query(...); if( $my_secondary_loop->have_posts() ):    while( $my_secondary_loop->have_posts() ): $my_secondary_loop->the_post();       //The secondary loop    endwhile; endif; wp_reset_postdata();

Notice wp_reset_postdata(); - this is because the secondary loop will override the global $postvariable which identifies the 'current post'. This essentially resets that to the $post we are on.

get_posts()

This is essentially a wrapper for a separate instance of a WP_Query object. This returns an array of post objects. The methods used in the loop above are no longer available to you. This isn't a 'Loop', simply an array of post object.

<ul> <?php global $post; $args = array( 'numberposts' => 5, 'offset'=> 1, 'category' => 1 ); $myposts = get_posts( $args ); foreach( $myposts as $post ) :  setup_postdata($post); ?>    <li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li> <?php endforeach; wp_reset_postdata(); ?> </ul>

In response to your questions

Use pre_get_posts to alter your main query. Use a separate WP_Query object (method 2) for secondary loops in the template pages.

Mastering WordPress WP_User_Query Class

What Is WP_User_Query?

You probably get the idea of what WP_User_Query is by merely reading its name. Yes, nobody would expect to see WP_User_Query working with the “Tag Cloud” widget—it’s a class that runs queries about users in WordPress.

Let’s see what WordPress Codex says about the WP_User_Query class:

WP_User_Queryis a class, defined in wp-includes/user.php, that allows querying WordPress…

(vía https://www.youtube.com/watch?v=JucC6c5RMH8)