wordpress查询的MariaDB SQL错误

Question

 // Check if there is posts before our $date
    $postA =$wpdb->get_row("
SELECT ID, post_date 
FROM {$wpdb->prefix}posts 
LEFT JOIN $wpdb->term_relationships ON
($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON
($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE   $wpdb->posts.post_status = IN ('publish', 'future')
AND $wpdb->posts.post_type = 'post'
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->term_taxonomy.term_id = 18
AND $wpdb->posts.post_date <'{$date}' ORDER BY post_date DESC LIMIT 1");

Answer 1

此语法错误

在第7行的'in('publish')和wp_posts.post_type='post‘和wp_term_taxonomy.taxonomy='附近使用的语法]

将提述本部分：

WHERE   $wpdb->posts.post_status = IN ('publish', 'future')
AND $wpdb->posts.post_type = 'post'
AND $wpdb->term_taxonomy.taxonomy = 'category'

WHERE IN ('publish') AND wp_posts.post_type = 'post' AND wp_term_taxonomy.taxonomy 

WHERE wp_posts.post_status IN('publish')