| USE ptwiki_p;
SELECT rev_id,
rev_timestamp
FROM revision
WHERE... |
8 years ago |
| USE ptwiki_p;
SELECT rev_id,
rev_timestamp
FROM revision
WHERE... |
8 years ago |
| use ptwiki_p;
SELECT rev_id, rev_timestamp
FROM revision
WHERE rev_parent_id... |
8 years ago |
| use ptwiki_p;
SELECT rev_timestamp, rev_id
FROM revision
WHERE rev_parent_id... |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
WHERE rev_parent_id = 0
ORDER BY... |
8 years ago |
| use ptwiki_p;
SELECT rev_timestamp, rev_id
FROM revision
WHERE rev_parent_id... |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
WHERE rev_parent_id = 0
ORDER BY... |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
ORDER BY rev_timestamp DESC AND... |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
ORDER BY rev_timestamp DESC
LIMIT 5 |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
ORDER BY rev_timestamp DESC
LIMIT 50 |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
ORDER BY rev_timestamp
LIMIT 50 |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
LIMIT 50 |
8 years ago |
| use ptwiki_p;
SELECT *
FROM revision
LIMIT 5; |
8 years ago |
| use ptwiki_p;
SELECT *
FROM page
WHERE page_namespace = 0
LIMIT 5; |
8 years ago |
| use ptwiki_p;
SELECT *
FROM page
WHERE page_namespace = 0
LIMIT 10; |
8 years ago |
| use ptwiki_p;
SELECT *
FROM page
LIMIT 10; |
8 years ago |
| use ptwiki_p;
SELECT *
FROM page
LIMIT 10
ORDER BY rev_timestamp DESC; |
8 years ago |
| use ptwiki_p;
SELECT page_title
FROM ptwiki_p.page
LIMIT 10
ORDER BY... |
8 years ago |
| use ptwiki_p;
SELECT page_title
FROM ptwiki_p.page
LIMIT 10
AND... |
8 years ago |
| use ptwiki_p;
SELECT page_title,
rev_id,
rev_timestamp,
... |
8 years ago |
| use ptwiki_p;
SELECT page_title,
rev_id,
rev_timestamp,
... |
8 years ago |
| SELECT page_title,
rev_user_text
FROM ptwiki_p.page p
WHERE... |
8 years ago |
| SELECT page_title,
rev_comment,
rev_user_text
FROM... |
8 years ago |
| SELECT page_title,
rev_timestamp,
rev_comment,
... |
8 years ago |
| SELECT page_title,
rev_id,
rev_timestamp,
rev_comment,
... |
8 years ago |
