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. SQL query based on two different custom field values
  60. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  61. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  62. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  63. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  64. ORA-00904: invalid identifier
  65. Self Join to get employee manager name
  66. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  67. What is “Advanced” SQL?
  68. Why do we need “Relationships” between tables at all?
  69. Case statement in MySQL
  70. How to update multiple columns in single update statement in DB2
  71. How do I restore a dump file from mysqldump?
  72. TypeError: tuple indices must be integers, not str
  73. What is the difference between JOIN and UNION?
  74. Error Code: 2013. Lost connection to MySQL server during query
  75. how to drop partition without dropping data in MySQL?
  76. 1052: Column ‘id’ in field list is ambiguous
  77. 1052: Column ‘id’ in field list is ambiguous
  78. difference between primary key and unique key
  79. Creating a search form in PHP to search a database?
  80. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  81. What is it exactly a BLOB in a DBMS context
  82. Oracle SQL query for Date format
  83. What is difference between SQLite and SQL
  84. The backend version is not supported to design database diagrams or tables
  85. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  86. Postgres Error: More than one row returned by a subquery used as an expression
  87. How do I reset a sequence in Oracle?
  88. MySQL equivalent of DECODE function in Oracle
  89. what is the difference between triggers, assertions and checks (in database)
  90. How to do a batch insert in MySQL
  91. Solutions for INSERT OR UPDATE on SQL Server
  92. “select * into table” Will it work for inserting data into existing table
  93. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  94. Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
  95. WP_Query – Order results by meta value
  96. Add filter menu to admin list of posts (of custom type) to filter posts by custom field values
  97. getting all values for a custom field key (cross-post)
  98. How to add a custom field in the advanced menu properties?
  99. Custom query with orderby meta_value of custom field
  100. How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)