[WordPress Sample SQL Queries] #WordPress #sql

sample.sql

# WordPress 記事タイトル/アイキャッチ画像のID を表示
select
  a.id 'ID',
  a.post_title 'タイトル',
  c.guid 'アイキャッチ URL'
from
  (select * from wpgh_posts
     where post_type in ('post','page','lesson')
       and post_status='publish') a
  left outer join wpgh_postmeta b
    on a.id = b.post_id and meta_key = '_thumbnail_id'
  left outer join wpgh_posts c
    on b.meta_value = c.id
order by a.id

 in (17186,16843,17185)