Query Run
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
#SELECT DISTINCT log_type, # log_action #FROM logging #ORDER... 10 months ago
SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type,... 10 months ago
SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type,... 10 months ago
SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type,... 10 months ago
SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type,... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM user JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM USER JOIN... 10 months ago
WITH Admins AS (SELECT user_name, user_id FROM USER JOIN... 10 months ago
With Admins AS (SELECT user_name, user_id FROM user JOIN user_groups ON... 10 months ago
With Admins AS (SELECT user_name, user_id FROM user JOIN user_groups ON... 10 months ago
With Admins AS (SELECT user_name, user_id FROM user JOIN user_groups ON... 10 months ago
With Admins AS (SELECT user_name, user_id FROM user JOIN user_groups ON... 10 months ago
With Admins AS (SELECT user_name, user_id FROM user JOIN user_groups ON... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
With ActorLog AS (SELECT log_type, log_action, actor_user FROM logging JOIN... 10 months ago
SELECT user_name, COUNT(CASE WHEN log_type = 'abusefilter' THEN 1... 10 months ago
SELECT user_name, COUNT(CASE WHEN log_type = 'abusefilter' THEN 1... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON actor_id =... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
CREATE FUNCTION GetLogTypeCount(log_type_val VARCHAR(255), user_id_val INT)... 10 months ago
DELIMITER // CREATE FUNCTION GetLogTypeCount(log_type_val VARCHAR(255),... 10 months ago
CREATE FUNCTION GetLogTypeCount(log_type_val VARCHAR(255), user_id_val INT)... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT u.user_name, COUNT(CASE WHEN l.log_type = 'abusefilter' AND... 10 months ago
SELECT u.user_name, COUNT(CASE WHEN l.log_type = 'abusefilter' AND... 10 months ago
SELECT u.user_name, COUNT(CASE WHEN l.log_type = 'abusefilter' AND... 10 months ago
SELECT u.user_name, COUNT(CASE WHEN l.log_type = 'abusefilter' AND... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
SELECT user_name, (SELECT count(*) FROM logging JOIN actor ON... 10 months ago
select user_name, (select count(*) from logging join actor on actor_id =... 10 months ago
select *, (select count(*) from logging join actor on actor_id = log_actor ... 10 months ago
select *, (select count(*) from logging join actor on actor_id = log_actor ... 10 months ago
select user_name, (select count(*) from logging join actor on actor_id =... 10 months ago
select user_name from user join user_groups on user_id = ug_user where... 10 months ago
select user_name from user join user_groups on user_id = ug_user where... 10 months ago
select user_name, (select count(*) from logging join actor on actor_id =... 10 months ago
select count(*) from logging join actor on actor_id = log_actor ... 10 months ago
select user_name, (select count(*) from logging join actor on actor_id =... 10 months ago
select user_name, (select count(*) from logging join actor on actor_id =... 10 months ago
select (select user_name from user join user_groups on user_id = ug_user... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type in... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type in... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type in... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type in... 10 months ago
select actor_name, count(*) from logging join actor on actor_id =... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name from logging join actor on actor_id = log_actor where... 10 months ago
select actor_name, * from logging join actor on actor_id = log_actor where... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type =... 10 months ago
select actor_name, * from logging join actor on actor_id = log_actor where... 10 months ago
select * from logging join actor on actor_id = log_actor where log_type =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select user_id, user_name from user join user_groups on user_id =... 10 months ago
select * from user join user_groups on user_id = ug_user where ug_group =... 10 months ago
select * from user join user_groups on user_id = ug_user limit 10 10 months ago
select * from user limit 10 10 months ago
select * from logging 10 months ago
use hywiki_p; SELECT page.page_title, revision.rev_len AS len FROM page,... 4 years ago
use hywiki_p; select NOW() - INTERVAL 30 DAY AND NOW(); 4 years ago
use hywiki_p; select CURDATE(); 4 years ago
use hywiki_p; select datetime('now', '-30 days'); 4 years ago
use hywiki_p; select DateDiff(day, 20200101000000, 20190101000000); 4 years ago
use hywiki_p; select DateDiff(day, '20200101000000', '20190101000000'); 4 years ago
use hywiki_p; select DateDiff(day, '20200101000000', '20190101000000'); 4 years ago
use hywiki_p; select DateDiff(day, '20200101000000', '20190101000000'); 4 years ago
use hywiki_p; select DateDiff(day, CURRENT_TIMESTAMP, '20190101000000'); 4 years ago
use hywiki_p; select DateDiff(day, CURRENT_TIMESTAMP, '20190101000000'); 4 years ago
use hywiki_p; select datediff(day, CURRENT_TIMESTAMP, '20190101000000'); 4 years ago
use hywiki_p; select CURRENT_TIMESTAMP > '20190101000000'; 4 years ago
use hywiki_p; select CURRENT_TIMESTAMP < '20190101000000'; 4 years ago
use hywiki_p; select CURRENT_TIMESTAMP > '20190101000000'; 4 years ago
use hywiki_p; select CURRENT_TIMESTAMP; 4 years ago
use hywiki_p; select getdate(); 4 years ago
select getdate(); 4 years ago
SELECT page_title, rev_timestamp, rev_user_text FROM hywiki_p.page p INNER... 8 years ago