| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE gawiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(DISTINCT users) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(unique users) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(unique users) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(unique users) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE enwiki_p;
SELECT COUNT(unique users) AS usercounts, COUNT(rev_id)... |
9 years ago |
| USE enwiki_p;
SELECT COUNT(*) AS langcounts, ll_from, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS langcounts, ll_from, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS langcounts, ll_from, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS langcounts, ll_from FROM langlinks... |
9 years ago |
| USE simplewiki_p;
Select count(*) AS langcounts, ll_from from langlinks... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS linkscount, pl_title FROM pagelinks... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS linkscount, pl_title FROM pagelinks... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) AS linkscount, pl_title FROM pagelinks... |
9 years ago |
| USE simplewiki_p;
SELECT count(*) as linkscount, pl_title from pagelinks... |
9 years ago |
| USE simplewiki_p;
SELECT count(*) as linkscount, pl_title from pagelinks... |
9 years ago |
| USE simplewiki_p;
SELECT pl_title FROM pagelinks JOIN page ON page_id =... |
9 years ago |
| USE simplewiki_p;
SELECT pl_title FROM pagelinks JOIN page ON page_id =... |
9 years ago |
| USE simplewiki_p;
SELECT pl_title FROM pagelinks JOIN page ON page_id =... |
9 years ago |
| USE simplewiki_p;
SELECT pl_from, page_title FROM pagelinks JOIN page ON... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) as linkscount, pl_from, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*) as linkscount, pl_from, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*), pl_from, page_title FROM pagelinks JOIN... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(*), pl_from, page_title FROM pagelinks JOIN... |
9 years ago |
| USE simplewiki_p;
SELECT pl_from, page_title FROM pagelinks JOIN page ON... |
9 years ago |
| USE simplewiki_p;
SELECT pl_from FROM pagelinks WHERE pl_title = "Oxford"... |
9 years ago |
| USE simplewiki_p;
select pl_from from pagelinks where pl_title = "Oxford"... |
9 years ago |
| USE simplewiki_p;
DESCRIBE pagelinks; |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, page_title FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision JOIN... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision JOIN... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision JOIN... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name... |
9 years ago |
| USE simplewiki_p;
SELECT rev_user, user_name, COUNT(rev_id) AS editcounts... |
9 years ago |
| USE simplewiki_p;
SELECT rev_user, COUNT(rev_id) AS editcounts FROM... |
9 years ago |
| USE simplewiki_p;
SELECT rev_user, COUNT(rev_id) AS editcounts FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user FROM... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10; |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user; |
9 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
9 years ago |
| USE simplewiki_p;
SELECT COUNT (rev_id) FROM revision WHERE rev_user = "66249"; |
9 years ago |
| USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user FROM... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user FROM... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp FROM revision... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page, page_title FROM revision JOIN page ON... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page FROM revision JOIN page ON rev_page =... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp ASC... |
9 years ago |
| USE simplewiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp ACS... |
9 years ago |
| USE simplewiki_p;
SELECT * FROM revision ORDER by rev_timestamp DESC limit 10;
|
9 years ago |
| USE simplewiki_p;
SELECT * FROM revision ORDER by rev_timestamp limit 10;
|
9 years ago |
| USE simplewiki_p;
SELECT * FROM revision limit 10;
|
9 years ago |
| USE simplewiki_p;
SELECT * FROM user limit 10;
|
9 years ago |
| use Wikibase; |
9 years ago |
| use Wikibase; |
9 years ago |
| use Wikibase; |
9 years ago |
| use Wikibase; |
9 years ago |
| use Wikibase; |
9 years ago |
| use wikibase; |
9 years ago |
| use simplewiki_p;
select * from page limit 10; |
9 years ago |
| use dewiki_p;
select * from page limit 10; |
9 years ago |
| use simplewiki_p;
select * from page limit 10; |
9 years ago |
| select * from page limit 10; |
9 years ago |
| use simplewiki_p;
select * from page limit 10; |
9 years ago |
| use simplewiki_p;
describe page;
|
9 years ago |
| use simplewiki_p;
show tables; |
9 years ago |
| use simplewiki_p;
|
9 years ago |
| show databases; |
9 years ago |
| show databases; |
9 years ago |
| show databases; |
9 years ago |
| show databses; |
9 years ago |
