| use ruwiki_p;
select * from user where user_name like '%Sayan%' |
4 years ago |
| use ruwiki_p;
select * from user where user_name like '%sayan%' |
4 years ago |
| use ruwiki_p;
select * from user where user_name like '%sayan%; |
4 years ago |
| use ruwiki_p;
select * from user limit 10; |
4 years ago |
| SELECT * FROM wikidatawiki_p.wb_changes_subscription WHERE cs_entity_id =... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription WHERE cs_entity_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription WHERE cs_entity_id... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wb_changes_subscription WHERE... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription WHERE cs_entity_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription WHERE cs_entity_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription WHERE cs_entity_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription LIMIT 1000; |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_changes_subscription LIMIT 10; |
4 years ago |
| USE wikidatawiki_p; |
4 years ago |
| USE ruwiki_p;
SELECT actor_name, page_namespace, COUNT(DISTINCT rev_page)
... |
4 years ago |
| USE ruwiki_p;
SELECT actor_name, page_namespace, COUNT(DISTINCT rev_page)
... |
4 years ago |
| USE ruwiki_p;
SELECT rev_actor, page_namespace, COUNT(DISTINCT rev_page)
... |
4 years ago |
| USE ruwiki_p;
SELECT rev_actor, rev_page
FROM revision_userindex
INNER... |
4 years ago |
| USE ruwiki_p;
SELECT rev_actor, rev_page
FROM revision_userindex
WHERE... |
4 years ago |
| USE ruwiki_p;
SELECT rev_actor, rev_page
FROM revision_userindex
WHERE... |
4 years ago |
| use ruwiki_p;
select * from revision_userindex LIMIT 10; |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), d.ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), d.ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), d.ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), d.ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', page_title), ips_item_id
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', page_title), ips_item_id
FROM... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| /*SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| /*SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| /*SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| /*SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
4 years ago |
| SELECT *
FROM ruwiki_p.categorylinks
INNER JOIN ruwiki_p.page ON cl_from... |
4 years ago |
| SELECT *
FROM ruwiki_p.categorylinks
INNER JOIN ruwiki_p.page ON cl_from... |
4 years ago |
| use meta_p;
SELECT distinct family FROM wiki; |
4 years ago |
| use meta_p;
SELECT * FROM wiki; |
4 years ago |
| use meta_p;
show tables; |
4 years ago |
| show databases; |
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
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
5 years ago |
| use ruwiki_p;
SELECT * FROM page
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
5 years ago |
| use ruwiki_p;
SELECT * FROM page
INNER JOIN (select rev_page, MIN(rev_id)... |
5 years ago |
| use ruwiki_p;
SELECT * FROM page LIMIT 10; |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, log_action, COUNT(*) AS overall#, SUM(CASE... |
5 years ago |
| SELECT log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| SELECT log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| SELECT log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| SELECT log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| SELECT log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| select * from logging limit 10; |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE CONCAT('Q',... |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE ips_item_id=TRIM('Q'... |
5 years ago |
| SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE ips_item_id=TRIM('Q'... |
5 years ago |
| USE ruwiki_p;
select * from page where page_title='Железная_дорога' limit 10; |
5 years ago |
| USE ruwiki_p;
select * from page where page_title='Железная дорога' limit 10; |
5 years ago |
| USE ruwiki_p;
select * from page where page_title='Габон' limit 10; |
5 years ago |
| USE ruwiki_p;
select * from page where page_is_redirect=1 limit 10; |
5 years ago |
| USE ruwiki_p;
select * from redirect limit 10; |
5 years ago |
| USE ruwiki_p;
select iwl_title, max(page_title)
from iwlinks
inner join page... |
5 years ago |
| USE ruwiki_p;
select *
from iwlinks
inner join page on... |
5 years ago |
| USE ruwiki_p;
select count(*)
from iwlinks
inner join page on... |
5 years ago |
| USE ruwiki_p;
select count(*)
from iwlinks
inner join page on... |
5 years ago |
| USE ruwiki_p;
select *
from iwlinks
inner join page on... |
5 years ago |
| USE ruwiki_p;
select * from iwlinks where iwl_prefix='d' limit 100;
select *... |
5 years ago |
| USE ruwiki_p;
select * from iwlinks where iwl_prefix='d' limit 100; |
5 years ago |
| USE ruwiki_p;
select * from iwlinks where iwl_prefix='d' limit 10; |
5 years ago |
| USE ruwiki_p;
select * from iwlinks limit 10; |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| use ruwiki_p;
SELECT* from revision WHERE rev_comment like '%lobal_eplace%'
LIMIT 10 |
6 years ago |
| use ruwiki_p;
SELECT* from revision WHERE rev_comment like '%lobal%'
LIMIT 10 |
6 years ago |
| use ruwiki_p;
describe revision
WHERE rev_comment like "%lobal%"
LIMIT 10 |
6 years ago |
| use ruwiki_p;
describe revision
|
6 years ago |
| use ruwiki_p;
DESCRIBE revision_comment_temp;
|
6 years ago |
| use ruwiki_p;
describe revision
|
6 years ago |
| use ruwiki_p;
select *
from revision
WHERE rev_comment like... |
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, user_id
from revision
join user on... |
6 years ago |
| use ruwiki_p;
select count(*) as c, user_id
from revision
join [user] on... |
6 years ago |
| use ruwiki_p;
select count(*) as c, user_id
from revision
join [user] on... |
6 years ago |
| use ruwiki_p;
select count(*) as c, user_name from revision join user on... |
6 years ago |
| USE ruwiki_p;
SELECT rev_user_text, count(*)
FROM revision r
INNER JOIN page... |
6 years ago |
| USE ruwiki_p;
SELECT rev_user_text, count(*)
FROM revision r
INNER JOIN page... |
6 years ago |
| USE ruwiki_p;
SELECT rev_user_text, count(*)
FROM revision r
INNER JOIN page... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT
1 AS `objectQuestType`,
NULL AS `objectLang`,
... |
6 years ago |
| SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT *
FROM (
SELECT
1 AS `objectQuestType`, NULL AS `objectLang`,... |
6 years ago |
| SELECT page_title, page_namespace, rd_namespace, rd_title FROM... |
6 years ago |
| SELECT
QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT
1 AS `articleQuestType`, NULL AS `articleLang`,... |
6 years ago |
| SELECT 1 AS `v0QuestType` FROM `frwiki_p`.`page` WHERE (`page_namespace` =... |
6 years ago |
| SELECT 1 AS `v0QuestType` FROM `frwiki_p`.`page` WHERE (`page_namespace` =... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType` FROM (SELECT 1 AS... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| select page_id from frwiki_p.page limit 10 |
6 years ago |
| SELECT
QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| use enwiki_p;
SELECT
QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| use enwiki_p;
SELECT
QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT
QansSQ1View.`v0QuestType` AS `predicateQuestType`,... |
6 years ago |
| SELECT * #page_title, 14 AS ns, cl_to
FROM categorylinks INNER JOIN page ON... |
6 years ago |
| #SELECT page_title, 14 AS ns, cl_to
#FROM categorylinks INNER JOIN page ON... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to
FROM categorylinks INNER JOIN page ON... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to
FROM categorylinks INNER JOIN page ON... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to
FROM categorylinks INNER JOIN page ON... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to FROM categorylinks, page
WHERE page_id =... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to FROM categorylinks, page
WHERE page_id =... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to FROM categorylinks, page
WHERE page_id =... |
6 years ago |
| SELECT page_title, 14 AS ns, cl_to FROM {db}.categorylinks, {db}.page
WHERE... |
6 years ago |
| SELECT page_title, page_namespace AS ns FROM page WHERE page_namespace != 0... |
6 years ago |
| SELECT page_title, page_namespace AS ns FROM {db}.page WHERE page_namespace... |
6 years ago |
| SELECT page_id FROM page WHERE page_title='Burials_by_place' and page_namespace=14 |
6 years ago |
| SELECT page_id FROM page WHERE page_title='Novichok_agent' and page_namespace=0 |
6 years ago |
| SELECT page_id FROM page WHERE page_title='Novichok agent' and page_namespace=0 |
6 years ago |
| SHOW INDEX IN page; |
6 years ago |
| show indexes FROM slots; |
6 years ago |
| show indexes FROM slot_roles; |
6 years ago |
|
show tables; |
6 years ago |
| use meta_p;
show tables; |
6 years ago |
| show tables; |
6 years ago |
| SELECT * FROM Actor LIMIT 100; |
6 years ago |
| SELECT *
FROM page
INNER JOIN categorylinks ON cl_from=page_id
INNER... |
6 years ago |
| SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), page_title
FROM page
... |
6 years ago |
| select * from page INNER JOIN categorylinks ON cl_from=page_id WHERE... |
6 years ago |
| select * from page INNER JOIN categorylinks ON cl_to=page_id WHERE... |
6 years ago |
| select * from page INNER JOIN categorylinks ON cl_from=page_id WHERE... |
6 years ago |
| select * from page WHERE page_namespace = 14 limit 10 |
6 years ago |
| select * from page limit 10 |
6 years ago |
| select * from site_identifiers limit 10 |
6 years ago |
