Too many queries WordPress

Dbranes answers:

Hi @Jagst3r21

If you want to use only a single database query to get the number of posts before the due date, then you can try the following approach:

/**
* Fetch taxonomy terms statistics for all posts before due date, with a single database query.
*
* @see http://www.wpquestions.com/question/showChronoLoggedIn/id/9770
* @param string $taxonomy
* @param string $meta_key
* @return mixed Database query results
*/

function get_tax_terms_stats_before_due_date( $taxonomy, $meta_key )
{
global $wpdb;

$sql ="
SELECT COUNT(1) as postscount, t.term_id, t.name, t.slug, tt.taxonomy
FROM {$wpdb->term_relationships} tr
INNER JOIN {$wpdb->posts} p ON p.ID = tr.object_id
INNER JOIN {$wpdb->postmeta} pm ON ( p.ID = pm.post_id AND meta_key = '%s' )
INNER JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN {$wpdb->terms} t ON tt.term_id = t.term_id
WHERE
CAST( pm.meta_value AS DATETIME ) > '%s'
AND p.post_status = 'publish'
AND tt.taxonomy = '%s'
GROUP BY t.term_id
ORDER BY postscount DESC
";

return $wpdb->get_results( $wpdb->prepare( $sql, $meta_key, date( 'Y-m-d H:I:s' ), $taxonomy ) );
}


Here's an example how we can use this function:


/**
* Display the post count for each category before the due date.
*/

function wpq_list_stats_table_example()
{
$items = get_tax_terms_stats_before_due_date( 'category', 'due' );
$tr = '<tr><th>#</th><th>Term</th><th>Slug</th><th>Taxonomy</th></tr>';
foreach( $items as $item )
{
$tr .= sprintf( '<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>',
$item->postscount,
$item->name,
$item->slug,
$item->taxonomy
);
}
printf( '<table>%s</table>', $tr );
}

// Display it:
wpq_list_stats_table_example();



where it will display a table like this one:

# Term Slug Taxonomy
2 Tech tech category
2 Music music category
1 Academic academic category
1 Sport sport category


I hope you can modify this to your needs.

<strong>Update:</strong>

Here's a how you can use it in your code snippet:


/* Fetch data for categories + posts stats */
if( function_exists( 'get_tax_terms_stats_before_due_date' ) ) {
$categories = get_tax_terms_stats_before_due_date( 'category', 'due' );
}

/* Init */
$i = 0;
$cats_data = array();
$exclude_cats = array( 1, 13, 1460 );

/* Foreach category: display the data */
foreach ( (array) $categories as $cat) {

/* ======= EXCLUDE CATEGORIES ===== */
if( in_array( $cat->term_id, $exclude_cats ) ) continue;

/* ======= HTML CLASS ========= */
$class = ( $i % 3 ) ? 'span4' : 'span4';
$classes = $class . ' ' . 'category-' . $cat->term_id;

/* ====== CATEGORY THUMBNAIL ======== */
$thumbnail_id = get_option('seamless_term_thumb_' . $cat->term_id);
$image = wp_get_attachment_url($thumbnail_id);

/* ====== SITE URL VARIABLE ======== */
$url = site_url();

/* ====== LINK TO SEARCH: no need fields ======= */
$link_to = $url . '/discover/?search_query=&orderby=due&tax_category=' . $cat->slug .'&wpas=1';

/* ====== POST COUNT ========*/
$post_count = $cat->postscount;


/* MERGE DATA IN ARRAY */
$cats_data[] = array(
'classes' => $classes,
'post_count' => $post_count,
'image' => $image,
'name' => $cat->name,
'link' => $link_to,
);

$i++;
} // end foreach


foreach ($cats_data as $cat_data ){ ?>
<div class="<?php echo $cat_data['classes'];?>">
<div class="thumb one">
<a href="<?php echo $cat_data['link'] ?>">
<div class="two"><?php echo $cat_data['post_count'] . ' Scholarships' ?></div>
</a>
<a href="<?php echo $cat_data['link'] ?>">
<img src="<?php echo $cat_data['image']; ?>" alt="<?php echo esc_attr( $cat_data['name'] ); ?>" class="item-image">
</a>
</div> <!-- end .thumb -->
</div>
<?php }


ps: It's a good rule to use only <strong>lowercase</strong> meta keys, i.e. <em>due</em> instead of <em>Due</em>.

---

---

---

---

---

---