sysop2020 temp2

SQL

USE plwiki_p;

CREATE TEMPORARY TABLE #admin_stats (
	admin_id				int,
	admin_name				varchar(255),
	first_admin_dt			bigint,
	
	registration_dt			bigint,
	first_edit_dt			bigint,
	
	edits_pre_sysop			bigint,
	
	gender 		varchar(100),
);

INSERT INTO #admin_stats (admin_name, first_admin_dt, admin_id)
SELECT log_title, min(log_timestamp), min(user_id)
FROM logging l
LEFT JOIN user u ON user_name=REPLACE(log_title,'_',' ')
WHERE log_type = 'rights' AND log_namespace = '2' AND log_params like '%sysop%'
GROUP BY log_title
ORDER BY 2 ASC
;

SELECT * from #admin_stats;
SQL

Checking query status...
