wpdb custom post_type problem

If you’re trying to get all meta values for a key within a specific post type, you can do something like this in a single query:

SELECT post_id, meta_value FROM $wpdb->postmeta pm, $wpdb->posts p
WHERE meta_key = 'sd_rating' and pm.post_id = p.ID  AND p.post_type="cpu"

Related Posts:

  1. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  2. find a random blogid across my multisite network that has at least one post published
  3. Create Pages from Database
  4. How do I write this SQL statement for Posts written in last 24 hours?
  5. Combine tax_query and meta_query in WP_Query
  6. Want to filter only parent post in admin area
  7. How to use custom post type APIs, but use a different db table
  8. Calculating Bayesian average for custom post type
  9. Order by custom table and multiplication
  10. Adding custom tables to WordPress
  11. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  12. Insert post metadata for all posts in CPT at once if metadata no existent
  13. Convert simple SQL Query to WordPress query
  14. convert custom query to wp_query
  15. Converting the_content string to an array?
  16. How to import a custom MySQL DB table into a WordPress custom post type
  17. WP_Query orderby and tax_query
  18. Save custom post type to external database
  19. Proper way to display latest 5 posts grouped by post type?
  20. WPDB for post count on post
  21. foreach loop inside the loop creating duplicates in output
  22. $wpdb is queried but results don’t show
  23. Does this archive template part look like its making too many calls to the db?
  24. Custom post type and custom taxonomy key lenght & query performance
  25. How select query is generated in a Custom Post Type?
  26. How to store additional data that is related to core data
  27. How to use costum database table for custom post type
  28. Populate custom post type/custom fields from an external database
  29. Custom post order when using OR relation
  30. CPT or Custom Table for Repository of Serial Numbers
  31. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  32. Shared Custom post type between WP network sites
  33. Assign a tag to custom post type using a query
  34. Display all posts in a custom post type, grouped by a custom taxonomy
  35. How to return number of found rows from SELECT query
  36. Get posts for custom post type with WP_Query
  37. Custom Post Types, or completely custom?
  38. WP_Query() show posts that end later than today
  39. How to check if a WP_Query has data
  40. Sorting a query by custom field date
  41. Enforcing canonical URLs with multiple custom post types
  42. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  43. Retrieving 3 latest post from each of 5 different custom post types
  44. how to group custom post type posts by custom taxonomy terms
  45. How to sort CPT by custom meta value (date), and return posts month by month
  46. Wp-query causing problems with the_content();
  47. $wpdb returns no results with SELECT query on custom post type, works on default post type
  48. Multiple Archive Pages for Custom Post Types AND Taxonomies
  49. Exclude current post when getting related post on custom post type and taxonomy
  50. Display Posts of a Category in Alphabetical Order (Custom Post Type)
  51. How to query different post types in specific order?
  52. Loop on front-page.php
  53. Display custom post type from dynamic custom field
  54. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  55. How to create database table, add data, update and delete using wpdb via plugins?
  56. Custom-Posttype & Custom Taxonomy WP_Query
  57. Stuck in Order by more then one
  58. Display featured image from one CPT within another CPT query
  59. How do you paginate a query grouped by month?
  60. Why is my category template ignoring post type?
  61. pagination not working for category.php (custom post types in categories)
  62. Query based on custom fields start and end date
  63. Retrieve custom post types by custom taxonomies with WP_Query
  64. Different Limit number of post on different archive page
  65. DIsplaying URL of custom field in last post of certain taxonomy && post type
  66. Using page slug in wp_query
  67. Custom taxonomy wp_query woes.
  68. Different options per post type in WP_Query
  69. Custom Category Walker with Image, Fallback to Most Recent Post in Category Image
  70. Custom Post type loop with ACF not displaying properly
  71. Sort results without WP_QUERY?
  72. Using Wp_Query, Json to add Highcharts series data
  73. Display the current post in browser as the first post in a loop (for a slideshow)
  74. How to query Posts from a custom post type which contains a custom taxonomy?
  75. Get_the_term_list inexplicably adds values in foreach
  76. Single parent post lists child posts with pagination
  77. custom taxonomy pagination 404 error
  78. wp_query can’t get max_num_pages in custom post type
  79. After inserting new post with wp_insert_post() the post is not visble to WP_Query, but the same WP_Query works for post inserted from wp-admin panel
  80. Filter in Custom post type to find the parent post
  81. “BS_” rows in postmeta table
  82. how to display posts content on the custom css popup by clicking on each title on the sidebar?
  83. How do I insert a custom post type query after a certain number of recent posts and then resume recent posts?
  84. how to display new private message to users?
  85. subtracting the current post form then whole loop, which is generating all CPT titles
  86. Displaying WordPress posts from post and custom post type in custom taxonomy
  87. Imported Content Doesnt Show Up On Frontend
  88. Loop carousel slider in wordpress
  89. Manually build WP_Query
  90. Custom Post save causes 500 error
  91. Loop with Custom Post Type and Taxonomies
  92. How to load more custom type posts through AJAX & LOAD MORE POSTS button
  93. Pagination always adding “Next” link when results come from Custom Post Type WP_query
  94. 404 on Pages for Custom Post Type & Query_Posts
  95. Is it possible to make is_category() recursive?
  96. Get X posts with the same terms as the current post (custom post type and custom taxonomy)
  97. How can I show posts with the same tag?
  98. Load posts via AJAX without draft status
  99. Uploading to WordPress Database
  100. WP Query – Can’t get posts with specific taxonomy