Zau4man

 
$sql = "SELECT  p.title as title,
                        p.id as id,
                        p.seolink as seolink, 
                        b.title as blog,
                        b.owner as owner,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        IF(DATE_FORMAT(p.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'),
						DATE_FORMAT(p.pubdate, '<strong>{$_LANG['TODAY']}</strong> {$_LANG['IN']} %H:%i'), DATE_FORMAT(p.pubdate, '%d-%m-%Y'))  as fpubdate,
						b.user_id as uid,
                        IFNULL(SUM(r.points), 0) as rating,
                        b.owner as owner,
                        b.ownertype as ownertype,
                        u.nickname as author
				FROM cms_users u, cms_blogs b, cms_blog_posts p
                LEFT JOIN cms_ratings r ON r.item_id=p.id AND r.target='blogpost'
				WHERE p.blog_id = b.id AND b.allow_who = 'all' AND p.published = 1 AND b.user_id = u.id
                GROUP BY p.id
				ORDER BY p.pubdate DESC
                LIMIT 50";
 

 
$sql = "SELECT  p.title as title,
                        p.id as id,
                        p.seolink as seolink, 
                        b.title as blog,
                        b.owner as owner,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        IF(DATE_FORMAT(p.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'),
						DATE_FORMAT(p.pubdate, '<strong>{$_LANG['TODAY']}</strong> {$_LANG['IN']} %H:%i'), DATE_FORMAT(p.pubdate, '%d-%m-%Y'))  as fpubdate,
						b.user_id as uid,
                        IFNULL(SUM(r.points), 0) as rating
				FROM cms_blogs b, cms_blog_posts p
                LEFT JOIN cms_ratings r ON r.item_id=p.id AND r.target='blogpost'
				WHERE p.blog_id = b.id AND b.allow_who = 'all' AND p.published = 1
                GROUP BY p.id
				ORDER BY p.pubdate DESC
                LIMIT 50";