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