{{{
#!comment
<LEFT-MENU>
}}}
{{{
#!div style="width:15%; float:left; clear:none; margin-right:1em; background:#ffb; border:1px solid #b00; padding-left:1em; padding-right:1em"
[wiki:WikiStart Home] [[BR]] [[BR]]
'''TOL''' [[BR]] [wiki:Software Software] [[BR]] [wiki:Download Download] [[BR]] [wiki:Installation Installation] [[BR]] [wiki:Packages Packages] [[BR]] [wiki:OTAN OTAN] [[BR]] [[BR]]
'''TOL Project''' [[BR]] [wiki:About About TOL] [[BR]] [wiki:Manuals Manuals] [[BR]] [wiki:Development Development] [[BR]] [wiki:Rprojects R-Projects] [[BR]] [[BR]]
'''Other Links''' [[BR]] [wiki:TracGuide Trac Guide] [[BR]] [wiki:WikiTree Wiki Tree] [[BR]] [https://mms.tol-project.org MMS]  
}}}
{{{
#!div style="margin-left:20%; margin-right:20%; padding-left:2em; padding-right:2em"
{{{
#!comment
</LEFT-MENU>
}}}

= Left Menu =

This page contains the left menu used in the main pages. 

The menu in this page can be applied to the others using the following query:
{{{
#!sql
UPDATE tolsch.wiki a
SET text = regexp_replace(a.text, '<LEFT-MENU>.*?</LEFT-MENU>', m.lmenu) 
FROM (
  SELECT name, Max(version) as version
  FROM tolsch.wiki
  WHERE text LIKE '%<LEFT-MENU>%' AND name <> 'LeftMenu' 
  GROUP BY name
) av, (
  SELECT (regexp_matches(text, '<LEFT-MENU>.*?</LEFT-MENU>'))[1] as lmenu
  FROM tolsch.wiki b, (
    SELECT Max(version) as version
    FROM tolsch.wiki
    WHERE name = 'LeftMenu'
  ) bv
  WHERE b.name = 'LeftMenu' AND b.version = bv.version
) m
WHERE a.name = av.name AND a.version = av.version
}}}