Unités : Différence entre versions

De geoLwiki - Guide géologique du Luxembourg
Ligne 2 : Ligne 2 :
  
  
{{#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}}
+
{{#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 7 juillet 2014 à 05: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}}