| use idwiki_p;
SELECT DISTINCT
page_title
FROM page
JOIN pagelinks
ON... |
5 years ago |
| use idwiki_p;
SELECT DISTINCT
page_title
FROM page
JOIN pagelinks
ON... |
6 years ago |
| use idwiki_p;
SELECT DISTINCT
page_title
FROM externallinks
JOIN page
ON... |
6 years ago |
| use idwiki_p;
SELECT * FROM text
LIMIT 10; |
6 years ago |
| use idwiki_p;
SELECT * FROM revision
WHERE rev_parent_id = 0
ORDER BY... |
6 years ago |
| use idwiki_p;
SELECT * FROM revision
ORDER BY rev_id DESC
LIMIT 10; |
6 years ago |
| use idwiki_p;
SELECT * FROM revision
LIMIT 10; |
6 years ago |
| use idwiki_p;
SELECT * FROM revision
LIMIT 1; |
6 years ago |
| use idwiki_p;
SELECT * FROM texts
LIMIT 1; |
6 years ago |
| use idwiki_p;
SELECT * FROM text
LIMIT 1; |
6 years ago |
| use idwiki_p;
SELECT * FROM page AS p1
WHERE page_title = "Haggith"
LIMIT 100; |
6 years ago |
| use idwiki_p;
SELECT * FROM page AS p1
WHERE page_is_new = 1 AND... |
6 years ago |
| use idwiki_p;
SELECT
MONTH,
NS
FROM (SELECT
SUBSTR(page_touched, 1, 6)... |
6 years ago |
| use idwiki_p;
SELECT
MONTH,
NS
FROM (SELECT
SUBSTR(page_touched, 1, 6)... |
6 years ago |
| use idwiki_p;
SELECT * FROM page AS p1
WHERE
page_is_new = 1
ORDER BY... |
6 years ago |
| use idwiki_p;
SELECT * FROM page AS p1
WHERE
page_is_new = 1
LIMIT 1 |
6 years ago |
| use idwiki_p;
SELECT page_namespace, page_title, page_len, page_is_redirect,... |
6 years ago |
| use idwiki_p;
SELECT
*
FROM logging
where log_action = 'create'
... |
6 years ago |
| use idwiki_p;
SELECT
MONTH,
ACTIONS
FROM (SELECT
SUBSTR(log_timestamp,... |
6 years ago |
