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