GeekPAK

MYSQL ERROR IN toplistTAB2:
Incorrect DATE value: ''

QUERY:
SELECT SQL_CALC_FOUND_ROWS '0' AS foundRows, rdt.redirectCause, xy.genericListDisplay AS mediaType, CASE WHEN n.displayStatus!='off' THEN n.topicID ELSE p.topicID END AS topicID, CASE WHEN n.displayStatus!='off' THEN n.topicShortName ELSE p.topicShortName END AS topicShortName, t.catalogID, cat.title, cat.subtitle, cat.dateDisplay, cat.datePublished, cat.contentDescription, CASE WHEN (cat.contentDescription = "") THEN cat.contentFull END AS contentToSummarize, c.webPageTemplate, t.sortOrder FROM catalog_topics t LEFT JOIN catalog cat ON t.catalogID=cat.catalogID LEFT JOIN catalog_lu_page_type c ON c.pageTypeID=cat.pageTypeID LEFT JOIN catalog_lu_topics n ON (t.topicID=n.topicID) LEFT JOIN catalog_lu_topics p ON (p.catalogID=cat.catalogID) LEFT JOIN catalog_generic_criteria xx ON (xx.foreignKey=cat.catalogID) AND (xx.typeID='gp872vl90') LEFT JOIN lu_generic xy ON xy.genericListID=xx.criteriaID LEFT JOIN web_redirect rdt ON rdt.redirectEffect=t.catalogID LEFT JOIN catalog_privileges_join gpPriv ON cat.privilegeID=gpPriv.catalogPrivilegesID WHERE ((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')) AND cat.catalogID IN (SELECT foreignKey FROM catalog_generic_criteria WHERE criteriaID = '3gpgvl103') GROUP BY t.catalogID ORDER BY datePublished DESC LIMIT 10