Revision 12627
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql | ||
|---|---|---|
| 63 | 63 |
plot.authorlocationcode AS plot_code |
| 64 | 64 |
FROM ((plot |
| 65 | 65 |
JOIN locationevent USING (location_id)) |
| 66 |
JOIN project USING (project_id)) |
|
| 66 |
LEFT JOIN project USING (project_id))
|
|
| 67 | 67 |
WHERE ((plot.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown |
| 68 | 68 |
FROM (((((location |
| 69 | 69 |
JOIN locationevent locationevent_1 USING (location_id)) |
Also available in: Unified diff
validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB