Revision 1302
Added by Aaron Marcuse-Kubitza almost 13 years ago
| mappings/verify.specimens.sql | ||
|---|---|---|
| 91 | 91 |
(SELECT party_id FROM party WHERE organizationname = :datasource) |
| 92 | 92 |
GROUP BY catalognumber_dwc |
| 93 | 93 |
HAVING count(*) > 1 |
| 94 |
ORDER BY catalognumber_dwc NULLS FIRST/* to match MySQL */ |
|
| 94 | 95 |
; |
| 95 | 96 |
|
| 96 | 97 |
SELECT '# counties' AS ___; |
Also available in: Unified diff
mappings/verify.specimens.sql: Use ORDER BY ... NULLS FIRST to match MySQL