Revision 12167
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql | ||
|---|---|---|
| 187 | 187 |
join taxonverbatim tv on td.taxonverbatim_id=tv.taxonverbatim_id |
| 188 | 188 |
where s.shortname=current_schema and td.isoriginal='t' |
| 189 | 189 |
group by p.projectname, l.authorlocationcode |
| 190 |
order by p.projectname, l.authorlocationcode 12;
|
|
| 190 |
order by p.projectname, l.authorlocationcode; |
|
| 191 | 191 |
|
| 192 | 192 |
-- ------------------ |
| 193 | 193 |
-- 13. List of distinct verbatim taxa in each plot in each project |
Also available in: Unified diff
validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _12_count_of_verbatim_taxa_per_plot_in_each_project: removed typo (in the original queries, not added by the refactoring)