|
1
|
ERRORS in ERMS
|
|
2
|
=====================
|
|
3
|
|
|
4
|
- there is one case, where a nomen nudum is the accepted taxon for an other taxon
|
|
5
|
|
|
6
|
SELECT dbo.tu.tu_status, tu_1.tu_acctaxon, tu_1.id, dbo.tu.tu_displayname
|
|
7
|
FROM dbo.tu INNER JOIN
|
|
8
|
dbo.tu AS tu_1 ON dbo.tu.id = tu_1.tu_acctaxon
|
|
9
|
WHERE (dbo.tu.tu_status = 3) OR
|
|
10
|
(tu_1.id = 111846) OR
|
|
11
|
(tu_1.id = 111850)
|
|
12
|
|
|
13
|
- there are 448 cases where the tu_acctaxon has not a status "accepted"
|
|
14
|
|
|
15
|
SELECT dbo.tu.tu_status AS acceptedStatus, dbo.tu.tu_displayname AS acceptedName, unaccepted.tu_status AS unacceptedStatus,
|
|
16
|
unaccepted.tu_displayname AS unacceptedName
|
|
17
|
FROM dbo.tu INNER JOIN
|
|
18
|
dbo.tu AS unaccepted ON dbo.tu.id = unaccepted.tu_acctaxon
|
|
19
|
WHERE (dbo.tu.tu_status <> 1)
|
|
20
|
ORDER BY acceptedStatus, unacceptedStatus
|
|
21
|
|
|
22
|
- 289 cases where parent taxon is not accepted (is this allowed ?)
|
|
23
|
|
|
24
|
- there are 46 taxa with a status not accepted, a parent not accepted and an parent.tu_acctaxon not accepted
|
|
25
|
|
|
26
|
SELECT TOP (100) PERCENT tu_1.id, tu_1.tu_status, accTaxon.tu_status AS accStatus, parent.tu_status AS parentStatus,
|
|
27
|
accParent.tu_status AS accParentStatus, tu_1.tu_displayname AS displayname, parent.tu_displayname AS parentdisplayname, tu_1.tu_acctaxon,
|
|
28
|
dbo.status.status_name, dbo.status.status_id AS myStatus, parent.id AS parentId, tu_1.tu_sp
|
|
29
|
FROM dbo.status RIGHT OUTER JOIN
|
|
30
|
dbo.tu AS accTaxon RIGHT OUTER JOIN
|
|
31
|
dbo.tu AS tu_1 ON accTaxon.id = tu_1.tu_acctaxon LEFT OUTER JOIN
|
|
32
|
dbo.tu AS parent ON tu_1.tu_parent = parent.id ON dbo.status.status_id = tu_1.tu_status LEFT OUTER JOIN
|
|
33
|
dbo.tu AS accParent ON parent.tu_acctaxon = accParent.id
|
|
34
|
WHERE (tu_1.tu_status <> 1) AND (parent.tu_status <> 1) AND (accParent.tu_status <> 1)
|
|
35
|
ORDER BY accParentStatus, parentStatus
|
|
36
|
|
|
37
|
- there are 27 taxa with a status not accepted, a parent not accepted and an parent.tu_acctaxon not accepted and an tu_acctaxon not accepted
|
|
38
|
|
|
39
|
SELECT TOP (100) PERCENT tu_1.id, tu_1.tu_status, accTaxon.tu_status AS accStatus, parent.tu_status AS parentStatus,
|
|
40
|
accParent.tu_status AS accParentStatus, tu_1.tu_displayname AS displayname, parent.tu_displayname AS parentdisplayname, tu_1.tu_acctaxon,
|
|
41
|
dbo.status.status_name, dbo.status.status_id AS myStatus, parent.id AS parentId, tu_1.tu_sp
|
|
42
|
FROM dbo.status RIGHT OUTER JOIN
|
|
43
|
dbo.tu AS accTaxon RIGHT OUTER JOIN
|
|
44
|
dbo.tu AS tu_1 ON accTaxon.id = tu_1.tu_acctaxon LEFT OUTER JOIN
|
|
45
|
dbo.tu AS parent ON tu_1.tu_parent = parent.id ON dbo.status.status_id = tu_1.tu_status LEFT OUTER JOIN
|
|
46
|
dbo.tu AS accParent ON parent.tu_acctaxon = accParent.id
|
|
47
|
WHERE (tu_1.tu_status <> 1) AND (parent.tu_status <> 1) AND (accParent.tu_status <> 1) AND (accTaxon.tu_status <> 1)
|
|
48
|
ORDER BY accParentStatus, parentStatus
|