LDB: Unknown column 'approved' in 'where clause':
SELECT CSRNewsArticle.*,
DATE_FORMAT(CSRNewsArticle.article_date, '%m/%d') AS d,
DATE_FORMAT(CSRNewsArticle.article_date, '%m/%d/%Y') AS d_mmddyyyy,
DATE_FORMAT(CSRNewsArticle.article_date, '%M %d, %Y') AS d2,
DATE_FORMAT(CSRNewsArticle.article_date, '%d %M %Y') AS d3,
DATE_FORMAT(CSRNewsArticle.article_date, '%m/%d') AS date_f,
NewsType.name AS type
FROM CSRNewsArticle
LEFT JOIN NewsType
ON NewsType.id = CSRNewsArticle.typeid
WHERE approved = 1 AND article_date <= now()
ORDER BY CSRNewsArticle.article_date DESC
LIMIT 20
At: /var/lib/apache/sflib/LDB.pm (88)
At: /var/lib/apache/sflib/LDB.pm (222)
At: /var/lib/apache/sflib/CSRNews.pm (205)
At: /var/www/srinews/categories.cgi (55)
