feature request #7440
closed
- Status changed from New to In Progress
- % Done changed from 0 to 70
Done. Still needs to be tested.
- Status changed from In Progress to Resolved
- % Done changed from 70 to 90
The markers were imported
- Status changed from Resolved to Closed
- % Done changed from 90 to 100
I checked the final import result and it looks ok.
SELECT r.id, r.uuid, r.titleCache, m.flag, mt.titleCache, mt.id
FROM Reference r INNER JOIN Reference_Marker MN ON MN.Reference_id = r.id INNER JOIN Marker m ON m.id = MN.markers_id
INNER JOIN DefinedTermBase mt ON mt.id = m.markerType_id
WHERE mt.id = 965
;
SELECT DISTINCT osb.citation_id
-- SELECT deb.id, MN.*, osb.id, feature.id, osb.citation_id, osb.sourceType
FROM DescriptionElementBase deb INNER JOIN DescriptionElementBase_OriginalSourceBase MN ON MN.DescriptionElementBase_id = deb.id
INNER JOIN OriginalSourceBase osb ON osb.id = MN.sources_id
INNER JOIN DefinedTermBase feature ON deb.feature_id = feature.id
WHERE feature.id = 991 AND osb.sourceType <> 'DIM'
Also available in: Atom
PDF