如果帖子是粘性的,我正在尝试使用自定义查询从数据库中获取特定的帖子信息。
下面是查询:
"SELECT ID, post_title, post_author, post_date, option_value
FROM `{$wpdb->prefix}posts`, `{$wpdb->prefix}options`
WHERE post_status = 'publish' AND post_type = 'post'
AND option_name = 'sticky_posts'
ORDER BY post_date DESC LIMIT 2"
但是此查询不起作用。它返回两个帖子,但不返回粘性帖子。
Ok 想通了。
我需要使用此代码并使用AND ID IN ($stringSticky)
检查 id:
$sticky = get_option( 'sticky_posts' );
$stringSticky = implode(",", $sticky);
$mostLatestPostsSticky = $wpdb->get_results(
"SELECT ID, post_title, post_author, post_date
FROM `{$wpdb->prefix}posts`
WHERE post_status = 'publish' AND post_type = 'post'
AND ID IN ($stringSticky)
ORDER BY post_date DESC LIMIT $postlimit"
);