Query Run
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