| show tables; |
2 years ago |
| #SHOW DATABASES;
select COUNT(*)
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select COUNT(*)
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
LEFT join... |
3 years ago |
| #SHOW DATABASES;
select *
from ruwikinews_p.page
inner join... |
3 years ago |
| #SHOW DATABASES;
select * from ruwikinews_p.page where page_namespace=14 limit 100
|
3 years ago |
| #SHOW DATABASES;
use ruwikinews_p;
select * from page where... |
3 years ago |
| #SHOW DATABASES;
use ruwikinews_p;
select COUNT(*) from page where page_namespace=14
|
3 years ago |
| USE ruwiki_p;
select * from user; |
3 years ago |
| USE ruwiki_p;
select * from user; |
3 years ago |
| USE ruwiki_p;
select count(rev_page)
from revision
#group by rev_page... |
3 years ago |
| USE ruwiki_p;
select count(rev_page) from revision group by rev_page where... |
3 years ago |
| USE ruwiki_p;
select count(rev_page) from revision group by rev_page where... |
3 years ago |
| USE ruwiki_p;
select count(rev_page) from revision group by rev_page where... |
3 years ago |
| USE ruwiki_p;
select count(rev_page) from revision group by rev_page where... |
3 years ago |
| USE ruwiki_p;
select count distinct rev_page from revision group by rev_page... |
3 years ago |
| USE ruwiki_p;
select count (distinct rev_page) from revision group by... |
3 years ago |
| USE ruwiki_p;
select * from math limit 10 |
3 years ago |
| USE ruwiki_p;
select * from config |
3 years ago |
| USE ruwiki_p;
SELECT actor_name, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
SELECT * from user_groups LIMIT 10;
|
3 years ago |
| /* select page_namespace, cast(page_title as char) title, cast(actor_name as... |
3 years ago |
| /* select page_namespace, cast(page_title as char) title, cast(actor_name as... |
3 years ago |
| /* select page_namespace, cast(page_title as char) title, cast(actor_name as... |
3 years ago |
| /* select page_namespace, cast(page_title as char) title, cast(actor_name as... |
3 years ago |
| select rev_page, rev_actor
from revision
where rev_timestamp... |
3 years ago |
| USE wikidatawiki_p;
show tables;
SELECT * FROM wbt_item_terms
#SELECT *... |
4 years ago |
| USE wikidatawiki_p;
show tables;
#SELECT * FROM wbt_item_terms
#SELECT *... |
4 years ago |
| USE wikidatawiki_p;
show tables;
SELECT * FROM wbt_item_terms
#SELECT *... |
4 years ago |
| USE wikidatawiki_p;
show tables;
#SELECT * FROM wb_items_per_site
#WHERE... |
4 years ago |
| USE wikidatawiki_p;
describe tables;
#SELECT * FROM wb_items_per_site... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_items_per_site
WHERE ips_site_page NOT... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_items_per_site
WHERE ips_site_page NOT... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_items_per_site LIMIT 10;
#WHERE... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750 order by rev_id limit 1;
|
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750 order by... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750 order by... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750;
SELECT... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750;
#SELECT user,... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750;
SELECT user,... |
4 years ago |
| use ruwiki_p;
select * from revision where rev_page=1279750;
SELECT user,... |
4 years ago |
| use ruwiki_p;
SELECT user, min(rev_id) from revision where rev_page=1279750; |
4 years ago |
| use ruwiki_p;
SELECT min(rev_id) from revision where rev_page=1279750; |
4 years ago |
| use ruwiki_p;
SELECT * from revision where rev_page=1279750; |
4 years ago |
| use ruwiki_p;
SELECT * from revision where rev_page=100; |
4 years ago |
| use ruwiki_p;
SELECT * from revision where re_page=100; |
4 years ago |
| use ruwiki_p;
SELECT * from revision limit 10; |
4 years ago |
| use ruwiki_p;
SELECT *
FROM (SELECT rev_page, MIN(rev_id) AS rev_id FROM... |
4 years ago |
| use ruwiki_p;
#show tables;
#select * from revision limit 10;
SELECT... |
4 years ago |
| use ruwiki_p;
#show tables;
select * from revision limit 10;
#SELECT * FROM... |
4 years ago |
| use ruwiki_p;
show tables;
select * from actor_revision limit 10;
#SELECT *... |
4 years ago |
| use ruwiki_p;
show tables;
#select * from revactor_actor limit 10;
#SELECT *... |
4 years ago |
| use ruwiki_p;
select * from revactor_actor limit 10;
#SELECT * FROM page... |
4 years ago |
| use ruwiki_p;
select * from revision limit 10;
#SELECT * FROM page p
#INNER... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
#INNER JOIN (SELECT rev_page, MIN(rev_id)... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
--INNER JOIN (SELECT rev_page,... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
#SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
#MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev,
MAX(CASE WHEN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT *
FROM ores_classification
INNER JOIN... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev
FROM ores_classification... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev
FROM ores_classification limit... |
4 years ago |
| use ruwiki_p;
#SHOW TABLES;
select * from ores_classification limit... |
4 years ago |
| use ruwiki_p;
SHOW TABLES;
#select * from ores_model limit 10;
#select *... |
4 years ago |
| use ruwiki_p;
#select * from ores_model limit 10;
select * from revision... |
4 years ago |
| use ruwiki_p;
select * from ores_model limit 10;
#select osesc_probability... |
4 years ago |
| use ruwiki_p;
select osesc_probability
from revision where oresc_model in... |
4 years ago |
| use mediawikiwiki_p;
show tables;
#SELECT * FROM templatelinks where... |
4 years ago |
| use mediawikiwiki_p;
SELECT * FROM templatelinks where tl_from=191978 and... |
4 years ago |
| use mediawikiwiki_p;
SELECT * FROM templatelinks where tl_from=191978 and... |
4 years ago |
| use mediawikiwiki_p;
SELECT * FROM templatelinks where tl_from=191978 and... |
4 years ago |
| use mediawikiwiki_p;
SELECT * FROM templatelinks where tl_from=924788 and... |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM templatelinks where... |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM templatelinks where... |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM page LIMIT 10; |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM pages LIMIT 10; |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM pages LIMIT 10; |
4 years ago |
| use mediawikiwiki_p;
#SHOW DATABASES;
SELECT * FROM wiki where dbname like '%media%'; |
4 years ago |
| use meta_p;
#SHOW DATABASES;
SELECT * FROM wiki where dbname like '%media%'; |
4 years ago |
| use meta_p;
#SHOW DATABASES;
SELECT * FROM wiki; |
4 years ago |
| use metawiki_p;
SHOW DATABASES;
#SELECT * FROM wiki; |
4 years ago |
| use metawiki_p;
SELECT * FROM wiki; |
4 years ago |
| use mediawikiwiki_p;
SELECT * FROM wiki; |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
#select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='Yesno';
select *... |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='Yesno';
select *... |
4 years ago |
| use mediawikiwiki_p;
select * from page where... |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='Wikidata_list'; |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='Wikidata list'; |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='TableTools'; |
4 years ago |
| use mediawikiwiki_p;
select * from page LIMIT 100; #where page_title='No_global'; |
4 years ago |
| use mediawikiwiki_p;
select * from page LIMIT 10; #where page_title='No_global'; |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='No_global'; |
4 years ago |
| use mediawikiwiki_p;
select * from page where page_title='No global'; |
4 years ago |
| use mediawikiwiki_p; |
4 years ago |
| SHOW DATABASES; |
4 years ago |
| use enwiki_p; |
4 years ago |
| use mediawiki_p; |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
#WHERE... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
#WHERE... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
#WHERE... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
#WHERE... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE
#log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE
#log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE
#log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_action... |
4 years ago |
| SELECT log_actor, COUNT(*) AS cnt
FROM logging_userindex
WHERE log_type =... |
4 years ago |
| use ruwiki_p;
SELECT cast(actor_name as char), log_action, log_namespace,... |
4 years ago |
| use ruwiki_p;
SELECT cast(actor_name as char), log_action, log_namespace,... |
4 years ago |
| use ruwiki_p;
SELECT cast(actor_name as char), log_action, log_namespace,... |
4 years ago |
| use ruwiki_p;
#SELECT DISTINCT log_namespace
SELECT cast(actor_name as... |
4 years ago |
| use ruwiki_p;
#SELECT DISTINCT log_namespace
SELECT cast(actor_name as... |
4 years ago |
| use ruwiki_p;
#SELECT DISTINCT log_namespace
SELECT actor_name, log_action,... |
4 years ago |
| use ruwiki_p;
SELECT DISTINCT log_namespace
#SELECT actor_name, log_action,... |
4 years ago |
| use ruwiki_p;
SELECT actor_name, log_action, log_namespace, cnt
FROM... |
4 years ago |
| SELECT actor_name, log_action, log_namespace, cnt
FROM (SELECT log_actor,... |
4 years ago |
| SELECT actor_name, log_action, log_namespace, cnt
FROM (SELECT log_actor,... |
4 years ago |
| SELECT actor_name, log_action, log_namespace, cnt
FROM (SELECT log_actor,... |
4 years ago |
| select
actor_name,
log_action,
log_namespace,
cnt
from
(
... |
4 years ago |
| use ruwiki_p;
select actor_name user, log_action, log_namespace
from... |
4 years ago |
| use ruwiki_p;
select cast(actor_name as char) user, log_action,... |
4 years ago |
| use dewiki_p;
select * from category
order by cat_subcats desc
limit... |
4 years ago |
| use dewiki_p;
select * from category
order by cat_subcats desc
limit... |
4 years ago |
| use ruwiki_p;
select * from category
order by cat_subcats desc
limit... |
4 years ago |
| use ruwiki_p;
select * from category
order by cat_subcats desc
limit... |
5 years ago |
| use ruwiki_p;
select * from category
order by cat_subcats desc
limit... |
5 years ago |
| use dewiki_p;
select * from category
order by cat_subcats desc
limit... |
5 years ago |
| use enwiki_p;
select * from category
order by cat_subcats desc
limit 100 OFFSET 100; |
5 years ago |
| use enwiki_p;
select * from category
order by cat_subcats desc
limit 100; |
5 years ago |
| use enwiki_p;
select * from category
order by cat_subcats desc
limit 10; |
5 years ago |
| use enwiki_p;
select * from category limit 10; |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
INNER JOIN... |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
INNER JOIN... |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
LEFT JOIN... |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
LEFT JOIN... |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
LEFT JOIN... |
5 years ago |
| SELECT *
FROM metawiki_p.iwlinks
WHERE iwl_prefix='d' LIMIT 100 |
5 years ago |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| USE ruwiki_p;
select iwl_title, count(*), max(page_title)
from iwlinks
inner... |
5 years ago |
| USE ruwiki_p;
select iwl_title, count(*), max(page_title)
from iwlinks
inner... |
5 years ago |
| USE ruwiki_p;
select iwl_title, max(page_title)
from iwlinks
inner join page... |
5 years ago |
| USE ruwiki_p;
select iwl_title, max(page_title)
from iwlinks
inner join page... |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| USE wikidatawiki_p;
select * from wb_items_per_site limit 10 |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
select * from revision_comment_temp LIMIT 10
#select * from... |
5 years ago |
| USE ruwiki_p;
describe revision_comment_temp
#select * from revision WHERE... |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94954377 and rev_comment... |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94954377 and... |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94954377 and rev_comment... |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94954377 and rev_comment... |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94954377 |
5 years ago |
| USE ruwiki_p;
select * from revision WHERE rev_id=94901553 |
5 years ago |
| USE ruwiki_p;
select * from revision LIMIT 100 |
5 years ago |
| USE ruwiki_p;
select * from revision LIMIT 100 |
5 years ago |
| USE ruwiki_p;
select * from revision LIMIT 100 |
5 years ago |
| USE ruwiki_p;
select * from logging WHERE log_type='rights' #LIMIT 100 |
5 years ago |
| USE ruwiki_p;
select * from logging WHERE log_type='rights' LIMIT 100 |
5 years ago |
| USE ruwiki_p;
select * from logging WHERE log_type='rights' LIMIT 10 |
5 years ago |
| USE ruwiki_p;
select * from logging LIMIT 10 WHERE log_type='rights' |
5 years ago |
| USE ruwiki_p;
select * from logging LIMIT 10 |
5 years ago |
| USE ruwiki_p;
select * from user where user_name = 'Ghuron' |
5 years ago |
| USE ruwiki_p;
select * from user where user_name = 'Ghuron' |
5 years ago |
| USE ruwiki_p;
select * from user where user_name = 'ghuron' |
5 years ago |
| USE plwiki_p;
describe page; |
6 years ago |
| USE plwiki_p;
select top 1 * from page; |
6 years ago |
| USE plwiki_p;
select top 1 * from categorylinks; |
6 years ago |
| USE plwiki_p;
select top 1 * from categorylinks; |
6 years ago |
| select top 1 * from categorylinks; |
6 years ago |
