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
   
   
  E-MAIL: info@geekpak.com    |    T: 1.888.GEEK.PAK (888.433.5725)    |    F: 718.836.0509  
  CHICAGO: 346 N. Justine, Chicago IL 60607-1010 | NEW YORK: 564 72nd Street, Brooklyn NY 11209 | WASHINGTON DC: 6031-F Curtier Drive, Alexandria VA 22310