Revision 5975
Added by Aaron Marcuse-Kubitza about 12 years ago
| mappings/verify.plots.sql | ||
|---|---|---|
| 25 | 25 |
|
| 26 | 26 |
SELECT '# locations' AS ___; |
| 27 | 27 |
SELECT count(DISTINCT location_id) AS count |
| 28 |
FROM locationevent
|
|
| 28 |
FROM location |
|
| 29 | 29 |
WHERE reference_id = |
| 30 | 30 |
(SELECT reference_id FROM reference WHERE shortname = :datasource) |
| 31 | 31 |
AND parent_id IS NULL -- no subplots |
Also available in: Unified diff
mappings/verify.plots.sql: # locations: Fixed bug where need to use location instead of locationevent