i have this command to get all post id of my wordpress site :
SELECT post_id
FROM `wp_postmeta`
WHERE `meta_key` LIKE 'imdbID'
and i want to get all post id that are NOT in this 3 command :
SELECT post_id
FROM `wp_postmeta`
WHERE `meta_key` LIKE '720-link' AND `meta_value` LIKE '%/%'
SELECT post_id
FROM `wp_postmeta`
WHERE `meta_key` LIKE 'linkDVD' AND `meta_value` LIKE '%/%'
SELECT ID
FROM `wp_posts`
WHERE `post_title` LIKE '%سر%' AND `post_status` LIKE 'publish'
AND `post_type` LIKE 'post'
how can i find it ?
Aucun commentaire:
Enregistrer un commentaire