Thread: cp_ad_pop_daily bug in classipress 3.0.5.4

 11 |   0.0008 |            enabled             | not cached |          3296 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (446421) ORDER BY t.name ASC
   12 |   0.0011 |            enabled             | not cached |          3563 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('ad_cat') AND tr.object_id IN (446421) ORDER BY t.name ASC
   13 |   0.0001 |            enabled             |   cached   |          3566 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'ad_cat' AND t.slug = 'jobs' LIMIT 1
   14 |   0.0001 |            enabled             |   cached   |          3464 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'ad_cat' AND t.slug = 'marketing-jobs' LIMIT 1
   15 |   0.2731 |  disabled (query is rejected)  | not cached |             0 | UPDATE wp_cp_ad_pop_total SET postcount = postcount+1 WHERE postnum = '446421' LIMIT 1
   16 |   5.5351 |  disabled (query is rejected)  | not cached |             0 | UPDATE wp_cp_ad_pop_daily SET postcount = postcount+1 WHERE time = '2011-05-25' AND postnum = '446421' LIMIT 1 
   17 |   0.7172 |            enabled             | not cached |          1025 | SELECT t.postcount AS total, d.postcount AS today FROM wp_cp_ad_pop_total AS t
			INNER JOIN wp_cp_ad_pop_daily AS d ON t.postnum = d.postnum
			WHERE t.postnum = '446421' AND d.time = '2011-05-25'

DELETE FROM wp_cp_ad_pop_daily WHERE time <= CURRENT_DATE - INTERVAL 1 DAY