Wordpress SQL / PHP

<?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));

?>