Sql Update CPT from publish to draft and particular custom field

You’ll have to use JOIN to achieve this:

UPDATE wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id 
SET p.post_status="draft"
WHERE p.post_type="match" AND pm.meta_key = 'played' AND pm.meta_value = 0;

Related Posts:

  1. delete custom post based on custom field date
  2. 1 day after custom date change post status to draft
  3. How to import database table as custom post type and custom fields?
  4. Populate custom post type/custom fields from an external database
  5. Help Creating a Slideshow Custom Post Type with Custom Meta Boxes?
  6. Custom field values deleted when trashing custom post type
  7. Search multiple custom fields by using meta_query
  8. Custom Post Type – Taxonomy Dropdown Menu?
  9. How I check if the same post slug has not been used before publishing?
  10. How to sort a table of custom posts by column containing custom field
  11. Issue with saving custom post type when editor is removed
  12. convert Custom Fields Option-Values to Tags/Taxonomy
  13. Combine tax_query and meta_query in WP_Query
  14. Automatically Insert Custom Field on Custom Post Type Publish
  15. Display custom post types with custom date field value (before today) & order by custom date field
  16. How to have the right design for a custom post type without accessing themes
  17. How to add the post ID (or any other post data) to a Contact Form 7 mail?
  18. WordPress custom meta field for custom post not storing data
  19. Conditional regex in add_rewrite_rule() for specific query filters & pagination
  20. How to Duplicate (multiple meta box)?
  21. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  22. List all images from a single post meta value
  23. WP_Query: include custom post type only with specific meta value
  24. Is there a way to get a file URL from the relationship ACF field?
  25. Want to Add Custom Fields for Uploading video to WordPress Users from front end
  26. How can I dynamically add a post to a custom post type which uses a custom field?
  27. Custom Posts Types as Custom Fields
  28. Random image from tag/custom type on sidebar
  29. Query & Order posts by custom fields
  30. Set a maxlength for the title input in a custom post type
  31. Update Post Meta for a logged in user
  32. Problem querying Custom post type by custom fields
  33. Using custom field content as expression in IF statement [closed]
  34. ACF From & To Date Validations
  35. Query Multiple Custom Posts by Custom Fields
  36. Disable saving posts as draft (make all posts mandatory regardless of the post status)
  37. Woocommerce custom field search in custom post type [closed]
  38. Custom REST endpoints for a custom post type with custom fields
  39. Cross reference custom post types
  40. frontend image post uploader
  41. Show fields based on taxonomy selection in editor
  42. Permalinks: custom structure for taxonomy – tags?
  43. How to Get the title of a custom field?
  44. Create custom post with meta field with AJAX and the WordPress REST API
  45. How to customize work area / admin area in a custom post type without plugins?
  46. ACF in wordpress
  47. Creating custom post type with custom taxonomy and custom fields programatically
  48. delete_post_meta() for whole CPT / multiple posts?
  49. How to inherit field value from parent post into in child / sub post
  50. hide specific div on single.php [closed]
  51. How do you output an unknown number of images in a custom post type with desired markup?
  52. posttype and custom fields on multisite
  53. Custom Fields not showing up for custom post type
  54. Custom post type in Custom widget – $listItem
  55. Generating and downloading files with WP API
  56. New post from database
  57. Convert Custom Taxonomy Posts to Normal Posts
  58. Displaying information from custom field on custom post type
  59. Add a class to post_class if more than one post shares same meta_value_num
  60. Add a meta field to the list of results for a custom post type
  61. Order custom posts by taxonomy, then by meta_key
  62. Adding a Custom Field to be used by Posts 2 Posts
  63. How do I list a custom field and custom taxonomies for each result in a loop?
  64. Custom fields for post or terms which don’t update on post update
  65. order the meta query results by 2 custom fields
  66. ACF – Retrieve custom taxonomy from a relationship field
  67. how to skip a CPT element from the pager by custom field
  68. How to Print Title and Permalink of CPT Post behalf of Posts Meta Value with WP_Query
  69. Updating a custom post status after an expiry date rather than trashing it
  70. Meta query and compare “!=” not working as expected
  71. How to add dynamic fields on wordpress custom post type page in admin section
  72. How can I add a meta[] to my custom post type and search by term with the Rest API?
  73. Creating an archive page or simple template to list all values of a custom field of specific post type listing
  74. Problem with multi checkboxes value in metabox?
  75. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  76. Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
  77. sorting in wp query based on custom field value
  78. check_admin_referer not working in custom meta box for custom post type
  79. WordPress loop add heading before first of type
  80. How do i create user accounts from custom posts that have email addresses
  81. How to display all custom fields associated with a post type – IN THE ADMIN AREA?
  82. Best way to use Category & Custom Fields?
  83. How do I add custom fields to posts without having to manually add everytime I post?
  84. How to display custom post type ordered by a custom field date
  85. Setting a custom $query->query_vars[‘meta_key’] breaks the WordPress menu
  86. WP_Query and two custom fields returns no posts
  87. Is it good practice to search for custom posts based on custom field values?
  88. Custom post type with custom fields enabled, is there a way to set a default group of fileds?
  89. Storing/querying custom date data
  90. I want to split this into two functions
  91. Repeatable Custom Field for Media Upload
  92. How to store datetime from custom meta box so that it can be sorted by
  93. Custom Post type easy way for editors
  94. Adding a custom field after post title (ex.Example Title [30 Second Read])
  95. Send email on creation of custom post type and use get_post_meta()
  96. pre_get_posts causes Custom Posts appear under ‘Pages’ menu
  97. Assign a tag to custom post type using a query
  98. Post object GUID adding http:/
  99. WordPress does not show the custom fields box
  100. Query order by a numeric ACF field