SELECT a.id as bid, b.id, b.cat_id, b.publisher_id, b.publisher_name, b.title, b.parsed_preview, b.date, b.update, b.post_pic, b.hits, b.blog_rating, c.user_login, c.user_avatar FROM cl_blogtags a LEFT JOIN cl_blog b ON b.id = bid LEFT JOIN cl_person c ON c.user_id = b.publisher_id WHERE a.name='токио' GROUP BY a.id ORDER BY a.id DESC LIMIT 0,10;