| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
4 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 |
| 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 |
| SELECT iwl_title AS qid, ips_site_page AS redirect
FROM... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
5 years ago |
| SELECT iwl_title, ips_site_page
FROM wikidatawiki_p.wb_items_per_site
... |
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 |
| 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 |
| 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 |
| select TRIM('Q' FROM iwl_title) from metawiki_p.iwlinks where... |
5 years ago |
| select TRIM('Q',iwl_title) from metawiki_p.iwlinks where iwl_from=141462 and... |
5 years ago |
| select iwl_title from metawiki_p.iwlinks where iwl_from=141462 and... |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_items_per_site limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from sites limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from sites limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from site_stats limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from site_identifiers limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_terms limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_terms limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_changes limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wbs_propertypairs limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_property_info limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from sites limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wbs_propertypairs limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_items_per_site limit 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
select * from wb_items_per_site limt 10; |
5 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
|
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM hewiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM thwiki_p.page LIMIT 100; |
5 years ago |
| SELECT * FROM eswiki_p.page LIMIT 100; |
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 |
| USE wikidatawiki_p;
SELECT ips_item_id, MAX(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, SUM(CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, CASE WHEN ips_site_id = 'ruwiki'... |
5 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site
limit 100; |
5 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site
limit 100; |
5 years ago |
| use wikidatawiki_p;
select cast(coalesce(x.ips_site_page, z.ips_site_page)... |
5 years ago |
| use wikidatawiki_p;
select cast(coalesce(x.ips_site_page, z.ips_site_page)... |
5 years ago |
| show databases; |
5 years ago |
| SHOW DATABASES; |
5 years ago |
| use wikibase_p;
--select cl_to, count(*) from categorylinks group by cl_to... |
5 years ago |
| use wikidata_p;
--select cl_to, count(*) from categorylinks group by cl_to... |
5 years ago |
| use enwikisource_p;
select cl_to, count(*) from categorylinks group by cl_to... |
5 years ago |
| use dewiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use eswiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use ukwiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use ruwiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use enwiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use ruwiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| use ruwiki_p;
select cl_to, count(*) from categorylinks group by cl_to order... |
5 years ago |
| select cl_to, count(*) from categorylinks group by cl_to order by count(*)... |
5 years ago |
| select * from categorylinks limit 10; |
5 years ago |
| select page_id, page_title, page_namespace, page_content_model, CASE WHEN... |
5 years ago |
| select page_id, page_title, page_namespace, page_content_model, CASE WHEN... |
5 years ago |
| source select page_id, page_title, page_namespace, page_content_model,... |
5 years ago |
| source select page_id, page_title, page_namespace, page_content_model... |
5 years ago |
| source select page_id, page_title, page_namespace, page_content_model... |
5 years ago |
| source select page_id, page_title, page_namespace, page_content_model... |
5 years ago |
| use zhwiki_p;
SELECT * FROM pagelinks WHERE pl_from = 632319 # LIMIT 10 |
5 years ago |
| SELECT * FROM pagelinks WHERE pl_from = 632319 # LIMIT 10 |
5 years ago |
| SELECT * FROM pagelinks WHERE pl_from = 632319 LIMIT 10 |
5 years ago |
| SELECT * FROM pagelinks LIMIT 10 |
5 years ago |
| SELECT * FROM pagelinks WHERE tl_from = 632319 #LIMIT 10 |
5 years ago |
| SELECT * FROM templatelinks WHERE tl_from = 632319 #LIMIT 10 |
5 years ago |
| SELECT * FROM templatelinks WHERE tl_from = 632319 LIMIT 10 |
5 years ago |
| SELECT * FROM templatelinks LIMIT 10 |
5 years ago |
| SELECT DISTINCT cl_type FROM categorylinks LIMIT 10 |
5 years ago |
| SELECT * FROM categorylinks LIMIT 10 |
5 years ago |
| SELECT page_title, page_namespace, cl_to, cl_namespace FROM page INNER JOIN... |
5 years ago |
| SELECT *, CASE WHEN page_is_new=1 THEN 'mw:NewPage' ELSE 'mw:Page' END AS... |
5 years ago |
| SELECT *, CASE WHEN page_is_new=1 THEN 'mw:NewPage' ELSE 'mw:Page' END AS... |
5 years ago |
| SELECT * FROM page WHERE page_is_new =1 LIMIT 10 |
5 years ago |
| SELECT * FROM page LIMIT 10 |
5 years ago |
| SELECT page_title, page_namespace, rd_namespace, rd_title
FROM... |
5 years ago |
| select * from categorylinks limit 10 |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| #SELECT page_id, page_namespace, page_title, page_latest,... |
5 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
5 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
5 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
5 years ago |
| SELECT page_id, page_namespace, page_title, page_latest, page_content_model,... |
5 years ago |
| USE ruwiki_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 ruwiki_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 ruwiki_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 ruwiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE ruwiki_p;
SELECT * from categorylinks WHERE... |
6 years ago |
| USE ruwiki_p;
SELECT * from categorylinks LIMIT 10;
#SELECT cl_to,... |
6 years ago |
| USE ruwiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE ruwiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT cl_to, ips_item_id
FROM categorylinks
INNER JOIN... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
INNER JOIN page... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
# INNER JOIN... |
6 years ago |
| #USE eswiki_p;
#SELECT *
# FROM categorylinks
# WHERE cl_to IN... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
WHERE cl_to IN... |
6 years ago |
| USE eswiki_p;
SELECT *
FROM categorylinks
WHERE cl_to IN... |
6 years ago |
| SELECT *
FROM categorylinks
WHERE cl_to IN... |
6 years ago |
| SELECT *
FROM categorylinks
WHERE cl_to IN ('Alumnado de la Universidad... |
6 years ago |
| select * from categorylinks LIMIT 10; |
6 years ago |
| select * from page LIMIT 10; |
6 years ago |
