{"id":6109,"date":"2021-02-18T13:18:26","date_gmt":"2021-02-18T04:18:26","guid":{"rendered":"https:\/\/nsme.red\/wp\/?p=6109"},"modified":"2021-02-18T13:19:44","modified_gmt":"2021-02-18T04:19:44","slug":"count-%e6%9d%a1%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/search\/6109\/","title":{"rendered":"COUNT \u6761\u4ef6"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT baitai, count(*) as count, \ncount(status IN ('\u672a\u5b9a' , '\u5f15\u7d99\u4e2d')\u3000or null) as count2\n FROM wp_saiyou WHERE 1 GROUP BY baitai ORDER BY count DESC<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">COUNT \u306e\u6761\u4ef6\u304c\u4e00\u3064\u306e\u5834\u5408\u306f\u3001\ncount(status = '\u672a\u5b9a'  or null)\n\u6761\u4ef6\u306b\u3042\u3063\u305f\u3082\u306e\u306f\u4e00\u3064\u3068\u3057\u3066\u30ab\u30a6\u30f3\u30c8\u3057\u3001\u4ee5\u5916\u306e\u3082\u306e\u306fnull<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>COUNT \u306e\u6761\u4ef6\u304c\u4e00\u3064\u306e\u5834\u5408\u306f\u3001 count(status = &#8216;\u672a\u5b9a&#8217; or null) \u6761\u4ef6\u306b\u3042\u3063\u305f\u3082\u306e\u306f\u4e00\u3064\u3068\u3057\u3066\u30ab\u30a6\u30f3\u30c8\u3057\u3001\u4ee5\u5916\u306e\u3082\u306e\u306fnull<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-6109","post","type-post","status-publish","format-standard","hentry","category-search"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=6109"}],"version-history":[{"count":2,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6109\/revisions"}],"predecessor-version":[{"id":6111,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6109\/revisions\/6111"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=6109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=6109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=6109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}