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