| Index: trunk/tools/wsor/contribution_inequality/contrib.sql |
| — | — | @@ -1,9 +1,9 @@ |
| 2 | 2 | -- user ranking by contribution per namespace per year for main, talk, |
| 3 | 3 | -- wikipedia, wikipedia talk |
| 4 | | -describe |
| | 4 | + |
| 5 | 5 | select namespace, year, user_id, sum(edits) as total_contributions |
| 6 | 6 | from halfak.giovanni |
| 7 | | -where namespace in (0,1,4,5) |
| | 7 | +where namespace in (0,1,4,5) and user_id > 0 |
| 8 | 8 | group by user_id, namespace, year |
| 9 | | -order by namespace asc, year asc, total_contributions desc; |
| | 9 | +-- having total_contributions >= 1000 |
| | 10 | +order by namespace, year, total_contributions; |