SELECT *, TOPICS.ID AS TOPICSID, STRUCTURE.ID AS STRUCTID,DYNAMICCONSTANTS.IDSITE,TOPICS.TITLE,STRUCTURE.EXPORTURL, DYNAMICCONSTANTS.CONSTANTNAME,DYNAMICCONSTANTS.CONSTANTVALUE FROM DYNAMICCONSTANTS INNER JOIN (STRUCTURE INNER JOIN TOPICS ON STRUCTURE.ID = TOPICS.IDSTRUCTURE) ON DYNAMICCONSTANTS.IDSITE = STRUCTURE.IDSITE WHERE ((STRUCTURE.IDSITE = '#ID_Site#') AND ((DYNAMICCONSTANTS.CONSTANTNAME)='HOMEURL')) ORDER BY MENUFULLTREE;

SELECT ID, CHILDOF FROM STRUCTURE WHERE (STRUCTURE.ID = #myParentID#); SELECT ID FROM STRUCTURE WHERE CHILDOF = #StructID#;

Menu for Bürgenstock #year#

Contact the Administrator of the webiste

#final#No title#myTitle# -- Rename "#ExportURL#" into an explicit name --