{"id":519,"date":"2021-04-28T17:55:32","date_gmt":"2021-04-28T10:55:32","guid":{"rendered":"https:\/\/www.oarvoodoo.com\/?p=519"},"modified":"2021-04-28T17:58:21","modified_gmt":"2021-04-28T10:58:21","slug":"wordpress-query-multiple-meta-key","status":"publish","type":"post","link":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/","title":{"rendered":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27"},"content":{"rendered":"<p>SQL \u0e19\u0e35\u0e49 \u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a Query \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35 meta_key \u0e21\u0e32\u0e01\u0e27\u0e48\u0e32 1 <\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT\r\n  p.post_title,\r\n  pm1.meta_value,\r\n  pm2.meta_value\r\n\r\nFROM wp_posts as p\r\n\r\nINNER JOIN wp_postmeta as pm1\r\nON p.ID = pm1.post_id\r\n\r\nINNER JOIN wp_postmeta as pm2\r\nON p.ID = pm2.post_id\r\n\r\nWHERE\r\n  pm1.meta_key = '_my_postmeta_field1'\r\nAND\r\n  pm2.meta_key &lt;&gt; '_not_this_field'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL \u0e19\u0e35\u0e49 \u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a Query \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35 meta_key \u0e21\u0e32\u0e01\u0e27\u0e48\u0e32 1 SELECT p.post_title, pm1.meta_value, pm2.meta_value FROM wp_posts as p INNER JOIN wp_postmeta as pm1 ON p.ID = pm1.post_id INNER JOIN wp_postmeta as pm2 ON p.ID = pm2.post_id WHERE pm1.meta_key = &#8216;_my_postmeta_field1&#8217; AND pm2.meta_key &lt;&gt; &#8216;_not_this_field&#8217;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo<\/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:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo\" \/>\n<meta property=\"og:description\" content=\"SQL \u0e19\u0e35\u0e49 \u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a Query \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35 meta_key \u0e21\u0e32\u0e01\u0e27\u0e48\u0e32 1 SELECT p.post_title, pm1.meta_value, pm2.meta_value FROM wp_posts as p INNER JOIN wp_postmeta as pm1 ON p.ID = pm1.post_id INNER JOIN wp_postmeta as pm2 ON p.ID = pm2.post_id WHERE pm1.meta_key = &#039;_my_postmeta_field1&#039; AND pm2.meta_key &lt;&gt; &#039;_not_this_field&#039;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\" \/>\n<meta property=\"og:site_name\" content=\"oarvoodoo\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-28T10:55:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-28T10:58:21+00:00\" \/>\n<meta name=\"author\" content=\"oarvoodoo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"oarvoodoo\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\"},\"author\":{\"name\":\"oarvoodoo\",\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3\"},\"headline\":\"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27\",\"datePublished\":\"2021-04-28T10:55:32+00:00\",\"dateModified\":\"2021-04-28T10:58:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\"},\"wordCount\":65,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3\"},\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\",\"url\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\",\"name\":\"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo\",\"isPartOf\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#website\"},\"datePublished\":\"2021-04-28T10:55:32+00:00\",\"dateModified\":\"2021-04-28T10:58:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#website\",\"url\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/\",\"name\":\"oarvoodoo\",\"description\":\"\u0e40\u0e23\u0e35\u0e22\u0e01\u0e1c\u0e21\u0e27\u0e48\u0e32 \u0e19\u0e31\u0e01\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e1a\u0e49\u0e32\u0e19\u0e1a\u0e49\u0e32\u0e19\",\"publisher\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3\",\"name\":\"oarvoodoo\",\"logo\":{\"@id\":\"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo","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:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/","og_locale":"en_US","og_type":"article","og_title":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo","og_description":"SQL \u0e19\u0e35\u0e49 \u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a Query \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35 meta_key \u0e21\u0e32\u0e01\u0e27\u0e48\u0e32 1 SELECT p.post_title, pm1.meta_value, pm2.meta_value FROM wp_posts as p INNER JOIN wp_postmeta as pm1 ON p.ID = pm1.post_id INNER JOIN wp_postmeta as pm2 ON p.ID = pm2.post_id WHERE pm1.meta_key = '_my_postmeta_field1' AND pm2.meta_key &lt;&gt; '_not_this_field'","og_url":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/","og_site_name":"oarvoodoo","article_published_time":"2021-04-28T10:55:32+00:00","article_modified_time":"2021-04-28T10:58:21+00:00","author":"oarvoodoo","twitter_card":"summary_large_image","twitter_misc":{"Written by":"oarvoodoo"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#article","isPartOf":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/"},"author":{"name":"oarvoodoo","@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3"},"headline":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27","datePublished":"2021-04-28T10:55:32+00:00","dateModified":"2021-04-28T10:58:21+00:00","mainEntityOfPage":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/"},"wordCount":65,"commentCount":0,"publisher":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3"},"articleSection":["WordPress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/","url":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/","name":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27 - oarvoodoo","isPartOf":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#website"},"datePublished":"2021-04-28T10:55:32+00:00","dateModified":"2021-04-28T10:58:21+00:00","breadcrumb":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wordpress\/wordpress-query-multiple-meta-key\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/happykhun.com\/clients\/oarvoodoo\/"},{"@type":"ListItem","position":2,"name":"WordPress Query \u0e01\u0e23\u0e13\u0e35 meta_key 2 \u0e15\u0e31\u0e27"}]},{"@type":"WebSite","@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#website","url":"https:\/\/happykhun.com\/clients\/oarvoodoo\/","name":"oarvoodoo","description":"\u0e40\u0e23\u0e35\u0e22\u0e01\u0e1c\u0e21\u0e27\u0e48\u0e32 \u0e19\u0e31\u0e01\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e1a\u0e49\u0e32\u0e19\u0e1a\u0e49\u0e32\u0e19","publisher":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/happykhun.com\/clients\/oarvoodoo\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/49c467e9be26f8eb0a94ab4a18cacdd3","name":"oarvoodoo","logo":{"@id":"https:\/\/happykhun.com\/clients\/oarvoodoo\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/posts\/519"}],"collection":[{"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/comments?post=519"}],"version-history":[{"count":5,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/posts\/519\/revisions"}],"predecessor-version":[{"id":524,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/posts\/519\/revisions\/524"}],"wp:attachment":[{"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/categories?post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/happykhun.com\/clients\/oarvoodoo\/wp-json\/wp\/v2\/tags?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}