| -- Calculates unpatrolled recent changes on a daily basis
-- 15 days is... |
3 months ago |
| -- Parameters:
-- lp_num: log params key-value pair (differs from wiki... |
3 months ago |
| -- Parameters:
-- lp_num: log params key-value pair (differs from wiki... |
3 months ago |
| -- Calculates unpatrolled recent changes on a daily basis
-- 15 days is... |
3 months ago |
| -- Calculates unpatrolled recent changes on a daily basis
-- 15 days is... |
3 months ago |
| SELECT CURDATE() |
3 months ago |
| SELECT
*
FROM
revision
WHERE
rev_timestamp >= 20240501000000
LIMIT 5 |
6 months ago |
| SELECT
*
FROM
revision
WHERE
rev_timestamp >= 20240501000000
LIMIT 5 |
6 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2024 AND... |
6 months ago |
| SELECT
*
FROM
revision
WHERE
YEAR(rev_timestamp) = 2024 AND... |
6 months ago |
| SELECT
*
FROM
revision
LIMIT 5 |
6 months ago |
| SELECT
actor_name,
COUNT(DISTINCT rev_id)
FROM
revision
JOIN actor ON... |
6 months ago |
| SELECT
actor_name,
COUNT(DISTINCT rev_id)
FROM
revision
JOIN actor ON... |
6 months ago |
| SELECT
actor_name,
COUNT(DISTINCT rev_id)
FROM
revision
JOIN actor ON... |
6 months ago |
| SELECT
actor_name,
rev_id
FROM
revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT
actor_name,
rev_id
FROM
revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT
actor_name,
rev_id
FROM
revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT
actor_name,
rev_id
FROM
revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT
COUNT(DISTINCT rev_actor)
FROM
revision
JOIN actor ON rev_actor... |
6 months ago |
| SELECT
DISTINCT rev_actor
FROM
revision
WHERE
YEAR(rev_timestamp) = 2024... |
6 months ago |
| SHOW TABLES; |
6 months ago |
| SHOW TABLES; |
6 months ago |
