Archive
This is a ‘live archive’, which allows you to ‘dig’ into the collection of posts & pages in a fast and efficient way without having to reload this page as you explore.
WordPress database error: [Table 'wordpress_justinallen.wp_post2cat' doesn't exist]
SELECT DISTINCT YEAR(p.post_date) AS `year`
FROM wp_posts p
INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id)
WHERE p.post_date > 0
AND p2c.category_id <> 2
ORDER By p.post_date DESC
WordPress database error: [Table 'wordpress_justinallen.wp_categories' doesn't exist]
SELECT cat_ID, cat_name, category_nicename, category_parent
FROM wp_categories c
WHERE c.cat_ID > 0 AND c.cat_ID <> 2
ORDER BY c.cat_ID asc
WordPress database error: [Table 'wordpress_justinallen.wp_categories' doesn't exist]
SELECT c.cat_ID,
COUNT(distinct p2c.post_id) AS cat_count
FROM wp_categories c
INNER JOIN wp_post2cat p2c ON (c.cat_ID = p2c.category_id)
INNER JOIN wp_posts p ON (p.ID = p2c.post_id)
WHERE p.post_status = 'publish'
AND post_type = 'post'
AND p.post_date_gmt < '2008-11-21 08:11:21'
AND c.cat_ID <> 2
GROUP BY p2c.category_id
