Untitled query #48739

SQL

SELECT
	a.actor_id,
    a.actor_name,
    rev.rev_timestamp,
    log.log_timestamp
FROM
	actor a
JOIN
	revision_userindex rev
	ON rev.rev_id = (
		SELECT rev2.rev_id
		FROM revision_userindex rev2
		WHERE rev2.rev_actor = a.actor_id
		ORDER BY rev2.rev_timestamp DESC
		LIMIT 1
    )
JOIN
	logging_userindex log
	ON log.log_id = (
		SELECT log2.log_id
		FROM logging_userindex log2
		WHERE log2.log_actor = a.actor_id
		ORDER BY log2.log_timestamp DESC
		LIMIT 1
    )
WHERE
	a.actor_name = 'Aldnonymous';
    
    dannys712@tools-sgebastion-07:~$ while read wiki; do echo "SELECT a.actor_id, a.actor_name, rev.rev_timestamp, log.log_timestamp FROM actor a JOIN revision_userindex rev ON rev.rev_id = ( SELECT rev2.rev_id FROM revision_userindex rev2 WHERE rev2.rev_actor = a.actor_id ORDER BY rev2.rev_timestamp DESC LIMIT 1 ) JOIN logging_userindex log ON log.log_id = ( SELECT log2.log_id FROM logging_userindex log2 WHERE log2.log_actor = a.actor_id ORDER BY log2.log_timestamp DESC LIMIT 1 ) WHERE a.actor_name = 'Aldnonymous';" | sql $wiki | sed "s/^/$wiki\t/g"; done < <(curl https://noc.wikimedia.org/conf/dblists/all.dblist)
SQL

Checking query status...
