Home Calendar
×

Error

Unknown column 'Event.featured' in 'order clause' SQL=SELECT Event.*,'com_jcalpro' AS context,IF(Event.`created_by`=0,'Guest',IF(Event.`created_by`=-1,'System',Author.name)) AS author_name,IF(Event.`created_by`=0,'guest',IF(Event.`created_by`=-1,'system',Author.username)) AS author_username FROM #__jcalpro_events AS Event LEFT JOIN #__users AS Author ON Author.id = Event.`created_by` LEFT JOIN #__jcalpro_event_categories AS CatFilter ON CatFilter.event_id = Event.id WHERE Event.approved = 1 AND Event.private = 0 AND Event.published = 1 AND Event.approved = 1 AND ((( Event.start_date <= '2017-04-23 04:00:00' AND Event.end_date >= '2017-05-02 03:59:59' AND Event.end_date != '2038-01-18 00:00:00' AND Event.end_date != '0000-00-00 00:00:01' AND Event.end_date != '9999-12-01 00:00:00') OR ((Event.start_date >= '2017-04-23 04:00:00' AND Event.start_date < '2017-05-02 03:59:59') AND (Event.end_date = '2038-01-18 00:00:00' OR Event.end_date = '0000-00-00 00:00:01' OR Event.end_date = '9999-12-01 00:00:00')) OR ( Event.start_date > '2017-04-23 04:00:00' AND Event.start_date <= '2017-05-02 03:59:59') OR ( Event.end_date > '2017-04-23 04:00:00' AND Event.end_date <= '2017-05-02 03:59:59' ) )) GROUP BY Event.id HAVING ((CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',80,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,80,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,80,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',80,')) ORDER BY Event.featured DESC,Event.start_date ASC LIMIT 0, 999999

hpslogo                    learning-lab-logo          uconn-wordmark-stacked-white          Goodwin-V Logo 2PMS SolidUHart white trans back stacked           Capital LOGO          Hartford Courant logo

Home Calendar