| WITH patrol_logs AS (
SELECT
log_id,
log_timestamp AS... |
4 months ago |
| WITH base AS (
SELECT
CURDATE() AS date,
CURDATE() -... |
4 months ago |
| WITH base AS (
SELECT
CURDATE() AS date,
CURDATE() -... |
4 months ago |
| WITH base AS (
SELECT
CURDATE() AS date,
CURDATE() -... |
4 months ago |
| WITH base AS (
SELECT
CURDATE() AS date,
CURDATE() -... |
4 months ago |
| WITH base AS (
SELECT
DATE(CURDATE()) AS date,
... |
4 months ago |
| WITH base_table AS (
SELECT DISTINCT
rev_id,
rev_actor,
... |
6 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits,
... |
7 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits,
... |
7 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
7 months ago |
| SELECT
*
FROM
text
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
pagecontent
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
text
LIMIT 5 |
7 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
7 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
7 months ago |
| SELECT
YEAR(rev_timestamp) AS year,
COUNT(DISTINCT rev_id) AS edits ... |
7 months ago |
| SELECT
COUNT(DISTINCT rev_id)
FROM
revision
JOIN
page
ON rev_page... |
7 months ago |
| SELECT
rev_id,
page_title
FROM
revision
JOIN
page
ON rev_page =... |
7 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
7 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2023
LIMIT 5 |
7 months ago |
