home
telly
jokes
news
Comedy Circle

News

Are are some stories from the comedy world - feel free to post your comments.

db_query


SELECT COUNT(c.id) AS comments, n.id as newsid, n.title, n.news, n.allowcomments, 
                                           DATE_FORMAT(FROM_UNIXTIME(n.timeposted + (0 ) + (3600 * +0 )), '%d-%m-%Y %h:%i%p') as `date`, 
                                           DATE_FORMAT(FROM_UNIXTIME(n.timeposted + (0 ) + (3600 * +0 )),'%W %D %M, %Y') as dateGroup,
                                           u.postname, cat.name as catname, cat.avatar_name, cat.avatar_url
                                           FROM `satm26_news` as n, `satm26_users` as u
                                           LEFT JOIN `satm26_comments` as c ON (n.id = c.newsid)
                                           LEFT JOIN `satm26_category` as cat ON (cat.id = n.catid)
                                           WHERE n.userid = u.userid
                                           
                                           GROUP BY n.id
                                           ORDER BY n.timeposted DESC
                                           LIMIT 0, 5
                                           
Unknown column 'n.id' in 'on clause'