287 SELECT * FROM (SELECT node.typeId , node.lft, node.rgt, node.tableKey as masterTableKey, COUNT(parent.lft) - 1 as depth FROM (SELECT * FROM `lv_ref_types` WHERE typeId = '1') AS node, (SELECT * FROM `lv_ref_types` WHERE typeId = '1') AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt group by node.lft ORDER BY node.lft) as menu INNER JOIN (SELECT * FROM (SELECT * FROM(SELECT typeId , tableKey, CAST(AES_DECRYPT(lang, SHA2('9MpNhrPMqww2CB5M', 512)) AS CHAR) as lang, CAST(AES_DECRYPT( description, SHA2('9MpNhrPMqww2CB5M', 512)) AS CHAR) as description, CAST(AES_DECRYPT(note, SHA2('9MpNhrPMqww2CB5M', 512)) AS CHAR) as note FROM `lv_ref_types_lang`) as q ORDER BY CASE WHEN lang = 'sv' THEN 0 WHEN lang = 'en' THEN 11 WHEN lang = 'de' THEN 12 WHEN lang = 'fr' THEN 13 WHEN lang = 'it' THEN 14 ELSE 100 END LIMIT 18446744073709551615) as t ) AS lang ON menu.typeId = lang.typeId ORDER BY menu.lft

Projekt

Eslöv, Trollsjön

<<>>

<<>>

• Typ av anläggning : Flytande fontän

Ljuskällor utbyttes och nya flytelement dimensionerades och blev utbytta för att "ligga" bättre i vattnet.