USE bewiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE ukwiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE rowiki_p;
SET SESSION group_concat_max_len = 10000;
SELECT... |
7 years ago |
USE rowiki_p;
SET SESSION group_concat_max_len = 10000;
SELECT... |
7 years ago |
USE rowiki_p;
SET SESSION group_concat_max_len = 10000;
SELECT... |
7 years ago |
USE bawiki_p;
SELECT rev_user_text, count(1) as created
FROM page
JOIN... |
7 years ago |
USE crhwiki_p;
SELECT rev_user_text, count(1) as created
FROM page
JOIN... |
7 years ago |
USE crhwiki_p;
SELECT rev_user_text, count(1) as created
FROM page
JOIN... |
7 years ago |
USE crhwiki_p;
SELECT page_title, count(1) as edits
FROM page
JOIN... |
7 years ago |
USE ukwiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE ukwiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE bewiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE bawiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE bawiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE bawiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE bawiki_p;
SELECT
page_title
FROM page
WHERE
page_is_redirect = 0... |
7 years ago |
USE ukwikibooks_p;
SELECT cl_to FROM categorylinks
JOIN page
ON... |
7 years ago |
USE ukwikibooks_p;
SELECT cl_to FROM categorylinks
JOIN page
ON... |
7 years ago |
SELECT
page_namespace,
(case when page_namespace = 0 then... |
7 years ago |
SELECT * FROM bawiki_p.category
WHERE
cat_pages = 0 AND
... |
7 years ago |
SELECT * FROM ukwiki_p.category
WHERE
cat_pages = 0 AND
... |
7 years ago |
SELECT * FROM ukwikipedia_p.category
WHERE
cat_pages = 0 AND
... |
7 years ago |
SELECT user_name, user_editcount
FROM ukwikibooks_p.user
ORDER BY... |
7 years ago |
SELECT * FROM ukwikibooks_p.user
|
7 years ago |
SELECT * FROM ukwikibooks_p.user
ORDER BY page_title |
7 years ago |
SELECT * FROM ukwikibooks_p.user
ORDER BY page_title |
7 years ago |
SELECT * FROM ukwikibooks_p.page
ORDER BY page_title |
7 years ago |
SELECT count(*) FROM ukwikibooks_p.category |
7 years ago |
SELECT * FROM ukwikibooks_p.user
limit 50 |
7 years ago |
SELECT * FROM ukwikibooks_p.image |
7 years ago |
SELECT * FROM ukwikibooks_p.category |
7 years ago |