| SELECT page_id, page_title FROM page
WHERE page_namespace = 0
AND... |
2 years ago |
| SELECT page_id, page_title FROM page
WHERE page_namespace = 0
AND... |
2 years ago |
| SELECT page_id, page_title FROM page
WHERE page_namespace = 0
AND... |
2 years ago |
| SELECT page_id, page_title FROM page
WHERE page_namespace = 0
ORDER BY... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT rev_id FROM revision
JOIN change_tag ON rev_id = ct_rev_id
WHERE... |
2 years ago |
| CREATE TEMPORARY TABLE t_pages (
id INTEGER PRIMARY KEY,
title... |
2 years ago |
| SELECT COUNT(*) FROM revision
WHERE rev_page = 645150
AND rev_timestamp... |
2 years ago |
| SELECT COUNT(*) FROM revision
WHERE rev_page = 645150
AND rev_timestamp... |
2 years ago |
| SELECT rev_id FROM revision
WHERE rev_page = 645150
AND rev_timestamp >... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT rev_id FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT COUNT(*) FROM (
SELECT rev_id FROM revision
JOIN change_tag ON... |
2 years ago |
| SELECT rev_id FROM revision
JOIN change_tag ON rev_id = ct_rev_id
WHERE... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT COUNT(*) FROM revision
JOIN change_tag ON rev_id = ct_rev_id
WHERE... |
2 years ago |
| SELECT COUNT(*) FROM revision
JOIN change_tag ON rev_id = ct_rev_id
WHERE... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 1, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, SUBSTR(rev_timestamp, 0, 8), rev_actor, ct_tag_id, ctd_name... |
2 years ago |
| SELECT rev_id, rev_timestamp, rev_actor, ct_tag_id, ctd_name FROM... |
2 years ago |
| SELECT rev_id, rev_timestamp, rev_actor, ct_tag_id, ctd_name FROM... |
2 years ago |
| SELECT rev_id, rev_timestamp, rev_actor, ct_tag_id FROM revision
JOIN... |
2 years ago |
| SELECT * FROM revision
WHERE rev_page = 6562
AND rev_timestamp >... |
2 years ago |
| SELECT * FROM revision
WHERE rev_page = 6562
LIMIT 50; |
2 years ago |
| SELECT * FROM revision
LIMIT 50; |
2 years ago |
| SELECT * FROM revision
WHERE rev_page = 91660
LIMIT 50; |
2 years ago |
| SELECT * FROM revision
WHERE rev_page = 91660
AND rev_timestamp > 20220401000000; |
2 years ago |
| SELECT * FROM revision
WHERE rev_page = 91660
AND rev_timestamp > 20220510000000; |
2 years ago |
