Copyright Decision Strategies http://www.decisionstrategies.com/rss/event-feed Decision Strategies corporate events and training RSS feed en-us Fri, 18 May 2012 05:55:04 CDT 5 http://www.decisionstrategies.com/rss/event-feed http://www.decisionstrategies.com/Themes/Admin/logo_decisionstrategies.jpg Database error: Invalid SQL: SELECT * FROM ( ( SELECT 'events' as type, calendarname as title, CONCAT((SELECT siteurl FROM metasettings WHERE id=1), 'events/', uniqid) as url, displaystart, DATE_FORMAT(displaystart, '%a, %d %b %Y %H:%i:%S GMT') as pubdate, `description` as description, (SELECT (SELECT CONCAT(firstname, ' ', lastname) FROM contacts WHERE contacts.contactid=events_logs.eventid) FROM events_logs WHERE events_logs.eventid=events.eventid ORDER BY `type`, dated, id LIMIT 1) as author, '' as thumbnail, '' as content from events WHERE IFNULL(public, 0) = 1 AND IFNULL(displayonlist, 0) = 1 AND IFNULL(archive, 0)=0 AND IFNULL(searchable, 0)=1 AND CURDATE() >= DATE_FORMAT(IFNULL(displaystart, CURDATE()), '%Y-%m-%d') AND CURDATE() <= DATE_FORMAT(IFNULL(displayend, CURDATE()), '%Y-%m-%d') ORDER BY displaystart DESC LIMIT 10 ) ) T ORDER BY dated DESC
MySQL Error: 1054 (Unknown column 'dated' in 'order clause')
Session halted.