Query Run
USE wikidatawiki_p; SELECT * FROM page WHERE page_namespace = 0 ... 7 months ago
USE wikidatawiki_p; SELECT page_id FROM page WHERE page_namespace = 0 ... 7 months ago
USE wikidatawiki_p; SELECT rev_timestamp, comment_text, actor_name FROM... 7 months ago
USE wikidatawiki_p; SELECT rev_timestamp, comment_text, actor_name FROM... 7 months ago
USE `wikidatawiki_p`; SELECT rev_timestamp, comment_text, actor_name FROM... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment_revision ON... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment ON rev_comment_id... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment_revision ON... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment_revision ON... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment_revision ON... 7 months ago
SELECT * FROM actor_revision LIMIT 10; 7 months ago
SELECT * FROM actor LIMIT 10; 7 months ago
SELECT * FROM revision LIMIT 1; 7 months ago
SELECT * FROM revision LIMIT 1; 7 months ago
SELECT * FROM actor_revision LIMIT 1; 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision JOIN comment_revision ON... 7 months ago
SELECT * FROM revision LIMIT 10; 7 months ago
SELECT * FROM comment_revision LIMIT 10; 7 months ago
SELECT * FROM rev_comment LIMIT 10; 7 months ago
USE `wikidatawiki_p`; SELECT * FROM revision WHERE rev_page = (SELECT... 7 months ago
SELECT * FROM revision LIMIT 10; 7 months ago
SHOW tables; 7 months ago
SHOW tables; 7 months ago
SELECT page_id FROM page WHERE... 7 months ago
USE `wikidatawiki_p`; SELECT pp_propname, pp_value FROM page_props WHERE... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM page_props WHERE pp_page = (SELECT... 7 months ago
USE wikidatawiki_p; SELECT * FROM page WHERE page_namespace = 0 ... 7 months ago
USE wikidatawiki_p; SELECT * FROM page WHERE page_title = 'Q419'; 7 months ago
USE wikidatawiki_p; SELECT page_title FROM page WHERE page_namespace = 120 7 months ago
USE wikidatawiki_p; SELECT page_title, pp_value, pp_sortkey FROM page... 7 months ago
USE wikidatawiki_p; SELECT page_title, pp_value, pp_sortkey FROM page... 7 months ago
SELECT DISTINCT pp_propname FROM page_props LIMIT 10; 7 months ago
SELECT DISTINCT pp_propname FROM page_props LIMIT 40; 7 months ago
SELECT DISTINCT pp_propname FROM page_props LIMIT 100; 7 months ago
SELECT DISTINCT pp_propname FROM page_props LIMIT 10; 7 months ago
SELECT DISTINCT pp_propname FROM page_props LIMIT 1; 7 months ago
USE wikidatawiki_p; SELECT * FROM page JOIN page_props ON page_id =... 7 months ago
USE wikidatawiki_p; SELECT * FROM page JOIN page_props ON page_id =... 7 months ago
USE wikidatawiki_p; SELECT * FROM page JOIN page_props ON page_id =... 7 months ago
SELECT COUNT(*) FROM page_props; 7 months ago
SELECT DISTINCT pp_value FROM page_props; 7 months ago
SELECT DISTINCT pp_value FROM page_props; 7 months ago
USE wikidatawiki_p; SELECT * FROM page JOIN page_props ON page_id =... 7 months ago
USE wikidatawiki_p; SELECT * FROM page JOIN page_props ON page_id =... 7 months ago
USE `wikidatawiki_p`; SELECT COUNT(*) FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT COUNT(page_id) FROM `page` JOIN `page_props`... 7 months ago
USE `wikidatawiki_p`; SELECT COUNT(page_id) FROM `page` JOIN `page_props`... 7 months ago
USE `wikidatawiki_p`; SELECT COUNT(*) FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` ON `page_id`... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` ON `page_id`... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` ON `page_id`... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` ON `page_id`... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` ON `page_id`... 7 months ago
USE `wikidatawiki_p`; SELECT * FROM `page` JOIN `page_props` LIMIT 2; 7 months ago
USE `wikidatawiki_p`; SELECT DISTINCT pp_sortkey FROM `page` JOIN... 7 months ago
SELECT COUNT(*) FROM page_props WHERE pp_propname = 'wikibase_item'; 7 months ago
SELECT COUNT(*) FROM page_props WHERE pp_propname = 'wikibase_item'; 7 months ago
USE `wikidatawiki_p`; SELECT DISTINCT pp_sortkey FROM `page` JOIN... 7 months ago
USE `wikidatawiki_p`; SELECT DISTINCT pp_sortkey FROM `page` JOIN... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM page_props LIMIT... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` LIMIT 10; SELECT... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
USE `wikidatawiki_p`; SELECT pp_sortkey FROM `page` JOIN `page_props` ON... 7 months ago
SELECT pp_sortkey FROM page_props LIMIT 10; 7 months ago
USE `wikidatawiki_p`; SELECT `page_title` AS "lexeme ID", `pp_value` AS... 7 months ago
USE `wikidatawiki_p`; SELECT `page_title` AS "lexeme ID", `pp_value` AS... 7 months ago
SELECT COUNT(*) FROM page_props WHERE pp_propname = 'wikibase_item'; 7 months ago
SELECT * FROM page_props WHERE pp_propname = 'wikibase_item' LIMIT 10; 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT pp_value FROM page_props LIMIT 10; 7 months ago
SELECT * FROM page_props WHERE pp_value = 'Q107661323'; 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT * FROM page_props WHERE pp_value = 'Q52'; 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT * FROM wikidatawiki_p.page_props LIMIT 10; 7 months ago
SELECT * FROM wikidatawiki_p.page_props LIMIT 10; 7 months ago
SELECT * FROM wikidatawiki_p.page_props LIMIT 10; 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT * FROM wikidatawiki_p LIMIT 10; 7 months ago
SHOW TABLES; 7 months ago
wiki 7 months ago
SELECT * FROM page_props LIMIT 10; 7 months ago
SELECT * FROM page_props LIMIT 1; 7 months ago