| # query by User:Vahurzpu
use commonswiki_p;
SELECT DISTINCT... |
3 years ago |
| # query by User:Vahurzpu
use commonswiki_p;
SELECT DISTINCT... |
3 years ago |
| # query by User:Vahurzpu
use commonswiki_p;
SELECT DISTINCT... |
3 years ago |
| # query by User:Vahurzpu
use commonswiki_p;
SELECT DISTINCT... |
3 years ago |
| SELECT *
FROM commonswiki_p.wbc_entity_usage, commonswiki_p.page as cp
WHERE... |
4 years ago |
| SELECT DISTINCT eu_entity_id
FROM commonswiki_p.wbc_entity_usage,... |
4 years ago |
| SELECT *
FROM commonswiki_p.wbc_entity_usage, commonswiki_p.page as cp
WHERE... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM commonswiki_p.wbc_entity_usage,... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM wbc_entity_usage, page as p1
WHERE... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM wbc_entity_usage, page as p1
WHERE... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM wbc_entity_usage, page as p1
WHERE... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM wbc_entity_usage
LIMIT 10 |
4 years ago |
| USE wikidatawiki_p;
SELECT *
FROM wbc_entity_usage
LIMIT 10 |
4 years ago |
| USE wikidatawiki_p;
SELECT pl_title, count(*) AS cnt
FROM pagelinks
WHERE... |
4 years ago |
| USE wikidatawiki_p;
SELECT pl_title, count(*) AS cnt
FROM pagelinks
WHERE... |
4 years ago |
| USE wikidatawiki_p;
SELECT pl_title, count(*) AS cnt
FROM pagelinks
WHERE... |
4 years ago |
| use wikidatawiki_p; |
5 years ago |
| use commonswiki_p; |
5 years ago |
| use commonswiki_p; SELECT * from image where img_metadata like... |
5 years ago |
| use commonswiki_p; SELECT * from image where img_metadata like... |
5 years ago |
| use commonswiki_p; SELECT * from image where img_metadata like... |
5 years ago |
| use commonswiki_p; SELECT * from image where img_metadata like... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct, FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| use commonswiki_p |
5 years ago |
| use commonswiki_p; SELECT a2, COUNT(*) as cct FROM (Select img_name,... |
5 years ago |
| USE wikidatawiki_p; |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language,... |
5 years ago |
| USE enwiki_p; |
5 years ago |
| USE zhwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE ruwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE nlwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE nlwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE enwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE jawiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE cebwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE svwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE ptwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE plwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE eswiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE itwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE enwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE enwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| USE frwiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
5 years ago |
| use wikidatawiki_p;
|
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LEFT JOIN tag_summary ON... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LIMIT 10
|
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges LEFT... |
5 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
5 years ago |
| use wikidatawiki_p;
|
5 years ago |
| use wikidatawiki_p;
SELECT *
FROM wb_terms
WHERE term_type = 'label'
AND... |
5 years ago |
| use wikidatawiki_p;
SELECT *
FROM wb_terms
WHERE term_type = 'label'
AND... |
5 years ago |
| use wikidatawiki_p;
SELECT *
FROM wb_terms
WHERE term_type = 'label'
AND... |
5 years ago |
| use wikidatawiki_p;
SELECT *
FROM wb_terms
WHERE term_type = 'label'
LIMIT 10 |
5 years ago |
| use wikidatawiki_p;
SELECT term_type
FROM wb_terms
WHERE term_type <>... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type
FROM wb_terms
WHERE term_type <>... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type
FROM wb_terms
WHERE term_type <>... |
5 years ago |
| use wikidatawiki_p;
SELECT DISTINCT term_type
FROM wb_terms |
5 years ago |
| use wikidatawiki_p;
SELECT term_full_entity_id, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_full_entity_id, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_full_entity_id, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_full_entity_id, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT term_type, term_language, term_text
FROM... |
5 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
5 years ago |
| use wikidatawiki_p;
DESCRIBE wb_terms;
DESCRIBE wb_items_per_site;
DESCRIBE... |
5 years ago |
| use wikidatawiki_p;
SHOW TABLES;
DESCRIBE wb_terms;
DESCRIBE... |
5 years ago |
| use wikidatawiki_p;
|
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT COUNT(*) as ?ct
from... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT COUNT(*) as ?ct
from... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT COUNT(*) as ?ct
from... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
# SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
SHOW TABLES;
SELECT *
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page,... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page,... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props, page
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props,... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props,... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site, page_props
WHERE... |
5 years ago |
| use wikidatawiki_p;
SELECT ips_item_id
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
SELECT ips_item_id
from wb_items_per_site,... |
5 years ago |
| use wikidatawiki_p;
SELECT ips_item_id, ips_site_id, ips_site_page
from... |
5 years ago |
| use wikidatawiki_p; |
7 years ago |
| use wikidatawiki_p;
SELECT page_title, cl_to
FROM categorylinks, page WHERE... |
7 years ago |
| use wikidatawiki_p;
SELECT pagetitle, cl_to
FROM categorylinks, page WHERE... |
7 years ago |
| use wikidatawiki_p;
SELECT * FROM categorylinks WHERE cl_to LIKE... |
7 years ago |
| use wikidatawiki_p;
SELECT * FROM categorylinks WHERE cat_to LIKE... |
7 years ago |
| use wikidatawiki_p;
SELECT * FROM CATEGORIES WHERE cat_title LIKE... |
7 years ago |
| use wikidatawiki_p; |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges... |
8 years ago |
| use jamwiki_p;
show tables |
8 years ago |
| use jamwiki_p;
show tables |
8 years ago |
| use jamwiki_p;
show tables |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use wikidatawiki_p;
select t1.term_text, t2.term_text
from wb_terms as t1,... |
8 years ago |
| use wikidatawiki_p;
select t1.term_text, t2.term_text
from wb_terms as t1,... |
8 years ago |
| use wikidatawiki_p;
select t1.term_text, t2.term_text
from wb_terms as t1,... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_terms as t1, wb_terms as t2
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_terms as t1, wb_terms as t2
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_terms as t1, wb_terms as t2
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_terms as t1, wb_terms as t2
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_terms
where term_type = "label"
and... |
8 years ago |
| use wikidatawiki_p;
select term_language, term_entity_id, term_text
from... |
8 years ago |
| use wikidatawiki_p;
select term_language, concat("[[", page_title, "]]") as... |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges
WHERE rc_title LIKE '%CEE%'
AND... |
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges
WHERE rc_title LIKE '%CEE%'
AND... |
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges
WHERE rc_title LIKE '%CEE%'
LIMIT 2000 |
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges LIMIT 2000 |
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges ORDER BY recentchanges LIMIT 2000 |
8 years ago |
| use metawiki_p;
SELECT * FROM recentchanges LIMIT 2000 ORDER BY recentchanges; |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges LIMIT 2000 ORDER BY DESC... |
8 years ago |
| use wikidatawiki_p; |
8 years ago |
| use wikidatawiki_p;
SELECT "nositelinks" as sit, COUNT(*) as ct
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT "nositelinks" as sit, COUNT(*) as ct
FROM page,... |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT NOW();
SELECT COUNT(*) FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT NOW();
SELECT COUNT(*) FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT COUNT(*) FROM page, page_props... |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use wikidatawiki_p;
SELECT "nositelinks" as sit, COUNT(*) as ct FROM page,... |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT COUNT(*) FROM page, page_props... |
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT COUNT(*) FROM page, page_props... |
8 years ago |
| use wikidatawiki_p;
SELECT NOW();
SELECT COUNT(*) FROM page, page_props... |
8 years ago |
| use wikidatawiki_p;
SELECT NOW(); |
8 years ago |
| use wikidatawiki_p;
SELECT NOW(); |
8 years ago |
| use wikidatawiki_p;
SELECT NOW(); |
8 years ago |
| use wikidatawiki_p;
SELECT NOW(); |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM NOW(); |
8 years ago |
| use wikidatawiki_p;
NOW();
SELECT COUNT(*) FROM page, page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page, page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page, page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
|
8 years ago |
| use wikidatawiki_p;
SELECT pp_sortkey, CONCAT(">",pp_sortkey,"<"), COUNT(*)... |
8 years ago |
| use wikidatawiki_p;
SELECT pp_sortkey, COUNT(*) FROM page, page_props ... |
8 years ago |
| use wikidatawiki_p;
SELECT pp_sortkey, COUNT(*) FROM page, page_props ... |
8 years ago |
| use wikidatawiki_p;
SELECT pp_sortkey, COUNT(*) FROM page, page_props ... |
8 years ago |
| use wikidatawiki_p;
SELECT pp_sortkey, COUNT(*) FROM page, page_props ... |
8 years ago |
| use wikidatawiki_p; |
8 years ago |
| use wikidatawiki_p;
SELECT page_title FROM page
LEFT JOIN page_props
ON... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page, page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page
WHERE
page_namespace = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page_props WHERE pp_propname="wb-claims"
|
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(*) FROM page_props WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page
WHERE page_namespace =... |
8 years ago |
| use wikidatawiki_p; |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title, page_id
FROM page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title
FROM page, wb_entity_per_page,... |
8 years ago |
| use wikidatawiki_p; |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| SELECT pp_page
FROM ocwiki_p.page_props
WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page
FROM ocwiki_p.wp_page_props
WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page
FROM ocwiki_p.wp_page_props
WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page FROM ocwiki_p.wp_page_props WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page FROM ocwiki_p.wp_page_props WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page FROM oc_wiki.wp_page_props WHERE pp_propname = "hiddencat" |
8 years ago |
| SELECT pp_page FROM oc_wiki_p.wp_page_props WHERE pp_propname = "hiddencat" |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID... |
8 years ago |
| use ocwiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID
FROM... |
8 years ago |
| use ocwiki_p;
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID
FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use ocwiki_p;
SELECT * FROM page_props
WHERE pp_propname = "hiddencat"
LIMIT 200
|
8 years ago |
| use ocwiki_p;
SELECT * FROM page_props
WHERE pp_propname =... |
8 years ago |
| use ocwiki_p;
SELECT pp_propname, COUNT(*) FROM page_props
GROUP BY... |
8 years ago |
| use ocwiki_p;
SELECT pp_propname, COUNT(*) FROM page_props
GROUP BY... |
8 years ago |
| use ocwiki_p;
SELECT pp_propname, COUNT(*) FROM page_props
GROUP BY... |
8 years ago |
| use ocwiki_p;
SELECT * FROM page_props
LIMIT 200
|
8 years ago |
| use wikidatawiki_p;
SELECT page_title FROM page, page_props,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title FROM page, page_props,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title FROM page, page_props,... |
8 years ago |
| use wikidatawiki_p;
SELECT *
FROM ocwiki_p.page, ocwiki_p.page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT *
FROM ocwiki_p.page, ocwiki_p.page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT *
FROM ocwiki_p.page, ocwiki_p.page_props
WHERE... |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM categorylinks LIMIT 20
|
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT COUNT(DISTINCT(rc_user)) FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
WHERE rc_user in... |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
WHERE rc_user in... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
LIMIT 2000
|
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
LIMIT 2000
|
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
LIMIT 20
|
8 years ago |
| use wikidatawiki_p;
SELECT * FROM recentchanges
LIMIT 20
|
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE
rc_user_text =... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE
rc_user_text =... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| use wikidatawiki_p;
SELECT *
from recentchanges
WHERE rc_user = 0
AND... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_user, rc_user_text
from recentchanges
GROUP... |
8 years ago |
| use wikidatawiki_p;
SELECT rc_user, rc_user_text
from recentchanges
GROUP... |
8 years ago |
| use wikidatawiki_p;
SELECT LEFT(rc_timestamp, 8), COUNT(*)
from... |
8 years ago |
| use wikidatawiki_p;
SELECT CURRENT_DATE;
SELECT *
from recentchanges
LIMIT 10
|
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT bla, COUNT(*)
FROM (SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT
SUBSTRING_INDEX(rc_comment, ':',... |
8 years ago |
| use wikidatawiki_p;
SELECT
SUBSTRING_INDEX(rc_comment, ':',... |
8 years ago |
| use wikidatawiki_p;
SELECT
SUBSTRING_INDEX(rc_comment, ':',... |
8 years ago |
| use wikidatawiki_p;
SELECT
SUBSTRING_INDEX(rc_comment, ':', 1)
COUNT(*)... |
8 years ago |
| use wikidatawiki_p;
SELECT
SUBSTRING_INDEX(rc_comment, ':',... |
8 years ago |
| use wikidatawiki_p;
SELECT LEFT(rc_comment, 22)
#COUNT(DISTINCT(rc_user))... |
8 years ago |
| use wikidatawiki_p;
SELECT LEFT(rc_comment, 22)
#COUNT(DISTINCT(rc_user))... |
8 years ago |
| use wikidatawiki_p;
SELECT LEFT(rc_comment, 30)
#COUNT(DISTINCT(rc_user))... |
8 years ago |
| use wikidatawiki_p;
SELECT LEFT(rc_comment, 20)
#COUNT(DISTINCT(rc_user))... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) As item,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to, c.cnt, d.pp_value
FROM
(SELECT... |
8 years ago |
| use wikidatawiki_p;
SELECT c.cl_to, c.cnt, d.pp_value
FROM
(SELECT... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
SUM(CASE WHEN ValueRange = '0'... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
SUM(CASE WHEN ValueRange = '0'... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
SUM(CASE WHEN ValueRange = '0'... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
SUM(CASE WHEN ValueRange = '0'... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE pp_sortkey
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE pp_sortkey
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE pp_sortkey
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE pp_sortkey
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE pp_sortkey
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_sortkey,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_value, pp_sortkey
FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_value, pp_sortkey
FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_value, pp_sortkey ,
CASE
... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_value, ,
CASE
WHEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, pp_value
FROM page_props,... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id
FROM page_props, wb_items_per_site,... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| use wikidatawiki_p;
SELECT ips_site_id,
CASE
WHEN pp_sortkey=0 THEN... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as... |
8 years ago |
| use wikidatawiki_p;
use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
|
use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
|
use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
|
use wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id) as item,... |
8 years ago |
| SELECT CONCAT("Q",ips_item_id) as item, COUNT(ips_site_id) as cnt,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT CURRENT_DATE;
USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id),... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # Redirects in sitelinks to a specific wiki (here "fa")
# see also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT "ru" As Wiki, count(page_id) As ct_redirects FROM ruwiki_p.page JOIN... |
8 years ago |
| # test
# See also... |
8 years ago |
|
SELECT "sv" As Wiki, count(page_id) FROM svwiki_p.page JOIN... |
8 years ago |
|
SELECT "sv" As Wiki, count(page_id) FROM svwiki_p.page JOIN... |
8 years ago |
|
SELECT "sv" As Wiki FROM svwiki_p.page JOIN svwiki_p.page_props
ON... |
8 years ago |
|
SELECT "sv" As Wiki FROM svwiki_p.page JOIN svwiki_p.page_props
ON... |
8 years ago |
|
SELECT "sv" As Wiki FROM svwiki_p.page JOIN svwiki_p.page_props
ON... |
8 years ago |
| USE wikidatawiki_p;
SELECT COUNT(ips_site_page)
FROM wb_items_per_site,... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page, page_is_redirect
FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page
FROM wb_items_per_site
WHERE... |
8 years ago |
| USE wikidatawiki_p;
SELECT ips_site_page
FROM wb_items_per_site
WHERE... |
8 years ago |
| USE wikidatawiki_p;
SELECT COUNT(ips_site_page)
FROM wb_items_per_site
WHERE... |
8 years ago |
| USE wikidatawiki_p;
SELECT COUNT(ips_site_page)
WHERE ips_site_id='svwiki'
|
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM(TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
TRIM('"' FROM SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
SELECT
SUBSTR(
img_metadata,
... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| use commonswiki_p;
#SELECT FIND_IN_SET('Make', img_metadata )
#select ... |
8 years ago |
| # test
# See also... |
8 years ago |
| CREATE FUNCTION SPLIT_STR(
x VARCHAR(255),
delim VARCHAR(12),
pos... |
8 years ago |
| CREATE FUNCTION SPLIT_STR(
x VARCHAR(255),
delim VARCHAR(12),
pos... |
8 years ago |
| use commonswiki_p;
SELECT FIND_IN_SET('Make',img_metadata)
#select ... |
8 years ago |
| use commonswiki_p;
SELECT FIND_IN_SET('make',img_metadata)
#select ... |
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
SELECT COLUMN_LIST(img_metadata)
#select img_name,
#... |
8 years ago |
| use commonswiki_p;
SELECT COLUMN_LIST(img_metadata);
#select img_name,
#... |
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
show tables
|
8 years ago |
| use commonswiki_p;
SELECT * FROM metadata
limit 500
|
8 years ago |
| # test
# See also... |
8 years ago |
| use commonswiki_p;
select img_name,
# img_size , img_media_type,... |
8 years ago |
| use commonswiki_p;
select img_name,
# img_size , img_media_type,... |
8 years ago |
| use commonswiki_p;
select img_name,
# img_size , img_media_type,... |
8 years ago |
| use commonswiki_p;
select img_name,
# img_size , img_media_type,... |
8 years ago |
| use commonswiki_p;
select img_name, img_size , img_media_type,... |
8 years ago |
| use commonswiki_p;
select img_metadata, img_name, img_size ,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SHOW TABLES;
|
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| SELECT SQL_NO_CACHE * FROM enwiki_p.categorylinks JOIN enwiki_p.page_props... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT SQL_NO_CACHE * FROM enwiki_p.categorylinks JOIN enwiki_p.page_props... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
8 years ago |
| use wikidatawiki_p;
SELECT term_language, Count(page_title)
FROM pagelinks,... |
8 years ago |
| use wikidatawiki_p;
SELECT term_language, Count(page_title)
FROM pagelinks,... |
8 years ago |
| use wikidatawiki_p;
SELECT Count(page_title)
FROM pagelinks, page,... |
8 years ago |
| use wikidatawiki_p;
SELECT Count(page_title) AS item, term_type,... |
8 years ago |
| use wikidatawiki_p;
SELECT Count(page_title) AS item, term_type,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| #LAST ITEMs added
SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| #LAST ITEMs added
EXPLAIN SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| #LAST ITEMs added
SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis,... |
8 years ago |
| #LAST ITEMs added
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As... |
8 years ago |
| #LAST ITEMs added
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As... |
8 years ago |
| #LAST ITEMs added
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
use wikidatawiki_p;
SELECT rev_id, rev_page, rev_comment... |
8 years ago |
| #LAST ITEMs added
SELECT rev_id, rev_page, rev_comment FROM revision WHERE... |
8 years ago |
| # test
# See also... |
8 years ago |
| #LAST ITEMs added
SELECT SQL_NO_CACHE * FROM enwiki_p.categorylinks JOIN... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) As item, term_text,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM
(
(SELECT pp_value,... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM
(
(SELECT pp_value,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM ( (SELECT pp_value,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM ( (SELECT pp_value,... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM
(
(SELECT pp_value,... |
8 years ago |
| SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM
(
(SELECT pp_value,... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item
FROM pagelinks AS pl1, page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item
FROM pagelinks, page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item
FROM pagelinks, page,... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item
FROM pagelinks, page,... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
8 years ago |
| # test
# See also... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("#[[",... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("'*[[",... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("'*[[",... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("'*[[",... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("'*[[",... |
8 years ago |
| #All items in a given category with Qid
use enwiki_p;
SELECT CONCAT("'*[[",... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
SELECT enpp.pp_value AS Qid
FROM (enwiki_p.categorylinks As encl,... |
8 years ago |
| # test
# See also... |
8 years ago |
|
SELECT enpp.pp_value AS Qid
FROM (enwiki_p.categorylinks As encl,... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT page_title FROM wikidatawiki_p.pagelinks, wikidatawiki_p.page
... |
8 years ago |
| # test
# See also... |
8 years ago |
| SELECT pl_from FROM wikidatawiki_p.pagelinks
WHERE pl_title... |
8 years ago |
| SELECT pl_from FROM wikidatawiki_p.pagelinks
WHERE pl_title... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| #use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| #use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| #use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p, wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use wikidatawiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
SELECT * FROM page_props... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| use enwiki_p;
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
SELECT * FROM categorylinks LIMIT 5;
SELECT * FROM page_props... |
8 years ago |
| # test
# See also... |
8 years ago |
| use enwiki_p;
SELECT * FROM categorylinks LIMIT 10;
SELECT * FROM page_props... |
8 years ago |
| use enwiki_p;
SELECT * FROM page_props WHERE pp_propname = 'wikibase_item' LIMIT 20; |
8 years ago |
| use enwiki_p;
SELECT pp_page FROM page_props WHERE pp_propname =... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # list of labels for autoedit.js
#
# sample output (for English):
# 'en':... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # Sitelinks per given name item linked from page [[User:Jura1/first... |
8 years ago |
| # Sitelinks per given name item linked from page [[User:Jura1/first... |
8 years ago |
| # Sitelinks per given name item linked from page [[User:Jura1/first... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
8 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| use wikidatawiki_p;
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT term_text AS label, GROUP_CONCAT(CONCAT('Q',... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT term_text AS label, GROUP_CONCAT(CONCAT('Q',... |
9 years ago |
| # test
# See also... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| # test
# See also... |
9 years ago |
| #Given names - list of labels - languages with Roman script
#
use... |
9 years ago |
| #Given names - list of labels - languages with Roman script
#
use... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| #
use wikidatawiki_p;
#SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
use wikidatawiki_p;
#SELECT CONCAT('Q', term_entity_id) AS... |
9 years ago |
| #
use wikidatawiki_p;
#SELECT CONCAT('Q', term_entity_id) AS... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS itemLINKEDfrom,... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
|
SELECT *
FROM quarry.star
LIMIT 10 |
9 years ago |
|
SELECT *
FROM star
LIMIT 10 |
9 years ago |
|
SELECT *
FROM user
LIMIT 10 |
9 years ago |
| USE quarry;
SELECT *
FROM user
LIMIT 10 |
9 years ago |
| SELECT *
FROM user |
9 years ago |
| # test
# See also... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # Given names with site links different from label
#
# Given names: list of... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # Sitelinke per given name item linked from page [[User:Jura1/first... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # Non standard descriptions in given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # count of en-descriptions of given name items
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing decriptions
#
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # For given names, set missing labels in language "nb" based on label in... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
#
use wikidatawiki_p;
#
SELECT page_title AS item
#
FROM pagelinks, page,... |
9 years ago |
| # test
# See also... |
9 years ago |
| #
#
use wikidatawiki_p;
#
SELECT page_title AS item
#
FROM pagelinks, page,... |
9 years ago |
| use wikidatawiki_p;
#
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
#
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
# See also... |
9 years ago |
| use wikidatawiki_p;
#
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| ##list labels - languages with Roman script
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
# See also... |
9 years ago |
| ##list labels - languages with Roman script
use wikidatawiki_p;
SELECT... |
9 years ago |
| ##list labels - languages with Roman script
use wikidatawiki_p;
SELECT... |
9 years ago |
| # test
# See also... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # test
# See also... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # test
# See also... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # list of given name items linked from page [[User:Jura1/first names/items... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # count of en-descriptions
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| # count of en-descriptions
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #list labels - all Roman languages
use wikidatawiki_p;
SELECT page_title AS... |
9 years ago |
| #
use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #list labels - all Roman languages
use wikidatawiki_p;
SELECT page_title AS... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #find multiple lables same text
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| #find multiple lables same text
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #
use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #
use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| #
use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| use wikidatawiki_p;
SELECT term_text, COUNT(page_title) AS ct
FROM... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # list of given names from page
use wikidatawiki_p;
SELECT page_title,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # test
use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item,... |
9 years ago |
| # list of given names from page
use wikidatawiki_p;
SELECT page_title,... |
9 years ago |
| # list of given names from page
use wikidatawiki_p;
SELECT page_title,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # list of given names from page
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| # list of given names from page
use wikidatawiki_p;
SELECT term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT term_text, COUNT(page_title) as UseCT
FROM... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) AS item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| # find "disambiguation" in descriptions of items linked from a given... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_title AS item, term_type, term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_id, page_title, epp_entity_id,... |
9 years ago |
| use wikidatawiki_p;
SELECT page_id, page_title, epp_entity_id
FROM... |
9 years ago |
| use wikidatawiki_p;
SELECT page_id, page_title
FROM pagelinks
JOIN page
ON... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
JOIN page
ON pl_title =... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
JOIN page
ON pl_title =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM page
JOIN pagelinks
ON pl_from =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM page
JOIN pagelinks
ON pl_from =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM page
JOIN pagelinks
ON pl_from =... |
9 years ago |
| use wikidatawiki_p;
SELECT
pl_namespace,
pl_title
FROM page
JOIN... |
9 years ago |
| use wikidatawiki_p;
SELECT
pl_namespace,
pl_title
FROM page
JOIN... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT STRAIGHT_JOIN CONCAT('Q', term_entity_id),... |
9 years ago |
| use wikidatawiki_p; SET max_statement_time=100 FOR
SELECT STRAIGHT_JOIN... |
9 years ago |
| use wikidatawiki_p; SET STATEMENT max_statement_time=100 FOR
SELECT... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_from = 17927576
|
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_terms
WHERE pl_from =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_terms
WHERE pl_from =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_from = 17927576
and... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT pl_title AS pageORitemLINKEDto, CONCAT('Q',... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page
WHERE... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks, wb_entity_per_page
WHERE... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_title = 'Q4877658'... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_from = 4659077 and... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_from = 14546880 and... |
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE pl_from = 14546880
|
9 years ago |
| use wikidatawiki_p;
SELECT *
FROM wb_entity_per_page
WHERE epp_entity_id = 5
|
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', wb_terms.term_entity_id),... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
from pagelinks
WHERE pl_from = 6925559 AND... |
9 years ago |
| use wikidatawiki_p;
DESCRIBE pagelinks;
|
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",pi_property_id) AS propertyId,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT("Q",pi_property_id) AS propertyId,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_language,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, COUNT(*)
from... |
9 years ago |
| use wikidatawiki_p;
SELECT ips_site_id, COUNT(*)
from wb_items_per_site |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
WHERE ips_item_id =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
AND ips_item_id = '5'
LIMIT 100 |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
WHERE ips_site_id =... |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
LIMIT 100 |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
WHERE ips_site_id
LIMIT 100 |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
WHERE ips_site_id
LIMIT 100 |
9 years ago |
| use wikidatawiki_p;
SELECT *
from wb_items_per_site
WHERE ips_site_id < 20 |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use enwiki_p;
SELECT
externallinks.el_from, externallinks.el_to,... |
9 years ago |
| use dewiki_p;
SELECT
externallinks.el_from, externallinks.el_to,... |
9 years ago |
| use rmwiki_p;
SELECT
externallinks.el_from, externallinks.el_to,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use enwiki_p;
SELECT
externallinks.el_from, externallinks.el_to,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id), term_text
from... |
9 years ago |
