User:Sj/questionsofdata

See also http://meta.wikipedia.org/wiki/Requests_for_queries.

Q1: "Which articles have I started?" Try the following, with a suitable JOIN and ORDER BY. SELECT old_title as title, old_timestamp as time FROM  old o1 WHERE  old_user = YOURUSERID AND old_timestamp=(SELECT MAX(o2.old_timestamp)         FROM old o2         WHERE o1.old_title = o2.old_title);

SELECT cur_title as title, cur_timestamp as time FROM  cur WHERE cur_user = YOURUSERID AND cur_title NOT IN (SELECT DISTINCT title FROM old);

Q2: "Which articles was I last to edit?" SELECT cur_title as title, cur_timestamp as time FROM  cur WHERE cur_user = YOURUSERID