Question

我试图将这两个问题合并起来,但我不会像我的我的那么热。我怀疑我需要使用<条码>NER JOIN或子座?

我试图把一种习俗的分类与一种假想结合起来。 gin本要求我与我的文稿数据库库一起查阅。 The query from the plugin:

SELECT p.*
FROM {$wpdb->prefix}most_popular mp
INNER JOIN {$wpdb->prefix}posts p ON mp.post_id = p.ID
WHERE
    p.post_type =  %s  AND
    p.post_status =  publish 
{$order}
LIMIT %d

这是一个由我分类的过滤内容的问题。

SELECT SQL_CALC_FOUND_ROWS  wp_posts.* 
FROM wp_posts  
INNER JOIN wp_term_relationships 
ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1  
    AND ( wp_term_relationships.term_taxonomy_id IN (38) ) 
    AND wp_posts.post_type =  post  
    AND (wp_posts.post_status =  publish ) 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_date 
DESC LIMIT 0, 10

我应怎样把所有这一切合并为一个问题?

Answer 1

SELECT p.*, wpt.*
FROM (SELECT * FROM {$wpdb->prefix}terms AS wpt1 WHERE wpt1.name= $loc  LIMIT 1) AS wpt
    , {$wpdb->prefix}most_popular AS mp
INNER JOIN {$wpdb->prefix}term_relationships wptr ON (mp.post_id = wptr.object_id) 
INNER JOIN {$wpdb->prefix}posts p ON mp.post_id = p.ID
WHERE 1=1
    AND ( wptr.term_taxonomy_id = wpt.term_id )
    AND p.post_type =  %s 
    AND p.post_status =  publish 
{$order}
LIMIT %d

可能很奇怪,但它运作良好。

友情链接