2803media/Trouver les posts avec un meta_key qui n’existe pas

Created February 27, 2014 14:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/2803media/9251633.js"></script>
Save 2803media/9251633 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

Trouver les posts avec un meta_key qui n’existe pas

SELECT DISTINCT ID FROM wp_posts WHERE ID NOT IN (SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key='descriptionspin') AND post_status= 'publish' AND post_type='post'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment