SELECT r.*, p.*
FROM revision as r
INNER JOIN page as p ON r.rev_page =... |
3 years ago |
SELECT r.*, p.*
FROM revision as r
INNER JOIN page as p ON r.rev_page =... |
3 years ago |
SELECT r.*, p.*
FROM revision as r
INNER JOIN page as p WHERE r.rev_page =... |
3 years ago |
SELECT * FROM revision WHERE rev_timestamp >= "20210412" |
3 years ago |
SELECT
p.page_id, p.page_latest, p.page_title, p.page_namespace,
r.*
FROM... |
3 years ago |
SELECT
p.page_id, p.page_latest, p.page_title,... |
3 years ago |
SELECT page_id, page_latest, page_title, page_namespace FROM page WHERE... |
3 years ago |
SELECT page_id, page_latest, page_title FROM page WHERE page_title = 'pitch' |
3 years ago |
SELECT page_id, page_latest FROM page WHERE page_title = 'pitch' |
3 years ago |