A generic term referring to the process of retrieving information from a database.
145
votes
3answers
37k views
When should you use WP_Query vs query_posts() vs get_posts()?
It seems like half the tutorials in the codex and around the blogosphere use query_posts() and half use WP_Query. What's the deal?
15
votes
5answers
18k views
How to display sql query that ran in query?
I have come across a function before that displayed the exact SQL code that was used
in a loop for example, but can't remember.
Can anybody tell me that function?
Cheers
13
votes
4answers
1k views
Show a different number of posts per page depending on context (e.g., homepage, search, archive)
In the Reading Settings, there is place to set the number of posts shown that affects the number of posts shown in all contexts. I'd like to show instead a certain number of posts on the homepage, and ...
10
votes
3answers
8k views
Pagination not working with custom loop
I've got a custom loop that I'm using to display some Real Estate listings that will be available within 60 days. I'm calling it with the following function:
<?php
$sixtydays = date('Y/m/d', ...
6
votes
4answers
17k views
Proper way to get page content
I have to get specific page content (like page(12))
I used that :
<?php $id=47; $post = get_page($id); echo $post->post_content; ?>
Work nice execpt for compatibility with qtranslate ...
6
votes
5answers
4k views
Wp get all the sub pages of the parent using wp query
Here is my code
$my_wp_query = new WP_Query();
$all_wp_pages = $my_wp_query->query(array('post_type' => 'page','post_parent'=>$parid,'orderby'=>'title','order'=>'ASC' ));
It displays ...
6
votes
3answers
500 views
Order posts (across the whole site) by metadata date
My custom 'Home' page is set to sort my custom posts via the custom date field with this (updated to be custom named) code in functions.php:
// sort order for home page
add_action('wp', ...
5
votes
6answers
16k views
What SQL Query to do a simple find and replace
Whenever I create a new website I first create a staging site on a subdomain like "stage.domain-name.com".
After everything works correctly I export the database, open it in notepad++ and do a ...
5
votes
5answers
690 views
How can I make wp-pagenavi work on a custom query built upon a form submission?
I've also posted this on the wordpress support forums, for scribu's wp-pagenavi plugin:
http://wordpress.org/support/topic/plugin-wp-pagenavi-custom-query-form-submit-part-2?replies=1
My situation:
...
5
votes
2answers
736 views
Usage of the new “posts_clauses” filter in Wordpress 3.1?
Just noticed that 3.1 added a new filter to customize queries: posts_clauses. All I could find about it is that instead of using the separate query filters like posts_where or posts_join, you can ...
5
votes
1answer
444 views
How to organize and cache additional data associated with terms?
I'm updating a plugin of mine and am have a hard time figuring out the "best way" to build in a specific bit of functionality. The plugin allows users to associate images from their media library to ...
4
votes
3answers
2k views
Optimize Multiple Taxonomy Term MySQL Query?
(Moderator's note: Title was originally: "query/database optimisation")
I'm written a function for a custom "filter" search panel that allows users to select terms from up to four custom taxonomies. ...
4
votes
2answers
349 views
Count & Display Database Queries
I'm looking for an solution how I can count and display all queries in a WordPress site.
Does anybody know, if there is an good plugin?
Otherwise it would be an solution to check the queries on the ...
4
votes
2answers
266 views
How to display Section for certain time
i am building a News site. I want to display 1 featured post from "prime" category for only few hours. after it should be expired or disappeared from the section.
please have a look here u can see ...
4
votes
1answer
181 views
Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
I've registered custom rewrite rules and query_vars to use for displaying a list of events based on ISO date format. For example when a user requests the URL, http://site.com/by-date/2013-04-04/, my ...
4
votes
1answer
372 views
Why does `get_permalink()` produces an add. DB request without $post->filter?
I'm currently working on a custom loop/query where I need to add the permalink of a post to the array of posts I'm retrieving from the DB.
Sadly get_permalink() produces one additional DB request ...
3
votes
4answers
726 views
the_date() not working
I am using wordpress 3.2 and I did a query post like this:
<?php query_posts("posts_per_page=1post=type&page=post_parent=10");?>
Then I try to echo out the date of this post I queried ...
3
votes
4answers
5k views
Query multiple meta key values?
How to query for mutiple meta key values with the same key
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts, $wpdb->postmeta
WHERE ...
3
votes
2answers
506 views
Sort custom post type list table by display name of a user id stored as post meta value
I have a custom post type named domicile. Each post (domicile) has an owner (not the author). Owners are users with a custom role. I store the user id as a post meta value (dmb_owner) for the domicile ...
3
votes
2answers
877 views
Create pagination and order according to alphabet
is it possible to create an alphabet pagination? as well as alphabet order of a query post???
I can't a solution on this based on the regular queries.
I would appreciate any help, thanks in ...
3
votes
2answers
220 views
Identify which loop you are hooking into; primary or secondary?
What is the most efficient way to determine which loop I'm in?
I have a few plugins that alter the query by hooking into various parts of WP_Query::get_posts(), through the usual suspects, ie ...
3
votes
1answer
159 views
How to make an activities stream mixing posts and comments?
What I'm currently trying to make is an activities stream wich list :
The posts,
the comments,
both mixed between them and ordered by date.
My idea is to make two queries, but i don't know how to ...
3
votes
1answer
73 views
How to query for a week using key => value WP_Query argument notation?
I would like to be able to query for a specific year and week using WP_Query argument notation. I am using this notation as I would like the page to paginate.
What's the correct "year" and "week" ...
3
votes
2answers
117 views
Very slow query
This query works, but it takes upwards of 20 seconds to run on a Quad Core dedicated server... How can I optimize this?
$slides=get_posts(
array('post_type' => 'any', 'numberposts' => 5, ...
3
votes
2answers
358 views
Sort X categories by last update and show image
I want to display X categories, and sort them by last update.
I also want to grab the image of the latest post with the category.
<img src="<?php echo ...
3
votes
1answer
968 views
restrict_manage_posts not working in 3.3.1
I have noticed my custom taxonomy filters no longer work in the 3.3.1 admin as per these methods:
Adding a Taxonomy Filter to Admin List for a Custom Post Type?
I also discovered that to filter a ...
2
votes
1answer
708 views
WP_Query vs get_posts
I have read a number of questions on SE regarding these but I still can't figure the exact difference wrt usage. Would it be true to say that I would probably use WP_Query for the majority of ...
2
votes
2answers
227 views
Get a user's most recent post title
If I have a user's ID, what's the best way for me to get the title of that user's most recent post?
2
votes
3answers
991 views
Custom Select Query with Custom Post Types
Have been trying to figure out the issue with this for the past hour, but hitting a wall. Basically I'm just trying to query my custom post type based on some custom date fields and then displaying ...
2
votes
3answers
138 views
Remove [gallery] shortcode altogether
I used remove_shortcode('gallery'); ...the gallery is gone, but the shortcode is visible in the text. How do I remove sitewide? I've searched for sql queries, but no solution fixes my specific ...
2
votes
2answers
1k views
Alter query on edit.php
What's the best way to alter the query being run on the Posts Edit screen (edit.php)?
The current method I'm using is by passing an argument to the global $wp_query like so:
$wp_query->query( ...
2
votes
1answer
99 views
List the 5 most recent child pages
I created a hierarchical custom post type for a gallery. The parent pages are the galleries and the child pages are the albums. I want to display the most recent albums on my sidebar (so basically the ...
2
votes
2answers
196 views
Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
I have a custom post type 'events', to which I have associated a custom taxonomy 'calendar'. The calendar has 12 fixed terms, for each month of the year ( 'august', 'october', 'november, etc.).
I'm ...
2
votes
1answer
1k views
WordPress Paginate $wpdb->get_results
Due to a complex multisite config, I have a query which combines the posts from two blogs and I would like to paginate the results. I am grateful for any help. I have posted my query.
...
2
votes
3answers
319 views
Reversing the order of posts AFTER the query is performed
I'm am displaying the last 5 posts of a custom post type 'show'.
This gives me the latest post first.
<?php
$args = array(
'post_type' => 'show',
'posts_per_page' => 5,
'order' ...
2
votes
1answer
2k views
How to get comments by post ID?
I have this custom post query to list all the posts within a specific category. For example I have this:
$args = array('cat' => 'home','post_type' => 'post'));
$post_obj = new WP_Query($args);
...
2
votes
1answer
983 views
Using WP_Query - how to display something IF there are no results
I've used WP_Query to query and display events. In some cases, though, there are no events to be displayed and I'd like to display a friendly message when that happens instead of displaying nothing - ...
2
votes
1answer
144 views
How navigation works in custom loop within shortcode?
I am using a shortcode to display a custom query. The shortcode is use in page. Everything is fine, only the navigation that I can't get it working correctly.
Here is the function that I use to ...
2
votes
3answers
1k views
get attachments for all posts of particular post type
I'm making a widget that shows a set of images from recent custom posts. I want to run the following query:
SELECT p.*
FROM wp_posts p
WHERE post_type='attachment'
AND post_mime_type LIKE 'image%'
...
2
votes
1answer
3k views
Get all image from single page using this query
I'm having some trouble with this sample widget code. I want to get all images (Minus the post thumbnail) from a page called "Gallery" but for some reason this is pulling all uploaded images from the ...
2
votes
1answer
612 views
query multiple taxonomy and show post count
I have custom post type 'Product',
and 2 custom taxonomies 'category' and 'product status'.
What i am trying to do is list categories in page template and show how many total products in category ...
2
votes
1answer
550 views
orphaned taxonomy terms remove by sql query
I have 3 custom post types each of these CPT's have posts that are set to auto delete via a given time scale by cron jobs, thing is when they are deleted it leaves behind orphaned taxonomy terms in ...
2
votes
1answer
333 views
Plugin similar to Taxonomy Drill-Down for custom fields?
Is there a plugin available that does for custom fields what Scribu's excellent Taxonomy Drill-Down (formerly called Query Multiple Taxonomies) does for taxonomies?
2
votes
1answer
768 views
[Plugin: Posts 2 Posts] How does it work?
I recently discovered Scribu's Posts 2 Posts plugin, which seems to be exactly what I was looking for in order to connect pages and posts for a big editorial website.
But I cannot get it to work, ...
2
votes
2answers
104 views
Remove Unnecessary Mysql Query
my single posts is getting 31 query from mysql. I checked all queries. I saw this query.
I am using last posts and categories widget. I think there query is unnecessary.How to remove theme
Query: ...
2
votes
1answer
220 views
Adding posts of custom type into the main feed
I'm having some trouble with a subject that seems to be pretty basic, so I'm starting to feel (a little, only a little) dumb :-)
Here's the thing: I want my main feed to include the posts and other ...
2
votes
3answers
471 views
Wordpress query by category, sorted by custom field
I have three custom fields set for each of the posts in the events category — year, month, and day. I am already querying for the events category, and now I'd like to sort the posts by the custom ...
2
votes
1answer
182 views
How can I get all posts data from within a paginated search result?
Let's say I'm doing a search on my site, and get 50 posts as a result. The pagination is set to 10 posts per page, so I have 5 pages of results.
When I'm on the first page of results, if I inspect ...
2
votes
1answer
216 views
How can I query all users who registered today?
I'm trying to use meta_query to return all users that have registered today :
$args = array(
'meta_query' => array(
array(
'key' => 'user_registered',
...
2
votes
2answers
693 views
add spans and characters into paginate_links
I am using paginate_links on my custom page query.
What I have already works sweet and this is the code I have so far...
<?php
global $wp_query;
$big = 999999999; // need an unlikely ...
