Project

General

Profile

task #7455

Updated by Andreas Müller 11 months 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

Add picture from clipboard (Maximum size: 40 MB)