use enwiki_p;
SELECT page_title
FROM page
where page_is_redirect = 1
and... |
5 years ago |
SELECT page_title
FROM page
where page_is_redirect = 1
and page_namespace =... |
5 years ago |
SELECT *
FROM page
where page_is_redirect = 1
and page_namespace = 0
limit 1000; |
5 years ago |
SELECT *
FROM page
where page_is_redirect = 1
and page_namespace == 0
limit 1000; |
5 years ago |
SELECT *
FROM page
limit 100; |
5 years ago |
SELECT *
FROM page
where page_is_redirect = 1
#limit 100; |
5 years ago |
SELECT *
FROM page
where page_is_redirect = 1
#limit 100; |
5 years ago |
SELECT *
FROM page
where page_is_redirect = 1
limit 100; |
5 years ago |
SELECT *
FROM page
#where page_is_redirict = 1
limit 100; |
5 years ago |
SELECT *
FROM page
--where page_is_redirict = 1
limit 100; |
5 years ago |
SELECT *
FROM page
where page_is_redirict = 1
limit 100; |
5 years ago |
SELECT *
FROM page
limit 100; |
5 years ago |
USE enwiki;
SELECT *
FROM page
limit 100; |
5 years ago |
SELECT page_lang
FROM page
GROUP BY page_lang
limit 100; |
5 years ago |
SELECT *
FROM page
where page_lang = 'EN'
limit 100; |
5 years ago |
SELECT distinct page_lang
FROM page
limit 100; |
5 years ago |
SELECT *
FROM page
where page_lang = 'EN'
limit 100; |
5 years ago |
SELECT *
FROM page
limit 100; |
5 years ago |
SELECT page_title
FROM page
limit 100; |
5 years ago |