User:Tim Starling/Reddi watchlist SQL

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Hey look everyone, I worked out how to use "group by"!

SQL query:
select old_namespace,old_title from old,user where old_user=user_id AND user_name='Reddi' group by old_title limit 1000

select cur_namespace,cur_title from cur,user where cur_user=user_id AND user_name='Reddi' AND cur_is_new=1 group by cur_title limit 1000

This is a list of articles Reddi has edited. See User:Tim Starling/Reddi watchlist for a human-edited list.