USE cswiki_p;
SELECT DISTINCT page_namespace, page_title
FROM... |
5 years ago |
USE cswiki_p;
SELECT DISTINCT page_namespace, page_title
FROM... |
5 years ago |
USE cswiki_p;
SELECT DISTINCT page_namespace, page_title
FROM... |
5 years ago |
USE cswiki_p;
SELECT DISTINCT page_namespace, page_title
FROM... |
5 years ago |
USE cswiki_p;
SELECT page_namespace, page_title
FROM categorylinks
JOIN page... |
5 years ago |
USE cswiki_p;
SELECT page_title, cl_to FROM categorylinks
JOIN page ON... |
5 years ago |
USE cswiki_p;
SELECT page_title, cl_to FROM categorylinks
JOIN page ON... |
5 years ago |
USE cswiki_p;
SELECT page_title, cl_to FROM categorylinks
JOIN page ON... |
5 years ago |
USE cswiki_p;
SELECT * FROM categorylinks
JOIN page ON page_id =... |
5 years ago |
USE cswiki_p;
SELECT * FROM categorylinks
JOIN page ON page_id =... |
5 years ago |
USE cswiki_p;
DESCRIBE categorylinks; |
5 years ago |
blank query |
5 years ago |
USE cswiki_p;
SELECT COUNT(*) FROM actor; |
5 years ago |
USE cswiki_p;
SELECT COUNT(*) FROM actor; |
5 years ago |
USE cswiki_p;
SELECT * FROM actor ORDER BY actor_id LIMIT 100; |
5 years ago |
DESCRIBE actor; |
5 years ago |
DESCRIBE revision; |
5 years ago |
blank query |
6 years ago |
USE wikidatawiki_p;
SELECT COUNT(*) FROM revision_userindex WHERE... |
6 years ago |
USE meta_p;
SELECT * FROM wiki WHERE is_closed = 0 AND family = 'wikipedia'; |
6 years ago |
USE meta_p;
SELECT * FROM wiki WHERE is_closed = 0; |
6 years ago |
USE meta_p;
SELECT * FROM wiki; |
6 years ago |
USE wikidatawiki_p;
SELECT rc_namespace, rc_title FROM recentchanges
WHERE... |
6 years ago |
USE wikidatawiki_p;
SELECT rc_namespace, rc_title FROM recentchanges
WHERE... |
6 years ago |
blank query |
6 years ago |
USE wikidatawiki_p;
SELECT rc_title, rc_timestamp, rc_comment,... |
6 years ago |
USE wikidatawiki_p;
SELECT rc_title, rc_timestamp, rc_comment,... |
6 years ago |
USE wikidatawiki_p;
SELECT rc_title, rc_timestamp, rc_comment,... |
6 years ago |
USE wikidatawiki_p;
SELECT rc_title, rc_timestamp, rc_comment,... |
6 years ago |
USE wikidatawiki_p;
SELECT rc_title, rc_timestamp, rc_comment,... |
6 years ago |
blank query |
6 years ago |
blank query |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_namespace, rc_title
FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_namespace, rc_title
FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_namespace, rc_title
FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_title
FROM recentchanges
WHERE... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_title
FROM recentchanges
WHERE... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id), ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT term_full_entity_id, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT term_full_entity_id, ips_site_id,... |
6 years ago |
USE wikidatawiki_p;
SELECT *
FROM wb_items_per_site
LEFT JOIN wb_terms
ON... |
6 years ago |
USE wikidatawiki_p;
SELECT *
FROM wb_items_per_site
LEFT JOIN wb_terms
ON... |
6 years ago |
USE wikidatawiki_p;
SELECT *
FROM wb_items_per_site
LEFT JOIN wb_terms
ON... |
6 years ago |
USE wikidatawiki_p;
DESCRIBE wb_items_per_site;
DESCRIBE wb_terms; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES;
#SELECT * FROM wb_items_per_site |
6 years ago |
blank query |
6 years ago |
Use wikidatawiki_p;
SELECT COUNT(*) FROM page WHERE page_namespace = 0 AND... |
6 years ago |
blank query |
6 years ago |
SELECT page_title, COUNT(pl_from) AS backlinks
FROM templatelinks
JOIN page... |
6 years ago |
SELECT page_title, COUNT(pl_from) AS backlinks
FROM templatelinks
JOIN page... |
6 years ago |
SELECT page_title, COUNT(pl_from) AS backlinks FROM page_props
JOIN page ON... |
6 years ago |
USE commonswiki_p;
SELECT p.page_title AS cat_name, ll.ll_title AS... |
6 years ago |
USE commonswiki_p;
SELECT p.page_title AS cat_name, ll.ll_title AS... |
6 years ago |
USE commonswiki_p;
SELECT p.page_title AS cat_name, ll.ll_title AS... |
6 years ago |
USE commonswiki_p;
SELECT p.page_title AS cat_name, ll.ll_title AS... |
6 years ago |
DESCRIBE langlinks; |
6 years ago |
blank query |
6 years ago |
/*
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt:... |
9 years ago |
USE cswiki_p;
SELECT * FROM revision WHERE rev_comment IN ("tiskl",... |
9 years ago |
/*
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt:... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
Uterm_languageUSE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, inter_linked.pl_title,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, epp_entity_id#,... |
9 years ago |
USE wikidatawiki_p;
SELECT *#page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT *#page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT *#page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT *#page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
/*SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, prop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, irop_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, item_labels.term_language,... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, term_language, term_text
FROM... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, term_language, term_text
FROM... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, term_language, term_text
FROM... |
9 years ago |
USE wikidatawiki_p;
SELECT page_title, term_language, term_text
FROM... |
9 years ago |
USE wikidatawiki_p;
SELECT *
FROM wb_property_info
JOIN (SELECT * FROM... |
9 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_property_info
JOIN (SELECT * FROM page... |
9 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_property_info
#JOIN (SELECT * 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 |