| USE ruwiki_p;
show databases; |
3 years ago |
| USE ruwiki_p;
|
3 years ago |
| USE ruwiki_p;
SELECT COUNT(DISTINCT rev_page)
FROM revision_userindex... |
4 years ago |
| USE ruwiki_p;
SELECT COUNT(DISTINCT rev_page)
FROM revision_userindex... |
4 years ago |
| USE ruwiki_p;
SELECT COUNT(DISTINCT rev_page)
FROM revision
WHERE... |
4 years ago |
| USE ruwiki_p;
select count(rev_page)
from revision
#group by rev_page... |
4 years ago |
| USE ruwiki_p;
SELECT actor_name, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
/*
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
4 years ago |
| use ruwiki_p;
select cast(actor_name as char) user, log_type, log_action,... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM category
INNER JOIN categorylinks ON cat_id... |
4 years ago |
| use ruwiki_p;
SELECT * FROM category WHERE... |
4 years ago |
| use ruwiki_p;
SELECT * FROM category WHERE... |
4 years ago |
| use ruwiki_p;
SELECT * FROM category LIMIT 10; |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
5 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
5 years ago |
| use ruwiki_p;
select * from revision where rev_actor=2105467;
select... |
5 years ago |
| use ruwiki_p;
select * from revision where rev_actor=2105467;
#select... |
5 years ago |
| use ruwiki_p;
SELECT log_actor, COUNT(*) AS cnt
FROM... |
5 years ago |
| use ruwiki_p;
SELECT log_actor, COUNT(*) AS cnt
FROM... |
5 years ago |
| use ruwiki_p;
SELECT log_actor, COUNT(*) AS cnt
FROM... |
5 years ago |
| use ruwiki_p;
SELECT log_actor, COUNT(*) AS cnt
FROM... |
5 years ago |
| use enwiki_p;
select DISTINCT rev_text_id from revision limit 10; |
5 years ago |
| use enwiki_p;
select * from revision limit 10; |
5 years ago |
| use enwiki_p;
select * from revision limit 10; |
5 years ago |
| use enwiki_p;
select * from revision limit 10; |
5 years ago |
| use enwiki_p
select * from revision limit 10; |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE TRIM('Q' FROM... |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE ips_item_id=520937... |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site ON ips_item_id=520937... |
5 years ago |
| SELECT *
FROM wikidatawiki_p.wb_items_per_site
INNER JOIN... |
5 years ago |
| SELECT *
FROM wikidatawiki_p.wb_items_per_site
INNER JOIN... |
5 years ago |
| USE ruwiki_p;
SELECT * from page where page_id=6782512;
select * from... |
5 years ago |
| USE ruwiki_p;
SELECT * from page where page_id=6782512; |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from zhwiki_p.page limit 10; |
5 years ago |
| select * from zhwiki_p.page limit 10; |
5 years ago |
| select * from bgwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| select * from thwiki_p.page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use thwiki_p;
select * from page limit 10; |
5 years ago |
| use ruwiki_p;
select * from page where page_id>=3606710 and page_id<=3607740 |
6 years ago |
| use ruwiki_p;
select * from page where page_id>=3606710 limit 10 |
6 years ago |
| use ruwiki_p;
select * from page where page_id>3606710 limit 10 |
6 years ago |
| use ruwiki_p;
select * from page limit 10 |
6 years ago |
| use ruwiki_p;
select count(*) c, user_name from revision join user on... |
6 years ago |
| use ruwiki_p;
select count(*) c, user_name from revision join user on... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select rev_user, count(1) as c
from revision
where... |
6 years ago |
| use ruwiki_p;
select count(*) as c, rev_user
from revision
where... |
6 years ago |
| use ruwiki_p;
select count(*) as c, rev_user
from revision
where... |
6 years ago |
| SELECT * FROM ruwiki_p.categorylinks cl WHERE cl.cl_to =... |
6 years ago |
| SELECT * FROM categorylinks LIMIT 10; |
6 years ago |
| SELECT *, cl.cl_from FROM categorylinks cl LIMIT 10
|
6 years ago |
| SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to IN... |
6 years ago |
| use ruwikisource_p;
select cat_title from category where cat_title like... |
6 years ago |
| use ruwikisource_p;
select * from category where cat_title like '%Перенаправления'; |
6 years ago |
| use ruwikisource_p;
select * from category limit 10; |
6 years ago |
| use ruwikisource_p; |
6 years ago |
| SHOW DATABASES |
6 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
6 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
6 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
6 years ago |
| use enwiki_p;
SELECT page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| use eswiki_p;
SELECT page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| use eswiki_p;
SELECT page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| use eswiki_p;
SELECT page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| use eswiki_p;
SELECT CONCAT ("Q", CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
... |
6 years ago |
| USE enwiki_p;
SELECT * #FROM wikidatawiki_p.wb_items_per_site WHERE... |
6 years ago |
| USE enwiki_p;
SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE... |
6 years ago |
| USE enwiki_p;
SELECT * FROM wikidatawiki_p.wb_items_per_site LIMIT 100
# ... |
6 years ago |
| USE enwiki_p;
SELECT *
FROM page
INNER JOIN categorylinks ON... |
6 years ago |
| USE enwiki_p;
SELECT *
FROM page
INNER JOIN categorylinks ON... |
6 years ago |
| USE enwiki_p;
SELECT *
FROM page
INNER JOIN categorylinks ON... |
6 years ago |
| USE enwiki_p;
SELECT *
FROM page i
INNER JOIN categorylinks ON... |
6 years ago |
| USE enwiki_p;
SELECT *
FROM page
INNER JOIN categorylinks ON... |
6 years ago |
| USE enwiki_p;
SELECT * FROM page WHERE page_namespace=14 AND... |
6 years ago |
| USE enwiki_p;
SELECT * FROM page WHERE page_namespace=14... |
6 years ago |
| USE enwiki_p;
SELECT * FROM page WHERE page_namespace=14 LIMIT 10... |
6 years ago |
| USE enwiki_p;
SELECT * FROM page LIMIT 10 #categorylinks WHERE... |
6 years ago |
| USE enwiki_p;
SELECT * FROM categorylinks WHERE... |
6 years ago |
| USE enwiki_p;
SELECT * FROM categorylinks LIMIT 10;#WHERE cl_to='Beaconhouse... |
6 years ago |
| USE enwiki_p;
SELECT * FROM categorylinks WHERE cl_to='Beaconhouse School... |
6 years ago |
| USE enwiki_p;
SELECT * FROM categorylinks cl_to='Beaconhouse School System... |
6 years ago |
