Registered users on the French Wikibooks that became inactive

This query is marked as a draft This query has been published by Ash Crow.

This lists all registered users on the French Wikibooks that:
- have made edits in the past
- but no edit for a year

with the date of the last edit and the total of edits.

SQL

USE frwikibooks_p;
SELECT rev_actor, actor_name, MAX(rev_timestamp) AS last_edit
FROM revision 
JOIN actor ON revision.rev_actor=actor.actor_id 
WHERE actor_user IS NOT NULL # Only registered users
GROUP BY rev_actor
HAVING last_edit < 20190609000000
ORDER BY DESC(last_edit); # Last edit is older than one year as of June 9, 2020

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...