{"id":2662,"date":"2015-12-19T07:21:45","date_gmt":"2015-12-19T07:21:45","guid":{"rendered":"http:\/\/musilda.cz\/?p=2662"},"modified":"2015-12-19T07:21:45","modified_gmt":"2015-12-19T07:21:45","slug":"jak-ziskat-vsechny-posty-ktere-nemaji-konkretni-custom-field","status":"publish","type":"post","link":"https:\/\/affinite.io\/cs\/jak-ziskat-vsechny-posty-ktere-nemaji-konkretni-custom-field\/","title":{"rendered":"Jak z\u00edskat v\u0161echny posty, kter\u00e9 nemaj\u00ed konkr\u00e9tn\u00ed custom field"},"content":{"rendered":"

Toto je op\u011bt jeden z t\u011bch snippet\u016f, kter\u00e9 si zapisuji, pro budouc\u00ed pou\u017eit\u00ed. Konkr\u00e9tn\u011b se jedn\u00e1 o v\u00fdpis v\u0161ech produkt\u016f ve Woocommerce, kter\u00e9 nemaj\u00ed n\u00e1hledov\u00fd obr\u00e1zek.<\/p>\n

Z n\u011bjak\u00e9ho d\u016fvodu jsem pomoc\u00ed WP_Query, nedostal v\u0161echny produkty, argument posts_per_page nefungoval.<\/p>\n

Tak\u017ee, pokud chcete z\u00edskat v\u0161echny produkty\/posty, kter\u00e9 nemaj\u00ed ur\u010dit\u00fd custom field, tak toto funguje bezpe\u010dn\u011b:<\/p>\n

\n$querystr = \"\n\tSELECT ID FROM $wpdb->posts\n\tWHERE $wpdb->posts.ID NOT IN  (\n\t\tSELECT post_id FROM $wpdb->postmeta\n\t\tWHERE ($wpdb->postmeta.post_id = $wpdb->posts.ID)\n\t\tAND meta_key = '_thumbnail_id'\n\t\t)\n\tAND (post_status = 'publish')\n\tAND post_type = 'product'\n\tORDER BY post_date DESC\n\";\n$products = $wpdb->get_results( $querystr );\n<\/pre>\n

V p\u0159\u00edpad\u011b, \u017ee pot\u0159ebujete kontrolovat neexistenci jin\u00e9ho custom fieldu, zam\u011b\u0148te _thumbnail_id a p\u0159\u00edpadn\u011b zm\u011b\u0148te post_type.<\/p>\n","protected":false},"excerpt":{"rendered":"

Toto je op\u011bt jeden z t\u011bch snippet\u016f, kter\u00e9 si zapisuji, pro budouc\u00ed pou\u017eit\u00ed. Konkr\u00e9tn\u011b se jedn\u00e1 o v\u00fdpis v\u0161ech produkt\u016f ve Woocommerce, kter\u00e9 nemaj\u00ed n\u00e1hledov\u00fd obr\u00e1zek. Z n\u011bjak\u00e9ho d\u016fvodu jsem pomoc\u00ed WP_Query, nedostal v\u0161echny produkty, argument posts_per_page nefungoval. Tak\u017ee, pokud chcete z\u00edskat v\u0161echny produkty\/posty, kter\u00e9 nemaj\u00ed ur\u010dit\u00fd custom field, tak toto funguje bezpe\u010dn\u011b: $querystr =<\/p>\n","protected":false},"author":1,"featured_media":2635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[546],"class_list":["post-2662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-snippety","tag-wp_query"],"_links":{"self":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/2662"}],"collection":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/comments?post=2662"}],"version-history":[{"count":0,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/2662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media\/2635"}],"wp:attachment":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media?parent=2662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/categories?post=2662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/tags?post=2662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}