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