此查询提取帖子id、标题、永久链接和焦点关键字。如果需要的话，您可以修改它来获取文章的元描述和标题。如果要提取页面，请将post\\U类型更改为page。

SELECT wpp.post_title, wpp.ID, wpp.post_date, mt1.meta_value as focus_keyword,
       REPLACE( REPLACE( REPLACE( REPLACE( wpo.option_value, \'%year%\', DATE_FORMAT(wpp.post_date,\'%Y\') ), \'%monthnum%\', DATE_FORMAT(wpp.post_date, \'%m\') ), \'%day%\', DATE_FORMAT(wpp.post_date, \'%d\') ), \'%postname%\', wpp.post_name ) AS permalink
  FROM wp_posts wpp
  LEFT JOIN wp_postmeta AS mt1 ON (wpp.ID = mt1.post_id AND mt1.meta_key=\'_yoast_wpseo_focuskw\')
  JOIN wp_options wpo
    ON wpo.option_name = \'permalink_structure\'
 WHERE wpp.post_type = \'post\'
   AND wpp.post_status = \'publish\'
 ORDER BY wpp.post_date DESC;