=====Variable-Related Analyses=====

==== Process variable template ====
Variables bundled in groups of three perform better. It is better to use multiple groups of three than one giant group. It is even better if the //values// (Indices) from the view_instance can be employed. 
<code sql>
Select Variablen1.1, Variablen1.2, Variablen1.3 from
(
SELECT var1.stringvalue as '1', var2.stringvalue as '2', var3.stringvalue as '3', inst.ID 
FROM view_instance inst
LEFT join view_variable var1 on inst.ID = var1.instanceID and var1.name = ""					
LEFT join view_variable var2 on inst.ID = var2.instanceID and var2.name = ""					
LEFT join view_variable var3 on inst.ID = var3.instanceID and var3.name = ""					
where inst.definitionname = "xyz" AND inst.archiv = "false" AND inst.end IS NULL
) as Variablen1
INNER JOIN
(
SELECT var1.stringvalue as '1', var2.stringvalue as '2', var3.stringvalue as '3', inst.ID 
FROM view_instance inst
LEFT join view_variable var1 on inst.ID = var1.instanceID and var1.name = ""					
LEFT join view_variable var2 on inst.ID = var2.instanceID and var2.name = ""					
LEFT join view_variable var3 on inst.ID = var3.instanceID and var3.name = ""					
where inst.definitionname = "xyz" AND inst.archiv = "false" AND inst.end IS NULL
) as Variablen2 
ON Variablen1.ID = Variablen2.ID
</code>