{"id":2763,"date":"2005-12-06T02:31:33","date_gmt":"2005-12-06T06:31:33","guid":{"rendered":"http:\/\/timesandseasons.org\/?p=2763"},"modified":"2005-12-06T11:06:21","modified_gmt":"2005-12-06T15:06:21","slug":"yet-another-tech-support-bleg","status":"publish","type":"post","link":"https:\/\/timesandseasons.org\/index.php\/2005\/12\/yet-another-tech-support-bleg\/","title":{"rendered":"Yet another tech support bleg"},"content":{"rendered":"

An SQL problem of sorts has arisen, that is beyond our limited capabilities<\/del>. Bryce to the rescue, once again. I say we double his T&S salary.<\/p>\n

POST FORMERLY READ:<\/p>\n

We have a recent comments plugin. It works. (Horray!)<\/p>\n

It doesn’t have the capability of pulling comments by category type. In fact, I’ve scoured the net, but no such plugin exists at the moment (despite some false advertising). So I’m creating one, based on the other plugin. So far so good.<\/p>\n

It’s a two step process, which should in theory be simple enough. <\/p>\n

First, we collect all posts from category 62:<\/p>\n

SQL query:
\nSELECT post_id FROM wp_post2cat WHERE category_id = ’62’<\/p><\/blockquote>\n

(That query works, by the way).<\/p>\n

The next step will be to somehow merge that query into the existing plugin’s current query for pulling comments, which itself pulls data from two other tables. I’d like to get that same data, but only for posts that match the category check.<\/em> <\/p>\n

The query on the plugin as it now stands — pulling comments without regard to category — is this: <\/p>\n

function get_bushman_comments () {
\n global $wpdb, $tablecomments, $tableposts;
\n $request = “SELECT ID, comment_ID, comment_content, comment_author, post_title, FROM $tablecomments LEFT JOIN $tableposts ON $tableposts.ID=$tablecomments.comment_post_ID WHERE post_status = ‘publish'”;<\/p><\/blockquote>\n

How can I add the prior query (pulling posts in category 62) to that, in order to limit the second query to getting data from those posts that come from the first query? (Does that question make sense?) Is there a good way to combine these two queries? (Or some other obvious, easy solution that I’m missing?) Glory, fame<\/a>, and lucre<\/del> await the savvy bloggernacker who comes up with a working query.<\/p>\n

(Can’t Kaimi figure this out himself? We’ll just say that one or two blog-rattling attempts later, Kaimi decided that playing with SQL on a loaded blog is not a good idea. After all, we ain’t too proud to bleg; discretion is the better part of valor; he who fights and runs away; etc., etc.)<\/p>\n

Muchas gracias. <\/p>\n","protected":false},"excerpt":{"rendered":"

An SQL problem of sorts has arisen, that is beyond our limited capabilities. Bryce to the rescue, once again. I say we double his T&S salary.<\/p>\n","protected":false},"author":30,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2763","post","type-post","status-publish","format-standard","hentry","category-corn"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/posts\/2763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/comments?post=2763"}],"version-history":[{"count":0,"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/posts\/2763\/revisions"}],"wp:attachment":[{"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/media?parent=2763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/categories?post=2763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timesandseasons.org\/index.php\/wp-json\/wp\/v2\/tags?post=2763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}