| USE bnwiki_p;
select substr(rev_timestamp,1,4) as Year,... |
7 months ago |
| USE bnwiki_p;
select substr(rev_timestamp,1,4) as Year,... |
1 year ago |
| USE bnwiki_p;
select substr(rev_timestamp,1,4) as Year,... |
1 year ago |
| USE bnwiki_p;
select substr(rev_timestamp,1,4) as dated,... |
1 year ago |
| USE bnwiki_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
1 year ago |
| USE bnwiki_p;
SELECT substr(rev.rev_timestamp,1,6) dated,
... |
1 year ago |
| use bnwiki_p;
SELECT substr(rev_timestamp,1,6) as... |
1 year ago |
| USE bnwiki_p;
select substr(rev_timestamp,1,6) as dated,... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| USE bnwiki_p;
select substr(rev_timestamp,1,6) as dated,... |
1 year ago |
| SELECT actor_name, COUNT(DISTINCT substring(rev_timestamp, 1, 8)) as... |
1 year ago |
| SELECT page_title, COUNT(rev_id) AS edits
FROM
revision
JOIN page ON... |
1 year ago |
| SELECT Count(log_id),
actor_name
FROM logging_userindex
... |
1 year ago |
| SELECT Count(log_id),
actor_name
FROM logging_userindex
... |
1 year ago |
| SELECT page_title
FROM page AS... |
2 years ago |
| SELECT
actor_name,
bot.ug_group AS is_bot,
admin.ug_group AS... |
2 years ago |
| SELECT
actor_name,
bot.ug_group AS is_bot,
admin.ug_group AS... |
2 years ago |
| USE bnwiki_p;
SELECT
up_value,
COUNT(DISTINCT up_user)
FROM... |
2 years ago |
| SELECT count(*)
FROM page AS... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS year,
... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
| USE commonswiki_p;
SELECT COUNT(img_name) AS... |
2 years ago |
| select * /*sum(tdif)*/
from
(select
actor_name,
sum( cast(rc_new_len as... |
2 years ago |
| SELECT DISTINCT Creator
FROM (
SELECT actor_name as Creator,
COUNT(*)... |
2 years ago |
| SELECT DISTINCT Creator
FROM (
SELECT actor_name as Creator,
COUNT(*)... |
2 years ago |
| SELECT p.page_title AS "Page Title", COUNT(ct.ct_rev_id) AS n_rollback FROM... |
2 years ago |
| USE bnwiki_p;
SELECT log_title, COUNT(*)
FROM logging
WHERE... |
2 years ago |
| SELECT log_timestamp, log_id, actor_name, log_title, comment_text
FROM... |
2 years ago |
| SELECT log_timestamp, log_id, actor_name, log_title, comment_text
FROM... |
2 years ago |
| SELECT log_timestamp, log_id, actor_name, log_title, comment_text
FROM... |
2 years ago |
| SELECT log_timestamp, log_id, actor_name, log_title, comment_text
FROM... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect... |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect... |
2 years ago |
| SELECT
actor_name,
bot.ug_group AS is_bot,
admin.ug_group AS... |
2 years ago |
| SELECT
year,
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
... |
2 years ago |
| SELECT
year,
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
... |
2 years ago |
| SELECT
year,
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
... |
2 years ago |
| use bnwiki_p;
select count(user_name) as users25,
count(case when... |
2 years ago |
| SELECT
actor_logging.actor_user,
actor_logging.actor_name,
COUNT(*)... |
2 years ago |
| USE bnwiki_p;
SELECT rc_namespace, page_is_redirect, COUNT(*) AS... |
2 years ago |
| select CONCAT('[[User talk:', page_title, ']]') as user_talk -- format as... |
2 years ago |
