Cannot query the database.

select a.*, b.name as Type, a.OAAEvent from coned_events a, coned_types b where a.TypeID = b.ID and a.status = 'enabled' and a.publisheddate <= unix_timestamp() and a.expirydate > unix_timestamp() and cycle = 3 order by b.OrderID, a.OAAEvent ASC, a.type asc, a.timestamp asc

Error:
Unknown column 'a.publisheddate' in 'where clause'
Trace: (database.class.php:120)
(main.class.php:1447)
(main.class.php:6662)
(main.class.php:6717)
(main.class.php:9512)
(manager.class.php:23)
(document.class.php:321)
(document.class.php:209)
(index.php:41)