tests - Quarry

SQL

SELECT
	concat ('[[Special:Contributions/', log_title, '|', log_title, ']]' ) as 'Usuario',
    concat ('[[Special:Redirect/logid/', log_id, '|', log_id, ']]' ) as 'Registro',
    log_timestamp as 'Fecha',
    concat ('<nowiki>', comment_text, '</nowiki>') as 'Motivo'
FROM logging
JOIN actor
	ON actor.actor_id = logging.log_actor
JOIN comment
	ON comment.comment_id = logging.log_comment_id
WHERE actor.actor_name = 'LuchoCR'
	AND logging.log_type = 'block'
	AND logging.log_timestamp >= 20230821164800
    AND logging.log_timestamp <= 20230821165200
SQL

Checking query status...
