-- Total number of article revisions per day
/*SELECT
revision_date,
... |
1 year ago |
-- Total number of article revisions per day
/*SELECT
revision_date,
... |
1 year ago |
-- Total number of article revisions per day
/*SELECT
revision_date,
... |
1 year ago |
-- Total number of article revisions per day
/*SELECT
revision_date,
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
revision_count
FROM (
SELECT
... |
1 year ago |
SELECT
revision_date,
AVG(revision_count) AS average_revisions
FROM (
... |
1 year ago |
SELECT
revision_date,
AVG(revision_count) AS average_revisions
FROM (
... |
1 year ago |
SELECT
DATE(rev.rev_timestamp) AS revision_date,
AVG(COUNT(*)) AS... |
1 year ago |
SELECT
DATE(rev.rev_timestamp) AS revision_date,
AVG(COUNT(*)) AS... |
1 year ago |
SELECT
DATE(rev.rev_timestamp), AVG(COUNT(*))
FROM revision AS rev
INNER... |
1 year ago |
SELECT
DATE(rev.rev_timestamp), AVG(COUNT(p.page_id))
FROM revision AS... |
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
|
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(*))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(p.page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(COUNT(page_id))
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
AVG(rev_timestamp)
FROM revision AS rev
INNER JOIN page AS p ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
*
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com ON... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision AS rev
INNER JOIN comment_revision AS com... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp BETWEEN '20220301000000'... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp > '20220301000000' AND... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp BETWEEN '20220301000000'... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp BETWEEN '20220301000000'... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp > '20220301000000' AND... |
1 year ago |
SELECT
COUNT(*)
FROM revision
WHERE rev_timestamp > '20220327000000'; |
1 year ago |
SELECT
COUNT(*)
FROM revision
AND rev_timestamp > '20220327000000'; |
1 year ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |