Get all posts that do not have a specific custom field without using a subquery

This is the way WordPress does it:

SELECT wp_posts.* FROM wp_posts
LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'custom_field' )
WHERE wp_postmeta.post_id IS NULL

You can do this with WP_Query meta_query and 'compare' => 'NOT EXISTS'.

Related Posts:

  1. SQL Query to copy value of a meta_key into another meta_key
  2. How to correctly call custom field dates into a posts_where filter using SQL statements
  3. Add custom fields to search
  4. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  5. How to rename a custom field?
  6. So much data in postmeta
  7. What is the advantage of the wp_options design pattern?
  8. Remove old custom field after import
  9. Edit Custom Database Tables in WordPress
  10. importing data from non-wordpress mysql db
  11. How to delete custom field “suggestions” from dropdown list
  12. Bulk move (or copy) from a custom field to the post content?
  13. Up/Down voting system for WordPress
  14. Custom Fields Bulk Edit
  15. Register new user and add custom data row value for it
  16. After moving my site from a dev subdomain, to root, all my custom meta data is gone
  17. Front-end update_post_meta with ajax
  18. Advice needed for importing custom field data and database structure
  19. Leader board for game on homepage
  20. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  21. Default WordPress taxonomy (Tag) – How to add a custom field to form and save it to the database
  22. Separate table or usermeta
  23. Custom User Profile Fields
  24. Order query by meta_value with multiple custom fields
  25. Custom fields not getting saved in the databse when added to the add new user profile page
  26. Custom Field Create Bulk via SQL Query
  27. Is there any way to get all meta and standard columns for any WordPress object after searching based on meta key and value
  28. Is there a better way to list all database terms alphabetically?
  29. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  30. Linking Custom Fields to Database Records
  31. How to populate custom field dropdown box based on prior selection?
  32. Meta Query And/Or
  33. When creating a metabox do you have to create DB fields for the data?
  34. Limit of char count in WP custom fields
  35. Adding custom field and querying from post table
  36. How to copy data from a custom field to the post_content?
  37. Diamond question mark in text after migrating content
  38. Get emails from users by custom field SQL
  39. How do I convert all custom_field php timestamps in the database to js timestamps?
  40. SQL: Select wordpress posts with given text string and add a custom field to them?
  41. Show array of meta_value in Edit Post Coloum
  42. Getting and calculating averge value of custom fields of the same tag
  43. How To Save Data From Remote APIs To ACF?
  44. Change word in woocommerce product category custom field
  45. SQL query to change the value of a Custom Field
  46. searching by keywords in post’s metas or pagination links problem
  47. Retrieving and inserting data in custom fields
  48. I have a form with a custom button ,i want to add the field data to an database when clicking the custom button
  49. update_user_meta(): invisible data storage
  50. Populate a select box with data stored in the database?
  51. Updating custom fields with external data
  52. Convert all dates in field to Unix time, except those already in Unix time
  53. query specific posts according their custom fields, using sql SELECT
  54. Download stuff after filling fields?
  55. Alter SQL query to return posts with unique custom field value, no duplicate values
  56. Update field name without losing the value
  57. Website that sells statistics
  58. How to create a searchable database with a single-field search box at the front end? [closed]
  59. Custom field/meta populated by dropdown of existing posts?
  60. What is the index [0] for on post meta fields?
  61. Pass all custom fields through the same filter on post load?
  62. update_user_meta: How many is too many?
  63. Search ONLY by meta key / meta values
  64. Correct Approach for Validating Custom Field Input
  65. Query meta field using between
  66. Delete post based on a custom field?
  67. How to make custom comment fields required and message field not required
  68. Update meta values with AJAX
  69. How can I migrate all of my custom field thumbnails to the built-in post featured image?
  70. Multiplile values checkbox or select in custom meta box
  71. How to use query_posts() with a date filter on a custom field?
  72. Escaping Quotes
  73. wp_editor removes paragraph from custom meta box
  74. Any way to include custom fields in WP_Query results?
  75. How to validate custom field on lost password form before the user id field?
  76. Woocommerce: Custom fields and email shortcodes, ec_custom_field
  77. Tweak Meta for Post to work it for Pages also
  78. Adding an editable field to template?
  79. Transferring author information from a custom field to a proper author
  80. How to select posts from multiple categories and metavalues?
  81. Shortcode To Display Post Custom Field Value in Post Title, Post Content
  82. How to make a customized user registration form using the built in wp-register() template tag
  83. Link FROM attachment to full post and get custom fields values on attachment page?
  84. Custom field as featured image caption
  85. Add a custom field to my custom post type and then get posts which are before the given date in the custom field
  86. when looping through custom post data not appearing
  87. Custom Fields not working properly
  88. Custom meta POST request fired twice when updating a post in Gutenberg
  89. add meta box considers the selected option as post parent
  90. How do I display a custom field in an existing form on the front end?
  91. Extend WP_User_Query or WP_User to return all custom fields?
  92. Quicktag button to automatically add a custom field to a post
  93. Display custom fields only if it has a value
  94. WordPress taxonomy child image
  95. Create custom fields/meta data gender+country – radiobuttons and dropdown on register screen for these fields
  96. Add nofollow to custom field link and make domain exceptions?
  97. wordpress simple post multi rating with post_meta and user_meta
  98. Getting deleted users in database
  99. Custom registration form and custom field
  100. How can i put a custom field inside this php