use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT
page.page_title,
COUNT(rev.rev_id) as... |
6 years ago |
use enwiki_p;
SELECT... |
6 years ago |
use enwiki_p;
SELECT
*
FROM revision as rev
INNER JOIN page ON... |
6 years ago |
use enwiki_p;
SELECT
*
FROM revision as rev
JOIN page on rev.rev_page on... |
6 years ago |
use enwiki_p;
SELECT
*
FROM revision as rev
JOIN revision.rev_page on... |
6 years ago |
SELECT
*
FROM enwiki_p.revision
WHERE
rev_timestamp BETWEEN... |
6 years ago |
SELECT
*
FROM enwiki_p.revision
LIMIT 10; |
6 years ago |
SELECT
*
FROM enwiki_p.revisions
LIMIT 10; |
6 years ago |
SELECT
*
FROM enwiki_p.page
WHERE
(page_touched >= 20150517000000)
... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'United_States' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'United States' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'United States' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'United_States' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'Donald_Trump' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = 'Donald Trump' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('Donald_Trump') and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('Donald Trump') and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('SpaceX') and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('2018','SpaceX')... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('2018','SpaceX')... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page in ('2018','Donald... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = '2018' and... |
6 years ago |
use enwiki_p;
select *
from revision
where rev_page = '2018'; |
6 years ago |
use enwiki_p;
show tables; |
6 years ago |