选择query获取metakey的结果 - select query to get results of meta_key

select query to get results of meta_key

本文关键字：结果 metakey 获取 query 选择 | 更新日期: 2023-09-27

我有一个自定义字段名"front_sl_slider"。我想显示所有自定义字段"front_sl_slider"值设置为1的帖子。此外，我想为我的查询结果得到的帖子显示、缩略图、标题和其他自定义字段数据。

$meta_pages = $wpdb->get_results("SELECT *    FROM $wpdb->posts WHERE  post_type = 'page' AND  meta_key = 'front_sl_slider' AND meta_value = 1 ORDER BY menu_order", 'OBJECT'); 
    if ( $meta_pages ) 
        {
        foreach ( $meta_pages as $pageChild1 ) : setup_postdata( $pageChild1 );
         echo get_post_meta($pageChild1->ID, 'front_sl_slider', true);
         echo get_post_meta($pageChild1->ID, 'project_client_name', true) ."<br>";
         echo get_post_meta($pageChild1->ID, 'project_architect', true) ."<br>"; 
        endforeach; 
        }

$querystr = "   SELECT $wpdb->posts.* , $wpdb->postmeta.*
                        FROM $wpdb->posts, $wpdb->postmeta
                        WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id 
                        AND $wpdb->postmeta.meta_key = 'Featured_Projects_Page' 
                        AND $wpdb->postmeta.meta_value = 1 
                        AND $wpdb->posts.post_type = 'page'
                        ORDER BY $wpdb->posts.post_date DESC
                     ";
$pageposts = $wpdb->get_results($querystr, OBJECT);

试试这个，这个应该有效。