Index: doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql
===================================================================
diff -u -r3ab625a7c585b86be669fef127b79d73c0de1d7e -reba87a69b5f3d8e882af08ccd0784fc012c874b3
--- doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql	(.../All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql)	(revision 3ab625a7c585b86be669fef127b79d73c0de1d7e)
+++ doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql	(.../All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql)	(revision eba87a69b5f3d8e882af08ccd0784fc012c874b3)
@@ -9,9 +9,9 @@
   sum(case when mat.PN_Name = 'DiameterD70' then mat.PV_Value end) DiameterD70,
   sum(case when mat.PN_Name = 'WhitesConstant' then mat.PV_Value end) WhitesConstant,
   sum(case when mat.PN_Name = 'BeddingAngle' then mat.PV_Value end) BeddingAngle
-FROM MechanismPointLocation as m 
-JOIN MechanismPointLocation as mpl ON p.SP2D_ID = mpl.SP2D_ID 
-JOIN SoilProfile2D as p ON m.SP2D_ID = p.SP2D_ID 
+FROM Mechanism as m
+JOIN MechanismPointLocation as mpl ON mpl.ME_ID = m.ME_ID
+JOIN SoilProfile2D as p ON p.SP2D_ID = mpl.SP2D_ID 
 JOIN SoilLayer2D as l ON l.SP2D_ID = p.SP2D_ID 
 JOIN (
   SELECT m.MA_ID, pn.PN_Name, pv.PV_Value
@@ -22,5 +22,5 @@
   SELECT pv.SL2D_ID, pn.PN_Name, pv.PV_Value
   FROM ParameterNames as pn
   JOIN LayerParameterValues as pv ON pn.PN_ID = pv.PN_ID) as lpv ON lpv.SL2D_ID = l.SL2D_ID
-WHERE m.ME_ID = 4
+WHERE m.ME_Name = "Piping"
 GROUP BY l.SL2D_ID
\ No newline at end of file