| #use wikidatawiki_p;
#use plwikisource_p;
use enwiki_p;
select... |
7 years ago |
| #use wikidatawiki_p;
#use plwikisource_p;
use enwiki_p;
select... |
7 years ago |
| #use wikidatawiki_p;
#use plwikisource_p;
use enwiki_p;
select * from... |
7 years ago |
| #use wikidatawiki_p;
use plwikisource_p;
select * from revision where... |
7 years ago |
| #use wikidatawiki_p;
use plwikisource_p;
select * from revision where... |
7 years ago |
| #use wikidatawiki_p;
use plwikisource_p;
select user_name,LENGTH(user_name)... |
7 years ago |
| #use wikidatawiki_p;
use enwiki_p;
select user_name,LENGTH(user_name) from... |
7 years ago |
| #use wikidatawiki_p;
use enwiki_p;
select user_name,LENGTH(user_name) from... |
7 years ago |
| #use wikidatawiki_p;
use enwiki_p;
select * from user where LENGTH(user_name) > 80;
|
7 years ago |
| #use wikidatawiki_p;
use enwiki_p;
select max(LENGTH(user_name)) from user;
|
7 years ago |
| #use wikidatawiki_p;
use enwiki_p;
select max(LENGTH(user_name)) from user;
|
7 years ago |
| #use wikidatawiki_p;
use plwikisource_p;
select max(LENGTH(user_name)) from user;
|
7 years ago |
| use wikidatawiki_p;
select max(LENGTH(user_name)) from user;
|
7 years ago |
| use plwikisource;
show create table user;
|
7 years ago |
| use plwikisource_p;
show create table user;
|
7 years ago |
|
use wikidatawiki_p;
select count(*) from revision where rev_user_text RLIKE 'bot';
|
7 years ago |
|
use wikidatawiki_p;
select * from revision where rev_user_text = 'SuccuBot'... |
7 years ago |
|
use wikidatawiki_p;
select * from revision limit 10;
|
7 years ago |
|
use wikidatawiki_p;
select count(*) from revision;
|
7 years ago |
| show databases;
#use wikidata_p;
#select count(*) from revision;
|
7 years ago |
| use wikidata_p;
select count(*) from revision;
|
7 years ago |
| blank query |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS Letter,... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS l, COUNT(page_title)
... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1,1) AS l, COUNT(page_title)
... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1) AS l, COUNT(page_title)
... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1) AS l, COUNT(page_title)
... |
7 years ago |
| USE commonswiki_p;
select * from categorylinks join page on cl_from =... |
7 years ago |
| USE commonswiki_p;
select * from categorylinks limit 2;
/*SELECT... |
7 years ago |
| USE commonswiki_p;
SELECT SUBSTR(page_title,1) AS l, COUNT(page_title)
... |
7 years ago |
| USE plwikisource_p;
SELECT page_namespace, page_title, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT page_namespace, page_title, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT * FROM (SELECT rev_page, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT * FROM (SELECT rev_page, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT * FROM (SELECT rev_page, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT * FROM (SELECT rev_page, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT rev_page, rev_timestamp, rev_comment
FROM... |
7 years ago |
| USE plwikisource_p;
SELECT rev_page, page_namespace, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT *,page_id, page_namespace, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT *,page_id, page_namespace, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT *,page_id, page_namespace, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT page_name, page_namespace, rev_timestamp,... |
7 years ago |
| USE plwikisource_p;
SELECT *
FROM revision
WHERE rev_user_text =... |
7 years ago |
| USE plwikisource_p;
SELECT *
FROM revision
WHERE rev_id > 0
LIMIT 20; |
7 years ago |
| USE plwikisource_p;
SELECT *
FROM revision
WHERE rev_text rlike '—'
LIMIT 20; |
7 years ago |
| USE plwikisource_p;
SELECT *
FROM revision
WHERE rev_desc rlike '—'
LIMIT 20; |
7 years ago |
| USE plwikisource_p;
SELECT page_id,page_title,MAX(rev_timestamp) AS... |
7 years ago |
