MYSQL ERROR IN CATALOG_ITEM:EVENT:
Not unique table/alias: 'b'
QUERY:
SELECT cat.catalogID, cat.title, cat.subtitle, cat.dateDisplay, cat.contentDescription, cat.contentFull, b.webPageTemplate, c.title as eventTitle, c.description, c.eventDisplayDate, c.eventDisplayTime, c.eventRoom, c.eventFee, c.eventCEU, d.topicID FROM catalog cat LEFT JOIN catalog_lu_page_type b ON (cat.pageTypeID=b.pageTypeID) LEFT JOIN catalog_events b ON c.catalogID=a.catalogID LEFT JOIN catalog_topics d ON (cat.catalogID=d.catalogID) WHERE (cat.catalogID='93t101') 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 LIMIT 1000
back to Home