{"id":16245050,"date":"2022-11-29T15:46:48","date_gmt":"2022-11-29T15:46:48","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/join\/"},"modified":"2022-11-29T15:46:48","modified_gmt":"2022-11-29T15:46:48","slug":"join","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/join\/","title":{"rendered":"JOIN"},"content":{"rendered":"<p>I&#8217;m having a problem creating a query using an INNER JOIN.<\/p>\n<p>Accessing the WP database using MyPHP I can run the followig query:<\/p>\n<pre><code>SELECT wp_terms.term_id,\n\t   wp_terms.slug\t   \nFROM wp_terms\nINNER JOIN wp_term_taxonomy USING (term_id)\nwhere wp_term_taxonomy.taxonomy=&#039;nav_menu&#039;;<\/code><\/pre>\n<p>And it runs successfully and returns a list of Menus<br \/>\nUnfortunately when I try and run it in Query Builder it just gives me a blank screen with the date and time.<\/p>\n<p>Any help would be much appreciated.<\/p>\n<p>I am using the free version of WP Data Access<\/p>\n","protected":false},"template":"","class_list":["post-16245050","topic","type-topic","status-publish","hentry","topic-tag-join","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16245050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16245050\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16245050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}