EDIT

task #7455

Updated by Andreas Müller over 5 years ago

Check if all existing markers are still up-to-date with the current E+M import strategy. 


 ~~~ 
 SELECT flag, dtb.titleCache, count(*) as n 
 FROM Marker m INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id  
 GROUP BY flag, titleCache 
 ORDER BY n, titleCache, flag; 

 SELECT deb.DTYPE, deb.feature_id, dtb.titleCache 
 FROM DescriptionElementBase deb 
  INNER JOIN DescriptionElementBase_Marker MN ON MN.DescriptionElementBase_id = deb.id 
  INNER JOIN Marker m ON m.id = MN.markers_id 
  INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id  
  ORDER BY deb.DTYPE, dtb.titleCache 
 ~~~

Back