{"id":25663,"date":"2022-12-11T15:59:55","date_gmt":"2022-12-11T10:29:55","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/"},"modified":"2022-12-11T15:59:55","modified_gmt":"2022-12-11T10:29:55","slug":"solved-understanding-wordpress-database-schema-querying-from-3rd-party-app","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/","title":{"rendered":"[Solved] Understanding WordPress database schema – querying from 3rd party app"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

You’re looking for all posts where post_status = publish and post_type = post.<\/p>\n

The WordPress posts table also includes pages, revisions, and attachments … that’s why you need to be specific.<\/p>\n

If you’re using the default database scheme (with wp_<\/code> as a table prefix), the following query will give you what you need:<\/p>\n

SELECT post_title FROM wp_posts WHERE post_status=\"publish\" AND post_type=\"post\" ORDER BY post_date DESC<\/code><\/p>\n

This will give you a list of the most recent headlines (post titles) of published<\/em> posts ordered by date (with the most recent at the top). No need to import any core WordPress libraries. Just make sure not to accidentally tweak the database while accessing it directly or you might break something in WordPress.<\/p>\n<\/p><\/div>\n

<\/div>\n<\/div>\n

1<\/span> <\/p><\/div>\n<\/div>\n

[ad_2]<\/p>\n

solved Understanding WordPress database schema – querying from 3rd party app <\/p>\n","protected":false},"excerpt":{"rendered":"

[ad_1] You’re looking for all posts where post_status = publish and post_type = post. The WordPress posts table also includes pages, revisions, and attachments … that’s why you need to be specific. If you’re using the default database scheme (with wp_ as a table prefix), the following query will give you what you need: SELECT … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[597],"class_list":["post-25663","post","type-post","status-publish","format-standard","hentry","category-solved","tag-wordpress"],"yoast_head":"\n[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You’re looking for all posts where post_status = publish and post_type = post. The WordPress posts table also includes pages, revisions, and attachments … that’s why you need to be specific. If you’re using the default database scheme (with wp_ as a table prefix), the following query will give you what you need: SELECT ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-11T10:29:55+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Understanding WordPress database schema – querying from 3rd party app\",\"datePublished\":\"2022-12-11T10:29:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/\"},\"wordCount\":132,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"keywords\":[\"wordpress\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/\",\"name\":\"[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"datePublished\":\"2022-12-11T10:29:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Understanding WordPress database schema – querying from 3rd party app\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb","og_description":"[ad_1] You’re looking for all posts where post_status = publish and post_type = post. The WordPress posts table also includes pages, revisions, and attachments … that’s why you need to be specific. If you’re using the default database scheme (with wp_ as a table prefix), the following query will give you what you need: SELECT ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/","og_site_name":"JassWeb","article_published_time":"2022-12-11T10:29:55+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Understanding WordPress database schema – querying from 3rd party app","datePublished":"2022-12-11T10:29:55+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/"},"wordCount":132,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["wordpress"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/","url":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/","name":"[Solved] Understanding Wordpress database schema - querying from 3rd party app - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-11T10:29:55+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-understanding-wordpress-database-schema-querying-from-3rd-party-app\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Understanding WordPress database schema – querying from 3rd party app"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=25663"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25663\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=25663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=25663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=25663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}