www.gemeinsam-aktiv.de
query
RESULTSET
query
  AIMAGE CFPARAM CFSET COMMAND COMMAND_ELEMENT COMMAND_ICON COMMAND_ROLE COMMAND_TRIGGER COMMAND_URL COMMAND_XHR DEPTH DESIGNIMAGE DSDID DSFRAMES DSINCLUDE DSJSFRAMEWORK DSNAVFOLDER DSNAVFOLDER DSPMID DSROLE DSSID DSTNAME DSTREEID DSTTIDLIST EXPDATE HIDDEN HTMLACTIVE ID IMAGE ITEMID JSFRAMEWORK LANGDSMID LANGUAGE LANGUAGE_DSMID LASTMODIFY_CONTENT_DATE LASTMODIFY_DATE LASTMODIFY_STATUS LFT LINKDSMID LINKDSPAID LINKDSSID LINKED LINKTARGET LINKTYPE LISTSTYLE LIVE MAINFOOTER MAINHEADER MENUFOOTER MENUHEADER MENUTEXT METADESC METAKEY MNHTML NAME NFFOOTER NFHEADER ONOUT ONOVER OPENMENU OVERIMAGE PARENTITEMID PUBDATE REALLANG RGT SCHEDULE SECURED SORT TAGLIST TEMPHIDDEN TEMPLIVE TEMPSECURED TITLE TYPE URLLINK URLTARGET XMLDATA
CACHED false
EXECUTIONTIME 32
SQL SELECT ID as ItemID, DSPMID as ParentItemID, ID, LFT, RGT, Language,DSNavFolder, CASE WHEN id=(select language_dsmid from Menus AS A where language_dsmid=Menus.id and language='global') THEN (select language from Menus AS B where language_dsmid=Menus.id and language='global') ELSE language END as reallang, id as langdsmid, Menutext, Menutext AS Name, MNHTML, DSRole, ListStyle, LinkType,TempLive, LinkDSSID,LinkDSMID, LinkDSPAID,LinkTarget, URLLInk,URLTarget, Schedule,PubDate,ExpDate, DSFrames, DSSID, Image, AImage, OverImage, DSPMID, OnOver, OnOut, CFSET, CFPARAM, Live, Hidden, Depth , Sort, Linked, OpenMenu, DSInclude, DSTname, Secured, TempSecured, TempHidden, MainHeader, MainFooter, NFHeader, NFFooter, MenuHeader, MenuFooter, DSNAVFolder, MetaDesc, MetaKey, Title, DSDID, DesignImage, LastModify_Content_Date,LastModify_Date, LastModify_Status, XMLData, HTMLActive, Type, DSTreeID, Language_DSMID ,DSJSFrameWork,JSFramework, Command, Command_Trigger, Command_Role, Command_Element, Command_URL, Command_XHR, Command_Icon, Taglist, DSTTIDList FROM Menus WHERE Menus.DSSID=? and Menus.Language = ? AND TempLive=1 AND TempHidden=0 AND (SCHEDULE=0 OR (SCHEDULE=1 AND (PubDate <= GetDate() AND ExpDate >= GetDate()))) ORDER BY Lft
SQLPARAMETERS
array
1 2342342
2 global
www.gemeinsam-aktiv.de

Schnellsuche

www.gemeinsam-aktiv.de

Ehrenamtssuche Hessen