You can order them manually after the query is complete: $ids = array (60, 23, 78, 46, 105, 130) $args = array ( ‘posts_per_page’ => -1, ‘post__in’ => $ids, ‘orderby’ => ‘none’ ); $query = new WP_Query ( $args ); $ordered_posts = array(); foreach($ids as $rpid) foreach($query->posts as $index => $fpid) if($fpid->ID === $rpid) $ordered_posts[] … Read more
Since WordPress 4.1 it is possible to build nested meta, date and tax queries. I’ve not tested it but the code bellow should work. Also, I recommend to replace PHP date() function with current_time from WordPress to get the current date taking in account the blog time zone configuration: After the chat with you, it … Read more
That’s certainly something you must solve on the server side, only omitting the arguments in URL would cause errors when accessing the non-existent keys in the $_GET array. You should build your arguments array dynamically based on whether the values are set ot not. Example: $args = array(); foreach(array(‘s’, ‘country’, ‘year’) as $key) { // … Read more
But am looking for a plugin or a code which can help me with adding this note every time I write a post. A shortcode to add that “note” is trivial. function note_sc_wpse_107275($atts,$content) { return ‘<p class=”note”><strong>’.$content.'</strong></p>’; } add_shortcode(‘note’,’note_sc_wpse_107275′); Then just add [note]Note content[/note] to your post body. That will give you exactly what you … Read more
This is just a concept which you can try. By default, you cannot sort within the loop. You have, according to my knowledge, have two choices Create two loops and merging them. This, however, I would not recommend. Pagination and offsets are a nightmare if you are not completely comfortable with it Run your loop … Read more
You have a structural problem with your data. Serialized data in the database is terrible if you need to search over pieces of that serialized data. There is no reliable, efficient, and certainly no easy, SQL query to search over serialized data. “serialization” is a PHP mechanism. It isn’t SQL. To the database that is … Read more
Rather than attempt to fix your query, I recommend you sidestep it entirely by using custom post type archives! With permalinks on, you should be able to view a list of all your movies posts by going to: example.com/movies Then, in your theme, create archive-movies.php, and it will be used instead of the archive.php/index.php for … Read more
When you store an array as meta_value you are storing a string with serialized data that represents the original array. This format is appropriated for data that are only intended to display. Data that you plan to use for ordering or searching by or in any other way that is not just display the information … Read more
Here are two ideas for your date_query part: 1) After 2 days ago: If you need posts published after current time, 2 days ago: ‘date_query’ => array( array( ‘after’ => ‘2 days ago’, // or ‘-2 days’ ‘inclusive’ => true, ), ), then the corresponding SQL part is: post_date >= ‘2014-09-09 17:57:15’ if the current … Read more
Using Query Monitor I was able to find the source of this query, it was from a plugin “starbox” which uses the query to fetch the last 3 posts from the author of a given post. Editing the plugin by commenting out the part it runs this query solved the issue.