SELECT Events.evn_Id, Events.evn_Display1, Events.evn_DateStart, Events.evn_DateEnd, Events.evn_Rate1, Events.evn_rate2, Events.evn_Status, ShowMetaInfo.smi_Value AS Electric, ShowMetaInfo_1.smi_Value AS Tables, ShowMetaInfo_2.smi_Value AS Chair FROM ((Events INNER JOIN ShowMetaInfo ON Events.evn_Id = ShowMetaInfo.smi_evn_Id) INNER JOIN ShowMetaInfo AS ShowMetaInfo_1 ON Events.evn_Id = ShowMetaInfo_1.smi_evn_Id) INNER JOIN ShowMetaInfo AS ShowMetaInfo_2 ON Events.evn_Id = ShowMetaInfo_2.smi_evn_Id WHERE (evn_DateEnd > #6 November 2024#) AND (ShowMetaInfo.smi_MetaCode = 'smi_Electric') AND (ShowMetaInfo_1.smi_MetaCode = 'smi_Table') AND (ShowMetaInfo_2.smi_MetaCode = 'smi_Chair') ORDER BY evn_DateStart, evn_Display1