SELECT article.page_title, article.page_id
FROM page
INNER JOIN page... |
4 years ago |
select * from categorylinks
join page on cl_from = page_id
where cl_to =... |
4 years ago |
select * from categorylinks
join page on cl_from = page_id
where cl_to =... |
4 years ago |
select * from categorylinks
where cl_to = 'WikiProject_Maps'
limit 200 |
4 years ago |
select * from category
where cat_title like '%\_WikiProject_%'
limit 200 |
4 years ago |
select * from category
where cat_title like 'All_WikiProject_%'
limit 200 |
4 years ago |
select * from categorylinks
where cl_to like 'All_WikiProject_%'
limit 200 |
4 years ago |
select * from categorylinks
where cl_to like 'All_WikiProject_%'
limit 20 |
4 years ago |
select * from categorylinks
where cl_to =... |
4 years ago |
select * from categorylinks
where cl_to = 'All_WikiProject_Medicine_articles' |
4 years ago |
SELECT article.page_title, article.page_id
FROM page
INNER JOIN page... |
4 years ago |
use enwiki_p;
select * from categorylinks
#join categorylinks on page_id =... |
4 years ago |
use enwiki_p;
select * from page
join categorylinks on page_id =... |
4 years ago |
use enwiki_p;
select * from page
join categorylinks on page_id =... |
4 years ago |
use enwiki_p;
select * from category
where cat_title like '%\_Maps%' |
4 years ago |
use enwiki_p;
select * from category
where cat_title like '%\_Science%' |
4 years ago |
use enwiki_p;
select * from category
where cat_title like '%\_Science%'
limit 20 |
4 years ago |
use enwiki_p;
select * from page
where page_title like... |
4 years ago |
use enwiki_p;
select * from page
where page_namespace = 4 and page_title... |
4 years ago |
use enwiki_p;
select * from page
where page_namespace = 4
limit 200 |
4 years ago |
use enwiki_p;
select * from page
where page_title like... |
4 years ago |
use enwiki_p;
select * from page
where page_title like... |
4 years ago |
use enwiki_p;
select * from page
where page_title like "Wikipedia:WikiProject_%" |
4 years ago |
use enwiki_p;
select * from category
where cat_title like... |
4 years ago |
use enwiki_p;
select * from category
where cat_title like "WikiProject_%"
limit 300 |
4 years ago |
use enwiki_p;
select * from category
where cat_title like... |
4 years ago |
use enwiki_p;
select * from category
where cat_title like... |
4 years ago |
use enwiki_p;
select * from category
where cat_title like "WikiProject_%"
limit 300 |
4 years ago |
use enwiki_p;
select * from category
where cat_title like "WikiProject_%"
limit 100 |
4 years ago |
use enwiki_p;
select * from category
where cat_title like... |
4 years ago |
use enwiki_p;
select * from category
where cat_title like "All_WikiProject_%" |
4 years ago |
use enwiki_p;
select * from category
where cat_title =... |
4 years ago |
SELECT *#aa.page_title, aa.page_id, aa.page_namespace
FROM page
#INNER JOIN... |
4 years ago |
SELECT *aa.page_title, aa.page_id, aa.page_namespace
FROM page
#INNER JOIN... |
4 years ago |
SELECT aa.page_title, aa.page_id, aa.page_namespace
FROM page
INNER JOIN... |
4 years ago |
SELECT article.page_title, article.page_id, article.page_namespace
FROM... |
4 years ago |
SELECT article.page_title, article.page_id, article.page_namespace
FROM... |
4 years ago |
SELECT article.page_title, article.page_id, article.page_namespace
FROM... |
4 years ago |
SELECT article.page_title, article.page_id
FROM page
INNER JOIN page... |
4 years ago |
SELECT *#article.page_title, article.page_id
FROM page
INNER JOIN page... |
4 years ago |
SELECT article.page_title, article.page_id
FROM page
INNER JOIN page... |
4 years ago |