Exhibitions

MYSQL-ERROR
Fehler: 1054
Detail: Unknown column 'Datum-Ende' in 'order clause'
Info:
Query: SELECT `of`.ID AS OF_ID,ob16.`text_Styles` AS we_description,ob16.`input_Headline` AS we_title,`of`.`ID` AS `we_ID`,`of`.`ParentID` AS `we_ParentID`,`of`.`Filename` AS `we_Filename`,`of`.`ContentType` AS `we_ContentType`,`of`.`Creation_Date` AS `we_Creation_Date`,`of`.`Mod_Date` AS `we_Mod_Date`,`of`.`Publish_Date` AS `we_Publish_Date`,`of`.`UnPublish_Date` AS `we_UnPublish_Date`,`of`.`Path` AS `we_Path`,`of`.`Url` AS `we_Url`,`of`.`TriggerID` AS `we_TriggerID`,`of`.`CreatorID` AS `we_CreatorID`,`of`.`ModifierID` AS `we_ModifierID`,`of`.`RestrictOwners` AS `we_RestrictOwners`,`of`.`Owners` AS `we_Owners`,`of`.`OwnersReadOnly` AS `we_OwnersReadOnly`,`of`.`Workspaces` AS `we_Workspaces`,`of`.`TableID` AS `we_TableID`,`of`.`Category` AS `we_Category`,`of`.`IsSearchable` AS `we_IsSearchable`,`of`.`Language` AS `we_Language`,`of`.`WebUserID` AS `we_WebUserID`,`of`.`IsClassFolder` AS `we_IsClassFolder`,`of`.`IsFolder` AS `we_IsFolder`,`of`.`IsPublished` AS `we_IsPublished`,`of`.`IsModified` AS `we_IsModified`,`of`.`CreationDate` AS `we_CreationDate`,`of`.`ModDate` AS `we_ModDate`,`of`.`Published` AS `we_Published`,`of`.`Text` AS `we_Text`,`of`.`ClassName` AS `we_ClassName`,`of`.`Charset` AS `we_Charset`,ob16.`multiobject_Werk` AS `Werk`,ob16.`text_Video` AS `Video`,ob16.`input_Subheader` AS `Subheader`,ob16.`text_Styles` AS `Styles`,ob16.`input_Sortierung` AS `Sortierung`,ob16.`checkbox_Right-Off` AS `Right-Off`,ob16.`multiobject_Pressespiegel` AS `Pressespiegel`,ob16.`multiobject_Pressefoto` AS `Pressefoto`,ob16.`input_Order-Keyword` AS `Order-Keyword`,ob16.`input_Metadescription` AS `Metadescription`,ob16.`checkbox_Medium` AS `Medium`,ob16.`link_Link` AS `Link`,ob16.`multiobject_Kuenstler` AS `Kuenstler`,ob16.`input_Keyword` AS `Keyword`,ob16.`checkbox_Invers` AS `Invers`,ob16.`text_Intro` AS `Intro`,ob16.`checkbox_Image-Show` AS `Image-Show`,ob16.`img_Image` AS `Image`,ob16.`OF_ID` AS `ID`,ob16.`checkbox_Home-Off` AS `Home-Off`,ob16.`text_Hintergrund` AS `Hintergrund`,ob16.`input_Headline` AS `Headline`,ob16.`checkbox_Gridimage-Off` AS `Gridimage-Off`,ob16.`input_Gridimage-Copyright` AS `Gridimage-Copyright`,ob16.`img_Gridimage` AS `Gridimage`,ob16.`checkbox_Grid-Noimage` AS `Grid-Noimage`,ob16.`OF_DocumentTable` AS `DocumentTable`,ob16.`date_Datum` AS `Datum`,ob16.`date_Datstart` AS `Datstart`,ob16.`date_Datende` AS `Datende`,ob16.`text_Content2` AS `Content2`,ob16.`text_Content` AS `Content`,ob16.`input_Color` AS `Color`,ob16.`checkbox_Black` AS `Black`,ob16.`checkbox_Bigimage-Off` AS `Bigimage-Off`,ob16.`checkbox_Bigimage-Grid` AS `Bigimage-Grid`,ob16.`input_Bigimage-Copyright` AS `Bigimage-Copyright`,ob16.`img_Bigimage` AS `Bigimage`,ob16.`checkbox_Ausstellung` AS `Ausstellung`,ob16.`checkbox_Ausfall` AS `Ausfall`,ob16.`checkbox_Aktuell` AS `Aktuell`
FROM tblObject_16 AS `ob16` JOIN tblObjectFiles `of` ON (`of`.ID=ob16.OF_ID AND ob16.OF_DocumentTable="tblObjectFiles")
WHERE `of`.IsSearchable=1 AND  (`of`.Workspaces="" OR `of`.Workspaces="" OR CONCAT(",",`of`.Workspaces,",") REGEXP ",(7704|7701|0),")  AND  ( `of`.IsPublished=1 )  AND (((FROM_UNIXTIME(ob16.`date_Datum`,"%Y-%m-%d %H:%i:%s") < NOW( ))  AND (ob16.`checkbox_Ausstellung` = "1")  AND (ob16.`checkbox_Aktuell` = "0") )) AND `of`.isFolder=0 ORDER BY `Datum-Ende` DESC LIMIT 0,100000000