对post和post_meta wordpress数据库的特殊要求

Question

你能帮我请求所有的附件帖子(图片)在wordpress wp_posts表上谁没有与meta_key="_wp_attachment_image_alt“的wp_post_meta表相关的行。

如下所示：

SELECT * FROM `wp_posts` as post
left join `wp_postmeta` as meta ON post.ID = meta.post_id
WHERE `post_type`='attachment' AND (***no line on wp_metapost with meta_key="_wp_attachment_image_alt"***)

谢谢..。

Answer 1

这对你来说应该是可行的

global $wpdb;
$sql_query = $wpdb->prepare(
    "SELECT * FROM $wpdb->posts as post
    LEFT JOIN $wpdb->postmeta as meta ON post.ID = meta.post_id
    WHERE $wpdb->posts.post_type = 'attachment'
    AND
    (
        $wpdb->postmeta.meta_key = '_wp_attachment_image_alt'
        AND $wpdb->postmeta.meta_value != ''
        AND $wpdb->postmeta.meta_value IS NOT NULL
    )"
);

print_r($sql_query);