Форум последние сообщения

DATABASE ERROR:
SELECT p.*,
                       u.nickname as author, u.login, u.is_deleted,  up.imageurl as author_image,
                       b.allow_who as blog_allow_who,
                       b.seolink as bloglink,
                       b.title as blog_title,
                       b.owner as owner , up.imageurl
                FROM cms_blog_posts p
				INNER JOIN cms_blogs b ON b.id = p.blog_id
				LEFT JOIN cms_users u ON u.id = p.user_id
					LEFT JOIN cms_user_profiles up ON up.user_id = u.id
				LEFT JOIN cms_user_profiles up ON up.user_id = u.id
 
                WHERE p.published = 1 AND b.owner = 'user'
				       AND (b.allow_who = 'all')
 AND (p.allow_who = 'all')
 
 
                ORDER BY p.rating DESC
LIMIT 0, 10
Not unique table/alias: 'up'