GeekPAK

MYSQL ERROR IN FOOTER:RECENT_NEWS:
Incorrect DATE value: ''

QUERY:
SELECT SQL_CALC_FOUND_ROWS '0' AS foundRows, rdt.redirectCause AS redirectCause, cat.catalogID, cat.title, cat.subtitle, cat.dateDisplay, b.webPageTemplate, CASE WHEN f.topicID IS NULL THEN x.topicID ELSE f.topicID END AS topicID FROM catalog cat LEFT JOIN catalog_lu_page_type b ON b.pageTypeID=cat.pageTypeID LEFT JOIN catalog_topics f ON f.catalogID=cat.catalogID LEFT JOIN catalog_lu_topics x ON cat.catalogID=x.catalogID LEFT JOIN web_redirect rdt ON rdt.redirectEffect=cat.catalogID LEFT JOIN catalog_privileges_join gpPriv ON cat.privilegeID=gpPriv.catalogPrivilegesID WHERE (f.topicID='top402') AND (((cat.privilegeID='') OR (cat.privilegeID IS NULL) OR ((gpPriv.foreignPrivilegesID IN ('prv0','prv0')) AND gpPriv.readItems='1')) AND ((cat.dateLive <= NOW()) OR (cat.dateLive = '') OR (cat.dateLive = '0000-00-00')) AND ((cat.dateArchive > NOW()) OR (cat.dateArchive = '') OR (cat.dateArchive = '0000-00-00'))) GROUP BY cat.catalogID ORDER BY cat.datePublished DESC LIMIT 4