\u00a1Hola!<\/p>\n
Tengo que implementar los posts de una categoria (tanto los orginales como las revisiones) de un blog en otra web que no est\u00e1 hecha en WordPress. He conseguido hacer la consulta SQL que me extrae los posts de una categoria pero no consigo extraer las revisiones o post \u00abhijo\u00bb de una entrada determinada. A parte de inhabilitar las revisiones, \u00bfalguna idea?<\/p>\n
La consulta es algo as\u00ed:<\/p>\n
Y despu\u00e9s he probado esto:<\/p>\n Gracias!<\/p>\n","protected":false},"template":"","class_list":["post-38615","topic","type-topic","status-closed","hentry","topic-tag-categorias","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/es.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/38615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/es.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/es.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/es.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/38615\/revisions"}],"wp:attachment":[{"href":"https:\/\/es.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=38615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nSELECT ID,wp_posts.post_title,wp_posts.post_date,wp_posts.guid FROM wp_term_relationships
\nINNER JOIN wp_posts ON ID = wp_term_relationships.object_id
\nWHERE wp_term_relationships.term_taxonomy_id = '386'
\nAND post_status='publish'
\nAND post_type='post'
\nORDER BY post_date
\nDESC LIMIT 1
\n<\/code><\/p>\n
\nSELECT ID,wp_posts.post_title,wp_posts.post_date,wp_posts.guid FROM wp_posts
\nINNER JOIN wp_term_relationships
\nWHERE\t\t\t\t\t\t\t\t post_status='publish'
\nAND post_type='post'
\nAND wp_term_relationships.term_taxonomy_id ='386'
\nOR
\npost_status='inherit'
\nAND post_type='revision'
\nAND post_parent=ID
\nAND wp_term_relationships.term_taxonomy_id = '386'
\nGROUP BY (ID)
\nORDER BY post_date
\nDESC LIMIT 5
\n<\/code><\/p>\n