我目前正致力于在我的Wordpress数据库中重新索引自定义表 . 我成功地收集数据值,但是我正在努力收集所有 $wpdb->terms .
某些帖子有多个与之关联的术语,例如我有自定义帖子类型( stores ),并且在此自定义分类法( products-sold )中,在此自定义分类法中,我有4个术语列表( Term A, Term B, Term C, Term D ) .
我已经设法用新的数据库填充所需的信息,除了Colomn“post_terms”,第一个术语被添加但我需要添加其他相关的术语(如果它们存在),以便单元格显示每个slug分隔一个逗号(slug) -A,slug-B) .
$sql = "";
$sql .= "INSERT INTO $this->tablename (`post_id`, `post_type`, `post_terms`, `lat`, `lng`) ";
$sql .= "SELECT * FROM (";
$sql .= "
SELECT
`$wpdb->posts`.`ID` AS `post_id`,
`$wpdb->posts`.`post_type`,
`$wpdb->terms`.`slug` AS `post_terms`,
`lat_field`.`meta_value` AS `lat`,
`lng_field`.`meta_value` AS `lng`
FROM
`$wpdb->posts`
INNER JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
INNER JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
INNER JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
LEFT JOIN `$wpdb->postmeta` AS `lat_field` ON (`$wpdb->posts`.`ID` = `lat_field`.`post_id` AND `lat_field`.`meta_key` IN ('".implode('\', \'',$this->keys['lat'])."'))
LEFT JOIN `$wpdb->postmeta` AS `lng_field` ON (`$wpdb->posts`.`ID` = `lng_field`.`post_id` AND `lng_field`.`meta_key` IN ('".implode('\', \'',$this->keys['lng'])."'))
WHERE `$wpdb->posts`.`post_status` = 'publish' AND (`lat_field`.`meta_value` IS NOT NULL OR `lng_field`.`meta_value` IS NOT NULL) AND " . $wpdb->term_taxonomy . ".taxonomy = 'products-sold'
";
$sql .= ") AS `t`";
$sql .= " ON DUPLICATE KEY UPDATE `lat` = VALUES(`lat`), `lng` = VALUES(`lng`)";
$wpdb->query($sql);
这是我上面的工作代码,任何帮助将不胜感激 .
1 回答
没有时间长时间,恼怒的回答....
你想要:
GROUP_CONCAT(
slug
,',')并添加GROUP BY
post_id
这将显示为行连接的所有slugs并用逗号分隔 . 这些slu will将匹配并在post_id上分组 . 每个结果应该有一个不同的post_id实体 .