| SELECT
CONCAT('[[', page.page_title, ']]') AS article,
... |
4 weeks ago |
| SELECT
CONCAT('[[', page.page_title, ']]') AS article,
... |
1 month ago |
| SELECT
CONCAT('[[', p.page_title, ']]') AS page_title,
fr.fr_rev_id... |
1 month ago |
| SELECT
p.page_title,
MIN(r2.rev_timestamp) AS... |
1 month ago |
| SELECT
p.page_title,
MIN(r2.rev_timestamp) AS... |
1 month ago |
| SELECT
p.page_title,
MIN(r2.rev_timestamp) AS... |
1 month ago |
| WITH FirstUnpatrolled AS (
SELECT
p.page_id,
... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| SELECT DISTINCT p.page_title
FROM page p
JOIN revision r1 ON p.page_id =... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| SELECT
p.page_id,
p.page_title,
r1.rev_id AS patrolled_rev_id,
... |
1 month ago |
| WITH reviewed_revs AS (
SELECT
fr.fr_page_id,
fr.fr_rev_id,
... |
1 month ago |
| WITH reviewed_revs AS (
SELECT
fr.fr_page_id,
fr.fr_rev_id,
... |
1 month ago |
| WITH reviewed_revs AS (
SELECT
fr.fr_page_id,
fr.fr_rev_id,
... |
1 month ago |
| SELECT
CONCAT('[[', page.page_title, ']]') AS article,
... |
1 month ago |
