-- Fork |
5 years ago |
SELECT pl_title
FROM pagelinks
WHERE pl_from IN (
SELECT page_id
FROM... |
5 years ago |
SELECT page_id,page_title
FROM page
WHERE
page_namespace = 0
AND page_title... |
5 years ago |
SELECT page_id,page_title
FROM page
WHERE
page_namespace = 0
AND page_title... |
5 years ago |
SELECT page_id,page_title
FROM page
WHERE page_title IN ('Ptolemaic_Kingdom'); |
5 years ago |
-- Draft |
5 years ago |
use nlwiki_p;
SELECT *
FROM imagelinks
WHERE il_from=174647
AND... |
5 years ago |
use nlwiki_p;
SELECT *
FROM imagelinks
WHERE il_from=174647
AND... |
5 years ago |
use nlwiki_p;
SELECT *
FROM imagelinks
WHERE il_from=174647 |
5 years ago |
-- Draft |
6 years ago |
SELECT * from page WHERE page_namespace=446 LIMIT 10; |
6 years ago |
-- Draft |
6 years ago |
-- SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |
-- SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |
SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |
SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |
SELECT page_id, page_title, page_namespace FROM page WHERE page_id = 42926060;
|
6 years ago |
SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id = 611002002;
|
6 years ago |
SELECT 1 FROM revision LIMIT 1; |
6 years ago |
SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |
SELECT rev_id, rev_page, rev_comment FROM revision WHERE rev_id =... |
6 years ago |