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 |