SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title,
CONCAT("https://uk.wiktionary.org/wiki/",... |
6 years ago |
SELECT P.page_title, CONCAT("id", R.rev_id) AS revision
FROM... |
6 years ago |
SELECT P.page_title, COUNT(1) AS anonymous_edits
FROM ukwiktionary_p.page P... |
6 years ago |
SELECT DISTINCT *
FROM ukwiktionary_p.page P LEFT JOIN... |
6 years ago |
SELECT *
FROM ukwiktionary_p.page P LEFT JOIN ukwiktionary_p.revision R
ON... |
6 years ago |
SELECT *
FROM ukwiktionary_p.revision R
WHERE R.rev_user=0 AND... |
6 years ago |
SELECT *
FROM ukwiktionary_p.revision R
WHERE R.rev_user=0
LIMIT 50 |
6 years ago |
SELECT *
FROM ukwiktionary_p.revision
LIMIT 50 |
6 years ago |