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