WITH base_table AS (
SELECT DISTINCT
rev_id,
rev_actor,
... |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits,
... |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits,
... |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
3 weeks ago |
SELECT
*
FROM
text
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
pagecontent
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
text
LIMIT 5 |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
3 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
3 weeks ago |
SELECT
COUNT(DISTINCT rev_id)
FROM
revision
JOIN
page
ON rev_page... |
3 weeks ago |
SELECT
rev_id,
page_title
FROM
revision
JOIN
page
ON rev_page =... |
3 weeks ago |
SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
3 weeks ago |
SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
3 weeks ago |