SQL
AخA
SELECT COUNT(DISTINCT log_namespace, log_title) AS 'all patrols',
COUNT(DISTINCT log_namespace, log_title, IF(log_namespace = 0, 1, NULL)) AS 'mainspace patrols'
FROM logging_userindex
JOIN actor_logging ON log_actor = actor_id
WHERE actor_name='Elli'
AND ((log_type = 'patrol' AND log_action = 'patrol')
OR (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article', 'reviewed-redirect')));
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.