| SELECT LEFT(created,6) AS created_yyyymm,
COUNT(*) AS unreviewed_count
FROM... |
1 year ago |
| SELECT LEFT(created,6) AS created_yyyymmdd,
COUNT(*) AS... |
2 years ago |
| SELECT LEFT(created,7) AS created_yyyymmdd,
COUNT(*) AS... |
2 years ago |
| SELECT LEFT(created,8) AS created_yyyymmdd,
COUNT(*) AS... |
2 years ago |
| SELECT LEFT(created,8) AS created_yyyymmdd,
COUNT(*) AS... |
2 years ago |
| SELECT COUNT(*) as `Article Reviews`
FROM (
SELECT distinct... |
2 years ago |
| SELECT COUNT(*) as `Article Reviews`
FROM (
SELECT distinct... |
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 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 AS `Reviewer`,
COUNT(*) as `Reviews`
FROM (
... |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(*) as `Reviews`
FROM (
... |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
2 years ago |
| select ptrl_timestamp, user_name from pagetriage_log JOIN user ON user_id =... |
2 years ago |
| select * from pagetriage_log order by ptrl_timestamp desc limit 10; |
2 years ago |
| select max(ptrl_timestamp) from pagetriage_log; |
2 years ago |
| desc pagetriage_log; |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
2 years ago |
| SELECT actor_name AS `Reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
2 years ago |
| select date() from page; |
2 years ago |
| select date(); |
2 years ago |
| desc page; |
2 years ago |
| desc pagetriage_page; |
2 years ago |
| SELECT actor_name, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT actor_name, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT actor_name, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| desc actor |
2 years ago |
| SELECT username, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT actor.name, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT rev_actor, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT rev_actor, page_title, page_id, rev_timestamp
FROM... |
2 years ago |
| SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
... |
2 years ago |
| SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
... |
2 years ago |
| SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
... |
2 years ago |
| SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
... |
2 years ago |
| SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
... |
2 years ago |
| SELECT actor_name as 'creator',
count(*) as 'count'
FROM... |
2 years ago |
| SELECT actor_name as 'creator',
count(*) as 'count'
FROM... |
2 years ago |
| SELECT rev_actor as 'creator',
count(*) as 'count'
FROM... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| SELECT CONCAT('[[',
(CASE page_namespace
WHEN 0... |
2 years ago |
| DESCRIBE page; |
2 years ago |
| DESCRIBE watchlist; |
2 years ago |
