Vigane päing:
SELECT Blog.BlogID, www_ee_blog.Subject, Blog.Body, User.Epost, BlogName.Name, www_ee_blog.AddDate, COUNT( Comment.CommentID ) AS Total FROM www_ee_blog.Blog LEFT JOIN webUsers.User USING(UserID) LEFT JOIN www_ee_blog.BlogName USING(UserID) LEFT JOIN www_ee_blog.Comment USING(BlogID) AND Public = '1' GROUP BY BlogID ORDER BY www_ee_blog.AddDate DESC LIMIT 100
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Public = '1' GROUP BY BlogID ORDER BY www_ee_blog.AddDate DESC ' at line 7