Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('wp-load.php');
- $query = "
- SELECT p.post_name AS url, wpr.object_id AS PostID, p.post_date AS Date, wp_users.user_nicename AS Author, p.post_title AS Title, group_concat(wp_terms.name ORDER BY wp_terms.name ASC separator ', ') AS Categories
- FROM wp_terms
- INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
- INNER JOIN wp_term_relationships wpr ON wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
- INNER JOIN wp_posts p ON p.ID = wpr.object_id
- INNER JOIN wp_users on wp_users.ID = p.post_author
- WHERE taxonomy = 'category'
- AND p.post_type = 'post'
- AND p.post_status = 'publish'
- AND p.post_date LIKE '2012%'
- GROUP BY wpr.object_id
- ORDER BY post_date DESC
- LIMIT 0 , 5000";
- $sth = mysql_query($query);
- $rows = array();
- while($r = mysql_fetch_assoc($sth)) {
- $rows[] = $r;
- }
- print strip_tags(json_encode($rows));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement