Query posts by category AND custom field, then ORDERBY another custom field – help!

I ran your query on my local workstation. It looks like there is a typo:

You should have $wpdb->postmeta.meta_value not $wpdb->wpostmeta.meta_value (used twice).

Related Posts:

  1. Add field to posts (checkbox) that only one post can have
  2. How to select posts from multiple categories and metavalues?
  3. what is the correct way to compare dates in a WP query_posts meta_query
  4. How to get current_cat in navbar, in single post
  5. How can I get posts in a subcategory to display on it’s parent categories archive page?
  6. Custom category order with get_categories
  7. How to remove Profile Picture section or the message “You can change your profile picture on Gravatar.”
  8. generate unique number when registering a user
  9. How to get value from custom backend menu
  10. Select category in custom query
  11. Allow Users to Set Password During Registration
  12. Custom sidebar category listing?
  13. Custom protected password page with ACF
  14. Custom Queries – Child Categories not showing up
  15. Return category slug / title from category ID
  16. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  17. Auto add taxonomy if post has category
  18. Passing page url into a custom field via the Press-This bookmarklet
  19. How to extend nav-menu-item-control data in Appearance > Customize?
  20. Custom column sorting in WordPress admin post table
  21. Add custom taxonomy under the category title
  22. How to insert content from another Custom Post type into Post?
  23. Hide custom field if empty
  24. Filter my home page posts by category or by tag
  25. Show posts on a page based on a category and tag(s)
  26. list/consult Taxonomy only for the respective author/creator in dashbboard
  27. How to add “Read More…” link in twentytwenty
  28. Advanced Custom Fields: Sorting custom columns with custom fields sorts only by date
  29. how to get the categories for a single product in a hierarchical way
  30. Automatically check parents (in a taxonomy) when child is selected
  31. How to change popular term checklist title when edit post?
  32. Category selectable homepage
  33. Add a date updated/date modified option using custom fields
  34. How to add textarea field to taxonomy (tag)?
  35. How to add an extra button on woocommerce shop page and use it to send the product info with image in a mail? [closed]
  36. How to change the category url jusy show /category/%category_id% in wordpress?
  37. Woocomerce custom billing address fields display in order details [closed]
  38. How to get Related Custom Posts?
  39. How can I create a permalink with two categories, with the order based on the parent category?
  40. Redirect to another page using contact form 7? [closed]
  41. What requirements for ACF custom fields key and name properties?
  42. How to insert a writing panel between the title and the page content?
  43. Toggle custom fields?
  44. How to print Array values of custom Fields Meta?
  45. Get users based on month ACF datepicker field
  46. What is the best way to modify Admin Panel on WordPress?
  47. if in category but only with post meta
  48. how to make a custom field readonly or disabled by user role?
  49. How do I list custom taxonomy terms with the links?
  50. theme customizer – can a single option pass multiple values?
  51. Make tag archive display post are ordered by post format
  52. Let author add field to metabox by pressing a button
  53. How to auto add nofollow to links in custom field?
  54. Get whole linked with wp_list_pages
  55. Adding Multiple “Parents” in get_categories
  56. Show posts from category specified using a custom field
  57. How to setup a membership system in WordPress?
  58. query_posts meta_key with current date
  59. Is it possible to add custom badges to product attributes conditionally, based on custom field?
  60. Make the home page template my archive/category page template without code duplication
  61. Get custom text if in Category
  62. Create Miltiple Category Base
  63. How to get Previous Visited Page Information
  64. WordPress category custom title
  65. No plugin populate user information in to form
  66. How can Use custom input field in functions.php page?
  67. Simple custom attributes on posts
  68. Use a custom page with dynamic content as a user profile page
  69. Query Product categories what have a custom field
  70. Is it possible to edit a wordpress category with Gutenberg?
  71. How to show related post with category DESC (ASC) IDs of ID current post
  72. Hide entry-header for a specific category
  73. Adding a drop-down (select tag) option under Menu Settings in WordPress Admin
  74. How can I add category variable inside posts?
  75. Automatic Set Category For A Custom Post Type
  76. Replace publish date in blog module with custom field
  77. How do I enable the text editer in my WordPress theme? [closed]
  78. How to add H1 Tag on Homepage?
  79. Add commentmeta custom field to every published comment with SQL
  80. Does WordPress support template resources/custom fields
  81. Change post template the proper way
  82. Custom MySQL query to list post
  83. Post thats in Two Categories, only want to display name for one
  84. woocommerce display product category on checkout page [closed]
  85. Prevent posts from being published if the ‘Uncategorized’-category or no category is selected
  86. Save And Display Mp3 Audio files on WooCommerce product page with Dokan
  87. Advice how to connect custom database with WordPress, change data in WordPress and finaly use this data
  88. Show last child Child category instead of first child category on page
  89. wordpress categories narrow down results
  90. Modifying posts based on category in TwentyTwentyTwo theme
  91. Add custom information in editor summary
  92. How do register_sidebar() and get_sidebar() work together?
  93. WordPress custom post types breaks permalink on theme reinstall
  94. meta_compare seems to be treating values as strings instead of integers as expected
  95. Custom Behavior when Adding New Custom Post Type in Dashboard
  96. Implement a Walker with custom object rather than WordPress database object
  97. How do I make mysite.com/comingsoon WordPress to become my main website’s WordPress?
  98. Can we add an extra button on woocommerce shop page and use it to send the product info including image in a mail?
  99. Formating content in category.php
  100. Custom WordPress SQL Query 4 posts per custom taxonomy