SELECT DISTINCT p.ID AS id, p.post_title AS title, ( SELECT group_concat(p2.guid SEPARATOR ‘, ‘) FROM wp_postmeta pm LEFT JOIN wp_posts p2 ON pm.meta_value = p2.ID WHERE pm.post_id = p.ID AND pm.meta_key = ‘_thumbnail_id’ AND p2.post_type=”attachment” ) AS image, ( SELECT group_concat(pm.meta_value SEPARATOR ‘, ‘) FROM wp_postmeta pm WHERE pm.post_id = p.ID AND pm.meta_key = ‘views’ … Read more
I had a spelling error in my database that I for the life of me couldn’t see… I popped this handy line in to help me diagnose: $wpdb->show_errors(); Thank you for your patience!
Your problem is in using as orderby value meta_value and thus the order is correct – from computer point of view. To get currect order from human point of view, try to use meta_value_num instead. You can read more in here: https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters
Meta Query And/Or
You are asking for the last three posts ordered by post date, not for the posts from the last three days– ORDER BY post_date DESC LIMIT 3. post_date has a time component to it. It is not just marked with a date. Even so, that LIMIT would restrict the query to last three in the … Read more
Look at the very last part of that query– LIKE ‘%\”17497\”%’. You are searching for any characters, followed by literally “17497”, followed by any characters. I am pretty sure that is not what you want. I think you want any characters, followed by 17497 without the quotes, followed by any characters. That means the meta_query … Read more
What you want is: source.id IS NULL This will match items that have no source set at all.
The answer is… I’m an idiot! (sort of) My query is fine. It’s not pulling the post I expected it to because I had a LIMIT of 7 and when organized by date my expected post was further than 7 down the line. I was getting confused because the end result of this is a … Read more
$wpdb->insert() does not Insert record in a table
How to import a Typo3 database to a wordpress site?