select * from wb_items_per_site
limit 5 |
8 months ago |
select * from item
limit 5 |
8 months ago |
select * from items
|
8 months ago |
SELECT *
FROM page
INNER JOIN slots on page_latest = slot_revision_id
... |
8 months ago |
SELECT *
FROM page
INNER JOIN slots on page_latest = slot_revision_id
... |
8 months ago |
SELECT *
FROM page
INNER JOIN slots on page_latest = slot_revision_id
... |
8 months ago |
SELECT *
FROM page
INNER JOIN slots on page_latest = slot_revision_id
... |
8 months ago |
SELECT page_id, page_namespace, page_title, page_latest "rev_id", old_text... |
8 months ago |
select * from article
join revision on page_id=rev_page
join actor on... |
8 months ago |
select * from page
join revision on page_id=rev_page
join actor on... |
8 months ago |
select * from page
join revision on page_id=rev_page
limit 5;
|
8 months ago |
select * from page limit 5;
|
8 months ago |
select * from page;
|
8 months ago |
select top 10 * from page;
|
8 months ago |
select top 10 * from page;
/*where page_title like "%football%"*/ |
8 months ago |
select top 10 * from page
/*where page_title like "%football%"*/ |
8 months ago |
select * from page where page_title like "%football%" |
8 months ago |
select * from page where page_title like "%france%" |
8 months ago |
select * from page where page_title like "%fifa%" |
8 months ago |
select * from page where page_title like "%FIFA%" |
8 months ago |
select * from categorylinks where cl_to like "%FIFA%" |
8 months ago |
select * from categorylinks where cl_to like "%Wikipedia:%FIFA%" |
8 months ago |
select * from categorylinks where cl_to like "%Wikipedia:FIFA%" |
8 months ago |
select * from categorylinks where cl_to like "%Wikipedia:%" |
8 months ago |
select cl_from from categorylinks where cl_to like "%Wikipedia:%" |
8 months ago |
select cl_from from categorylinks |
8 months ago |
select page_title, actor_name from revision join page on page_id=rev_page... |
8 months ago |
select page_title, actor_name from revision join page on page_id=rev_page... |
8 months ago |
select page_title, actor_name from revision join page on page_id=rev_page... |
8 months ago |