0
votes
2answers
19 views

WordPress Screwing Up 'orderby' => 'meta_value_num' in 'pre_get_posts'

I have a bunch of _ai_price_int meta values set up as just numbers. This is how the table looks: meta_id, post_id, meta_key, meta_value 1309, 1111, _ai_price_int, 6550 1310, 1115, ...
0
votes
1answer
27 views

How can I use 'orderby' => 'meta_value_num' to order by the numerical value even if the value starts with a word?

I'm using 'orderby' => 'meta_value_num' to order some boats I have as a custom post type, the meta values ordered by, are boat models, which are normally just numbers but if you look at this page: ...
0
votes
0answers
15 views

query multiple posts orderby two custom fields? [duplicate]

I would like to query my two custom post types and sort them by a custom field if it isset . they are 'job_ispaid' and 'blogger_ispaid' which are both either 0/1 and also displaying the post in date ...
0
votes
0answers
53 views

How to order query by meta value added date

I have a movie trailers website. There are usually two or three trailers on the same page for a movie. I add trailer urls using multiple custom fields. When there is a second or third trailer I simply ...
0
votes
1answer
270 views

AJAX pagination call to get_posts with an offset and a meta_value_num sort returns same post on adjacent pages

I have a simple AJAX pagination that seemed to work just fine, calling one Wordpress page (not ideal, I know) with a pagenum and a sort order arguments and it returned 4 custom posts per call. The ...
0
votes
1answer
95 views

Problem with meta_value order after update

I use following array and works fine... sort post by meta_key where value of t_count is a number: $args = array( 'posts_per_page' => 10, 'meta_key' => 't_count', 'orderby' => ...
0
votes
1answer
58 views

Order by meta values

I have 3 meta fields related to dates: year = 2012 release_date = 14 November 2012 release_date_db = 20121114 I need to show the posts from year 2012 sorted by release_date. I made this: ...
1
vote
1answer
106 views

Custom order for Mysql array

I have a Page of Posts, each post has a Custom Field "expired" which contains a date in the format YYYY-MM-DD which is used to order the posts. This date is used for a script that tells the visitor if ...
0
votes
1answer
1k views

Order by custom field date with ASC order

I've found several similar question but none of them explains why the below is giving me nothing with ASC order. It works with DESC. Basically it's a query that should list posts where the custom ...