| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
3 years ago |
| SELECT page_title, ips_item_id
FROM ruwiki_p.categorylinks
INNER JOIN... |
3 years ago |
| #SHOW DATABASES;
use ruwikinews_p;
select * from page where page_namespace=14
|
4 years ago |
| #SHOW DATABASES;
use bgwikinews_p;
select * from page where page_namespace=14
|
4 years ago |
| SHOW DATABASES; |
4 years ago |
| SELECT page_title, ips_item_id
FROM... |
4 years ago |
| SELECT page_title, ips_item_id
FROM... |
4 years ago |
| use ruwiki_p;
select actor_name, count(*) c
from revision_userindex
join... |
4 years ago |
| use ruwiki_p;
select actor_name, count(*) c
from revision_userindex
join... |
4 years ago |
| select actor_name, count(*) c
from revision_userindex
join page on... |
4 years ago |
| SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id),page_namespace
... |
4 years ago |
| SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id),page_namespace
... |
4 years ago |
| SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id),page_namespace
... |
4 years ago |
| SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id),page_namespace
... |
4 years ago |
| SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id)
FROM... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), CONCAT('Q',... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), CONCAT('Q',... |
4 years ago |
| SELECT CONCAT('Шаблон:', p.page_title), CONCAT('Q',... |
4 years ago |
| USE ruwiki_p;
SELECT cast(actor_name as char) user, page_namespace, COUNT(... |
4 years ago |
| USE ruwiki_p;
SELECT cast(actor_name as char) user, page_namespace,... |
4 years ago |
| USE ruwiki_p;
SELECT actor_user, edits
FROM (
SELECT rev_actor, COUNT(*)... |
4 years ago |
| USE ruwiki_p;
SELECT actor_user, edits
FROM (
SELECT rev_actor, COUNT(*)... |
4 years ago |
| use ruwiki_p;
SELECT rev_actor, COUNT(*) edits
FROM revision_userindex
INNER... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page LIMIT 10; |
4 years ago |
| use ruwiki_p;
SELECT * FROM actor_revision LIMIT 10; |
4 years ago |
| use ruwiki_p;
SELECT *
FROM (SELECT rev_page, MIN(rev_id) AS rev_id FROM... |
5 years ago |
| SELECT VERSION();
|
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;
#INNER JOIN (select rev_page,... |
5 years ago |
| use ruwiki_p;
select * from revision limit 10; |
5 years ago |
| use ruwiki_p;
select * from page limit 10; |
5 years ago |
| use ruwiki_p;
select * from page limit 10; |
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, CAST(log_namespace AS UNSIGNED INTEGER) AS ns, COUNT(*) AS... |
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 log_actor, log_namespace, COUNT(*) AS overall, SUM(CASE log_action... |
5 years ago |
| SELECT log_actor, COUNT(*) AS overall, SUM(CASE log_action WHEN 'unapprove'... |
5 years ago |
| SELECT log_actor, COUNT(*) AS overall, SUM(CASE log_action WHEN 'unapprove'... |
5 years ago |
| SELECT log_actor, COUNT(*) AS overall, SUM(CASE log_action WHEN 'unapprove'... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt, SUM(CASE log_action WHEN 'unapprove' THEN... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
5 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging
WHERE log_action IN... |
5 years ago |
| SELECT actor_name, cnt
FROM (SELECT log_actor, COUNT(*) AS cnt
... |
5 years ago |
| SELECT count(*) from enwiki_p.content #LIMIT 100; |
5 years ago |
| SELECT * from enwiki_p.content LIMIT 100; |
5 years ago |
| SELECT * from enwiki_p.content LIMIT 10; |
5 years ago |
| SELECT * from enwiki_p.[content] table LIMIT 10; |
5 years ago |
| SELECT * from enwiki_p.content table LIMIT 10; |
5 years ago |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| select DISTINCT iwl_title from metawiki_p.iwlinks where iwl_from=141462 and... |
5 years ago |
| select DISTINCT iwl_title from metawiki_p.iwlinks where iwl_from=7066 and... |
5 years ago |
| select DISTINCT iwl_title from metawiki_p.iwlinks where iwl_from=141462 and... |
5 years ago |
| select DISTINCT iwl_title from metawiki_p.iwlinks where iwl_from=7066 and... |
5 years ago |
| select * from metawiki_p.iwlinks where iwl_from=7066 and iwl_prefix='d';
|
5 years ago |
| USE metawiki_p;
select * from page where page_id=7066;
select * from... |
5 years ago |
| USE metawiki_p;
select * from page where page_id=7066;
select * from... |
5 years ago |
| USE metawiki_p;
select * from page where page_id=7066;
|
5 years ago |
| USE metawiki_p;
show tables |
5 years ago |
| SHOW DATABASES; |
5 years ago |
| USE meta_p;
show tables |
5 years ago |
| USE meta_p;
describe tables;
|
5 years ago |
| USE meta_p;
describe tables;
|
5 years ago |
| USE meta_p;
describe tables;
--select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
describe tables;
#select * from page where page_id=7066; |
5 years ago |
| USE meta_p;
select * from page where page_id=7066; |
5 years ago |
| USE ruwiki_p;
SELECT * FROM templatelinks where tl_title='catmain' LIMIT... |
5 years ago |
| USE ruwiki_p;
SELECT * FROM templatelinks where tl_from=5751514 LIMIT... |
5 years ago |
| USE ruwiki_p;
SELECT * FROM templatelinks LIMIT 10;
select * from page where... |
5 years ago |
| USE ruwiki_p;
SELECT * FROM templatelinks LIMIT 10 |
5 years ago |
| USE wikidatawiki_p;
SELECT * FROM (
SELECT ips_item_id, MAX(CASE WHEN... |
5 years ago |
| USE ruwiki_p;
SELECT count(*)
FROM revision r
#WHERE rev_timestamp >... |
6 years ago |
| USE ruwiki_p;
SELECT count(*)
FROM revision r
#WHERE rev_timestamp >... |
6 years ago |
| USE ruwiki_p;
SELECT count(*)
FROM revision r
WHERE rev_timestamp >... |
6 years ago |
| USE ruwiki_p;
SELECT *
FROM revision r
LIMIT 100 |
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 |
| 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, page p,... |
6 years ago |
| SELECT * FROM meta_p.wiki WHERE NOT family IN ('wikimedia', 'wikimania',... |
6 years ago |
| SELECT * FROM meta_p.wiki WHERE family IN ('wikimedia', 'wikimania',... |
6 years ago |
| SELECT * FROM meta_p.wiki WHERE family IN ('wikimedia', 'wikimania',... |
6 years ago |
| SELECT DISTINCT family FROM meta_p.wiki #WHERE family LIKE '%wikim%'; |
6 years ago |
| SELECT * FROM meta_p.wiki #WHERE family LIKE '%wikim%'; |
6 years ago |
| SELECT * FROM meta_p.wiki WHERE family LIKE '%wikim%'; |
6 years ago |
| SELECT * FROM meta_p.wiki WHERE dbname LIKE '%wikim%'; |
6 years ago |
| SELECT dbname, lang, url FROM meta_p.wiki WHERE NOT dbname LIKE '%wikim%'; |
6 years ago |
| SELECT dbname, lang, url FROM meta_p.wiki WHERE NOT (dbname LIKE '%wikim%'); |
6 years ago |
| SELECT dbname, lang, name, url FROM meta_p.wiki WHERE NOT (dbname LIKE '%wikim%'); |
6 years ago |
| SELECT dbname, lang, name, url FROM meta_p.wiki; |
6 years ago |
| SHOW DATABASES |
6 years ago |
| select * from idwikimedia_p.page limit 10; |
6 years ago |
| use idwikimedia_p;
show tables;
select * from idwikimedia_p.page limit 10; |
6 years ago |
| use idwikimedia_p;
show tables;
select * from page limit 10; |
6 years ago |
| use idwikimedia_p;
show tables;
select * from page limi 10; |
6 years ago |
| use idwikimedia_p;
show tables; |
6 years ago |
| use idwikimedia_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks WHERE... |
6 years ago |
| use ruwiki_p;
select * from categorylinks... |
6 years ago |
| use ruwiki_p;
select * from categorylinks limit 10; |
6 years ago |
| use ruwiki_p;
select * from categorylinks where cl_to='Википедия:Связать с... |
6 years ago |
| use ruwiki_p;
select * from categorylinks where cl_to='Википедия:Связать с... |
6 years ago |
| use ruwiki_p;
select * from categorylinks limit 10; |
6 years ago |
| use ruwiki_p;
select * from categorylinks limit 10; |
6 years ago |
| use ruwiki_p;
describe categorylinks; |
6 years ago |
| use ruwiki_p;
select * from categorylinks limit 10; |
6 years ago |
| select * from categorylinks limit 10; |
6 years ago |
| select * from categorylinks limit 10; |
6 years ago |
| select * from categorylinks limit 10; |
6 years ago |
| SELECT page_title, page_namespace, rd_namespace, rd_title FROM... |
6 years ago |
| SHOW INDEX IN page; |
6 years ago |
| SHOW INDEX IN page;
|
6 years ago |
| select * from page where page_title='Novichok_agent' |
6 years ago |
| EXPLAIN select * from page where page_title='Novichok_agent' |
6 years ago |
| select * from page where page_title='Novichok agent' |
6 years ago |
| select * from page where page_title='Novichok agent' |
6 years ago |
| select * from page where page_title='Novichok agent' |
6 years ago |
| describe page; |
6 years ago |
| SHOW INDEX_STATISTICS; |
6 years ago |
| SHOW INDEXES FROM categorylinks;
|
6 years ago |
| SHOW INDEXES FROM category;
|
6 years ago |
| SHOW INDEXES FROM Category;
|
6 years ago |
| SHOW INDEXES FROM page;
|
6 years ago |
| SHOW INDEX FROM page;
|
6 years ago |
| select * from categorylinks limit 100; |
6 years ago |
| SELECT * from interwiki LIMIT 100; |
6 years ago |
| SELECT * from iwlinks LIMIT 100; |
6 years ago |
| SELECT * from l10n_cache LIMIT 100; |
6 years ago |
| SELECT * from page_assessments LIMIT 100; |
6 years ago |
| SELECT * from pagelinks LIMIT 100; |
6 years ago |
| SELECT * from protected_titles LIMIT 100; |
6 years ago |
| SELECT * from pif_edits LIMIT 100; |
6 years ago |
| SELECT * from pagetriage_page LIMIT 100; |
6 years ago |
| SELECT * from site_identifiers #LIMIT 100; |
6 years ago |
| SELECT * from site_identifiers LIMIT 100; |
6 years ago |
| SELECT * from site_stats LIMIT 100; |
6 years ago |
| SELECT * from sites LIMIT 100; |
6 years ago |
| SELECT * from slots LIMIT 100; |
6 years ago |
| SELECT * from templatelinks LIMIT 100; |
6 years ago |
| SELECT * from transcode LIMIT 100; |
6 years ago |
| SELECT * from babel LIMIT 100; |
6 years ago |
| SELECT * # page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| SELECT * # page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| SELECT * # page_id, page_namespace, page_title, page_latest,... |
6 years ago |
| SELECT *
FROM page
INNER JOIN categorylinks ON cl_from=page_id
INNER... |
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 |
| use meta_p;
SELECT * from wiki LIMIT 100; |
6 years ago |
| use meta_p;
SELECT * from properties_anon_whitelist LIMIT 100; |
6 years ago |
| use meta_p;
SELECT * from legacy LIMIT 100; |
6 years ago |
| SELECT * from msg_resource_links LIMIT 100; |
6 years ago |
| SELECT * from langlinks WHERE ll_lang='ru' LIMIT 100; |
6 years ago |
| SELECT * from langlinks WHERE ll_lang='en' LIMIT 100; |
6 years ago |
| SELECT * from langlinks LIMIT 100; |
6 years ago |
| SELECT * from content LIMIT 100; |
6 years ago |
| SELECT * from category LIMIT 100; |
6 years ago |
| SELECT * from transcode LIMIT 100; |
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 |
| 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 CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
| USE enwiki_p;
SELECT CONCAT ('Q', CAST(ips_item_id AS CHAR)), cl_to
FROM... |
6 years ago |
