| commit | 67327a3df1f50fcad1596f0fbf0bbac89e8e9b26 | [log] [tgz] |
|---|---|---|
| author | Anand Doshi <anand@iwebnotes.com> | Thu Dec 06 20:13:57 2012 +0530 |
| committer | Anand Doshi <anand@iwebnotes.com> | Thu Dec 06 20:13:57 2012 +0530 |
| tree | 6fc27546c731fcfe67065d772296fd23da7cd3d2 | |
| parent | ddd8bddffd2ec7578d0f233ba159d0737a3f63e6 [diff] |
fix in number of comments
diff --git a/website/blog.py b/website/blog.py index fe3cbbd..8813dc0 100644 --- a/website/blog.py +++ b/website/blog.py
@@ -17,7 +17,7 @@ select name, content, owner, creation as creation, title, (select count(name) from `tabComment` where - comment_doctype='Blog' and comment_docname=name) as comments + comment_doctype='Blog' and comment_docname=`tabBlog`.name) as comments from `tabBlog` where ifnull(published,0)=1 order by creation desc, name asc"""