Популярное за период

$sql = "SELECT  p.id,
		                p.title,
						p.seolink,
						p.pubdate,
                        b.title as blog,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        b.owner as owner,
                        b.user_id as uid, 
                        b.owner as owner,
                        b.ownertype as ownertype,
                        IFNULL(r.total_rating, 0) as points,
                        u.nickname as author
				FROM cms_blog_posts p
				LEFT JOIN cms_blogs b ON b.id = p.blog_id		
				LEFT JOIN cms_ratings_total r ON r.item_id=p.id AND r.target='blogpost'
				LEFT JOIN cms_users u ON u.id=b.user_id
				WHERE p.published = 1 AND b.allow_who = 'all'
				ORDER BY points DESC";

AND (p.pubdate + INTERVAL 1 MONTH) > NOW()

WHERE DATEDIFF(NOW(), pubdate) < 30

AND DATEDIFF(NOW(), p.pubdate) < 30