Untitled query #39629

SQL

USE ilowiki_p;

/*
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 = 'Pmlineditor';
*/

/*
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 = 'Pmlineditor';
*/
SQL

Checking query status...
