>>

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_blog_categories.name_' in 'field list', query was: SELECT `user_blogs`.*, `user_blog_categories`.`name_` AS `cattitle`, `user_blog_categories`.`parentid`, `u`.`nikname`, `u`.`sex`, `partner_files`.`upload`, `partner_files`.`mime`, `partner_files`.`branch` FROM `user_blogs` LEFT JOIN `user_blog_categories` ON user_blog_categories.id=user_blogs.category LEFT JOIN `users` AS `u` ON u.id=user_blogs.user_id LEFT JOIN `partner_files` ON partner_files.file_id=user_blogs.id AND partner_files.branch = "blogs" AND partner_files.top=1 WHERE (user_blogs.id =2073) AND (user_blogs.category =15) AND (user_blogs.view =2) AND (user_blogs.approve_from_user =1) AND (user_blogs.approve =1)SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_blog_categories.name_' in 'field list', query was: SELECT `user_blogs`.`id`, `user_blogs`.`user_id`, `user_blogs`.`title`, `user_blogs`.`text`, `user_blogs`.`short_text`, `user_blogs`.`category`, `user_blogs`.`view` AS `blog_view`, `user_blogs`.`dated`, `user_blogs`.`readed`, `user_blogs`.`approve` AS `blog_approve`, `user_blog_categories`.`name_` AS `cattitle`, `u`.`nikname`, `u`.`sex`, `pf`.`file_id` AS `uid`, `pf`.`upload`, `pf`.`mime`, `pf`.`view`, count(us.id) as comments_count, max(us.dated) as max_date FROM `user_blogs` LEFT JOIN `user_blog_categories` ON user_blog_categories.id=user_blogs.category LEFT JOIN `users` AS `u` ON u.id=user_blogs.user_id LEFT JOIN `partner_files` AS `pf` ON pf.file_id=u.id and pf.deep=1 AND pf.view=2 AND branch='user' LEFT JOIN `user_comments` AS `us` ON us.public_id=user_blogs.id AND us.branch='blogs' AND us.view=2 AND us.approve=1 WHERE (user_blogs.category ='15') AND (user_blogs.approve_from_user =1) AND (user_blogs.approve =1) AND (user_blogs.view =2) AND (user_blogs.category !=0) GROUP BY `user_blogs`.`id` HAVING (count(us.id) >0) ORDER BY `max_date` DESC LIMIT 10