Unités : Différence entre versions

De geoLwiki - Guide géologique du Luxembourg
Ligne 2 : Ligne 2 :
  
  
{{#sql2wiki_t:select concat('[[',abrevstrat,']]') as "Symbole",concat('[[',abrevstrat,'|',nomunit_fr,']]')as "Nom", nomunit_de as "Name",DESCUNIT_FR as "Description" ,grouping1_fr as "Sous-ère/Système",ERE_FR as "Ere", grouping2_fr as "Sous-système/Groupe",age_fr as "Etage", STRUCTUNIT_FR as "Unité structurale", concat('<sup>',codestratunit,'</sup>') as "Code" from stratunit order by ordrestrat}}
+
{{#sql2wiki_t:select concat('[[',abrevstrat2,'|',abrevstrat,']]') as "Symbole",concat('[[',abrevstrat2,'|',nomunit_fr,']]')as "Nom", nomunit_de as "Name",DESCUNIT_FR as "Description" ,grouping1_fr as "Sous-ère/Système",ERE_FR as "Ere", grouping2_fr as "Sous-système/Groupe",age_fr as "Etage", STRUCTUNIT_FR as "Unité structurale", concat('<sup>',codestratunit,'</sup>') as "Code" from stratunit order by ordrestrat}}

Version du 10 décembre 2010 à 10:25

Unités géologiques utilisées dans la stratigraphie du Luxembourg, d'âge croissant du haut vers le bas:


{{#sql2wiki_t:select concat('',abrevstrat,'') as "Symbole",concat('',nomunit_fr,'')as "Nom", nomunit_de as "Name",DESCUNIT_FR as "Description" ,grouping1_fr as "Sous-ère/Système",ERE_FR as "Ere", grouping2_fr as "Sous-système/Groupe",age_fr as "Etage", STRUCTUNIT_FR as "Unité structurale", concat('',codestratunit,'') as "Code" from stratunit order by ordrestrat}}