Query Run
SELECT SUBSTR(log_timestamp,1,8), actor_name as 'Usuario',... 1 year ago
SELECT SUBSTR(log_timestamp,1,8), actor_name as 'Usuario',... 1 year ago
SELECT substr(log_timestamp,1,6) AS AAAAMM, count(*) AS TOTAL FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL FROM... 1 year ago
"SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL FROM... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*) ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*) ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*) ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*) ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*) ... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_es_delete FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_es_delete FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_en_delete FROM... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as TOTAL_en_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAA, COUNT(*) as TOTAL_en_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_es FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_es FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL_es FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL-es FROM... 1 year ago
/* Artículos borrados por aos */ SELECT substr(log_timestamp,1,4) AS AAAA,... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL FROM... 1 year ago
select SUBSTR(log_timestamp,1,4), count(*) from logging where log_action =... 1 year ago
select SUBSTR(log_timestamp,1,4), count(*) from logging where log_action =... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select SUBSTR(log_timestamp,1,4), count(*) from logging where log_action =... 1 year ago
select SUBSTR(log_timestamp,1,4), count(*) from logging where log_type like... 1 year ago
select SUBSTR(log_timestamp,1,4), count (*) from logging where log_type like... 1 year ago
select SUBSTR(log_timestamp,1,4), count (*) from logging where log_type like... 1 year ago
select SUBSTR(log_timestamp,1,4),count (*) from logging where log_type like... 1 year ago
use eswiki_p; select log_title, log_timestamp from logging where log_type... 1 year ago
use arwiki_p; select log_title, log_timestamp from logging where log_type... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL FROM... 1 year ago
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS... 1 year ago
select log_namespace, count(*) from logging where log_action = 'delete' #... 1 year ago
select substr(log_timestamp,1,4), count(*) from logging where log_action =... 1 year ago
select substr(log_timestamp,1,4), count(*) from logging where log_action =... 1 year ago
select substr(log_timestamp,1,6), count(*) from logging where log_action =... 1 year ago
SELECT SUBSTR(ar_timestamp,1,6), COUNT(*) FROM archive WHERE #... 1 year ago
SELECT SUBSTR(ar_timestamp,1,6), COUNT(*) FROM archive WHERE ... 1 year ago
SELECT actor_name, user_registration, user_editcount, ar_id, ar_namespace,... 1 year ago
SELECT actor_name, user_registration, user_editcount, ar_id, ar_namespace,... 1 year ago
SELECT substr(log_timestamp,1,6), COUNT(*) FROM logging WHERE log_action =... 1 year ago
SELECT SUBSTR(rev_timestamp,1,4), COUNT(*) FROM revision WHERE rev_deleted... 1 year ago
SELECT SUBSTR(rev_timestamp,1,4), COUNT(*) FROM revision WHERE rev_deleted... 1 year ago
SELECT SUBSTR(rev_timestamp,1,4),count(*), FROM revision WHERE rev_deleted... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,4) as AAAA, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,6) as AAAAMM, count(*) from... 1 year ago
select log_type, SUBSTR(log_timestamp,1,6) as AAAAMM, count(*) from... 1 year ago
SELECT count(*), ug_group from user_groups GROUP BY ug_group 1 year ago
select log_type, count(*) from logging_compat GROUP by log_type 1 year ago
select * from logging_compat limit 10 1 year ago
describe logging_compat 1 year ago
select * from (logging as logdel inner join logging_compat as logcr on... 1 year ago
select * from (logging as logdel inner join logging_compat as logcr on... 1 year ago