Hi

I'm trying to get a table from a specific Category in WP. i.e. if this post has this category associated with it then display the result(s). If I remove the condition, I get a full list, but as soon as I add the condition I get the error. What am I doing wrong?

Cosmic - I was just looking at the site to see if you'd taken a look or not and there you were :-)

Thanks for the feedback. I got to the same point the other day - I could get it to filter for the post_name but not the post_taxonomy_post_tag or post_taxonomy_category. The is where my brain fried as why would it work for post_name and not the other ones!!!

Any thoughts?

Hi Aledsandar

After several hours of failure I decided to test your sandbox'd site and ended up with even more issues - see attached.

I've also set up a vanilla WP site for testing to eliminate any conflicts... but still haven't had a joy as of yet.

Any feedback is greatly appreciated.

Cheers
Glenn

By total randomness I think I've got a solution. It's to do with the location for the conditions using the wizard:

This works - 

SELECT posts_post.post_title AS post_post_title,
       post_taxonomy_category_tbl.name AS post_taxonomy_category
FROM _PPZ_posts AS posts_post
  INNER JOIN (SELECT name, object_id as id FROM _PPZ_terms AS post_taxonomy_category_tbl_terms INNER JOIN _PPZ_term_taxonomy AS post_taxonomy_category_tbl_termtaxonomy ON post_taxonomy_category_tbl_termtaxonomy.term_id = post_taxonomy_category_tbl_terms.term_id  AND post_taxonomy_category_tbl_termtaxonomy.taxonomy = 'category' INNER JOIN _PPZ_term_relationships AS rel_post_taxonomy_category_tbl  ON post_taxonomy_category_tbl_termtaxonomy.term_taxonomy_id = rel_post_taxonomy_category_tbl.term_taxonomy_id) AS post_taxonomy_category_tbl
     ON post_taxonomy_category_tbl.ID = posts_post.id 
WHERE 1=1 
   AND post_taxonomy_category_tbl.name LIKE '%zaphod%'
   AND posts_post.post_type = 'post'

This doesn't - 

SELECT posts_post.post_title AS post_post_title,
       post_taxonomy_category_tbl.name AS post_taxonomy_category
FROM _PPZ_posts AS posts_post
  INNER JOIN (SELECT name, object_id as id FROM _PPZ_terms AS post_taxonomy_category_tbl_terms INNER JOIN _PPZ_term_taxonomy AS post_taxonomy_category_tbl_termtaxonomy ON post_taxonomy_category_tbl_termtaxonomy.term_id = post_taxonomy_category_tbl_terms.term_id  AND post_taxonomy_category_tbl_termtaxonomy.taxonomy = 'category' INNER JOIN _PPZ_term_relationships AS rel_post_taxonomy_category_tbl  ON post_taxonomy_category_tbl_termtaxonomy.term_taxonomy_id = rel_post_taxonomy_category_tbl.term_taxonomy_id) AS post_taxonomy_category_tbl
     ON post_taxonomy_category_tbl.ID = posts_post.id 
     AND post_taxonomy_category LIKE '%zaphod%'
WHERE 1=1 
   AND posts_post.post_type = 'post'

Hope this helps should you come across this problem again.

Cheers
Glenn