Link Summary
A handy utility for all of us out there… to hand out to our friends, family members and perhaps other people too..
WordPress database error: [Table 'mingle.wp_post2cat' doesn't exist]
SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts,
UNIX_TIMESTAMP(max(posts.post_date_gmt)) + '1' AS last_post_date,
UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt
FROM wp_post2cat p2c
INNER JOIN wp_posts posts ON p2c.post_id=posts.id
WHERE 1 = 1
AND posts.post_type = 'post' AND posts.post_status = 'publish'
AND posts.post_date_gmt <= '2010-02-08 22:11:28'
GROUP BY p2c.category_id
ORDER BY numposts DESC
|
||||||
Link SummaryA handy utility for all of us out there… to hand out to our friends, family members and perhaps other people too.. |
||||||
|
Copyright © 2010 Mingle Mangle of my mind - All Rights Reserved Bad Behavior has blocked 72 access attempts in the last 7 days. |
||||||
Recent Comments