mysql - 没有 wp 函数的 WordPress 自定义元查询 (wo.wp_query())

Question

我必须在没有 wp_query 的情况下从 WordPress 数据库中获取标题、描述和附件。我不知道如何同时获取附件和元描述...

这就是我的查询到目前为止的样子

$query="SELECT post_title, meta_value 
FROM wp_posts p JOIN wp_postmeta pm ON p.ID=pm.post_id 
WHERE post_status='publish' 
AND post_type='page' 
AND post_parent=2330 
AND ( meta_key='_wpseo_edit_description' OR meta_key='_wp_attached_file' ) 
ORDER BY post_date DESC";

此查询返回“双倍”结果，我必须在循环内拆分

______________________________
| post_title | meta_value    |
|------------|---------------|
|  title 1   | 1349          |
|------------|---------------|
|  title 1   | description 1 |
|------------|---------------|
|  title 2   | 1348          |
|------------|---------------|
|  title 2   | description 2 |
|____________|_______________|

Answer 1

您需要加入 wp_postmeta 表才能获取任何附加信息，例如文件附件或自定义字段。

如何执行此操作的示例:

SELECT p.*, pm2.meta_value AS featured_image, pm3.meta_value AS wpseo_edit_description, pm4.meta_value AS wp_attached_file
FROM `wp_posts` p
LEFT JOIN `wp_postmeta` pm2 ON p.ID = pm2.post_id AND pm2.meta_key = 'wp_attached_file'
LEFT JOIN `wp_postmeta` pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_wpseo_edit_description'
LEFT JOIN `wp_postmeta` pm4 ON p.ID = pm4.post_id AND pm4.meta_key = '_wp_attached_file'
WHERE p.post_status = 'publish' 
AND p.post_type = 'page' 
AND p.post_parent = 2330 

然后，普通帖子字段(帖子标题、描述、ID 等)将可用，以及 featured_image、wp_attached_file 和 wpseo_edit_description .