Revision 58353
Added by Michele Artini about 4 years ago
| schema.sql | ||
|---|---|---|
| 221 | 221 |
ORDER BY u.email; |
| 222 | 222 |
|
| 223 | 223 |
CREATE VIEW suggestions_info_by_country_view AS SELECT c.val AS country, |
| 224 |
0::int8 AS n_groups, |
|
| 225 | 224 |
coalesce(t1.n_duplicates, 0) AS n_duplicates, |
| 226 | 225 |
coalesce(t2.n_conflicts, 0) AS n_conflicts |
| 227 | 226 |
FROM countries c |
Also available in: Unified diff
removed unused tab (groups)