Revision 5999
Added by Aaron Marcuse-Kubitza almost 12 years ago
verify.plots.sql | ||
---|---|---|
23 | 23 |
ORDER BY projectname |
24 | 24 |
; |
25 | 25 |
|
26 |
SELECT '# locations' AS ___; |
|
26 |
SELECT '# top-level locations' AS ___;
|
|
27 | 27 |
SELECT count(DISTINCT location_id) AS count |
28 | 28 |
FROM location |
29 | 29 |
WHERE reference_id = |
... | ... | |
31 | 31 |
AND parent_id IS NULL -- no subplots |
32 | 32 |
; |
33 | 33 |
|
34 |
SELECT '# location events' AS ___; |
|
34 |
SELECT '# top-level location events' AS ___;
|
|
35 | 35 |
SELECT count(*) AS count |
36 | 36 |
FROM locationevent |
37 | 37 |
WHERE reference_id = |
Also available in: Unified diff
mappings/verify.plots.sql: Added "top-level" to # locations, # location events names because these queries do not include all locations