Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I have written SQL for a query that pulls the most used taxonomy terms for selected taxonomies that are published, do not have a parent post are not in a comma separated list over the past two weeks -- grouped by the term itself sorted by most posts descending.

The issue I am running into is that it is running very slowly and was wondering if you guys had any suggestions for either converting it to wp_query arguments or the right indexes to put on the tables. Following the optimizers path it is running through 4630 rows on wp_term_taxonomy 1 row on wp_terms, 9 rows on wp_term_relationships and 1 row on wp_posts

The query I wrote is basically:

# ** NOTE THIS IS NOT THE EXACT SQL, WRITTEN TO BETTER ARTICULATE MY QUESTION

SELECT wp_terms.name, wp_terms.slug, wp_term_taxonomy.taxonomy,count(1)
WHERE wp.term_taxonomy_id in ('$comma', '$separated', '$taxonomies') AND
wp_posts.post_status = 'publish' AND wp_posts.post_parent = 0 AND
wp_posts.post_date > '$two_weeks_ago' AND wp_terms.term_id NOT IN
($list, $of, $ids, $comma, $separated) group by wp_terms.term_id
order by total_posts desc limit $limit_variable

Appreciate any help.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.