| USE wikidatawiki_p;
SELECT rc_timestamp, rc_namespace, rc_title,... |
4 years ago |
| USE wikidatawiki_p;
SELECT rc_timestamp, rc_namespace, rc_title,... |
4 years ago |
| USE wikidatawiki_p;
SELECT rc_timestamp, rc_namespace, rc_title,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM recentchanges
JOIN comment_recentchanges... |
4 years ago |
| USE wikidatawiki_p;
DESCRIBE recentchanges;
/*SELECT * FROM... |
4 years ago |
| blank query |
4 years ago |
| USE wikidatawiki_p;
#/*
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT I1.wbit_item_id AS item1, I2.wbit_item_id AS... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT 1 FROM wbt_term_in_lang AS Ltl1
WHERE... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT I1.wbit_item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT I1.wbit_item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT I1.wbit_item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
/*
SELECT I1.wbit_item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT I1.wbit_item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT *
FROM wbt_item_terms AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT *
FROM wbt_item_terms AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT * FROM wbt_item_terms AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT * FROM wbt_item_terms AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
SELECT I1.* FROM wbt_item_terms... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
/*SELECT * FROM wbt_item_terms... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_type;
DESCRIBE... |
4 years ago |
| USE wikidatawiki_p;
DESCRIBE wbt_item_terms;
DESCRIBE wbt_type;
DESCRIBE... |
4 years ago |
| USE wikidatawiki_p;
SHOW TABLES LIKE 'wb%';
DESCRIBE... |
4 years ago |
| blank query |
4 years ago |
| USE wikidatawiki_p;
SELECT L2.* FROM wb_terms AS L1
JOIN wb_terms AS L2... |
4 years ago |
| USE wikidatawiki_p;
SHOW TABLES;
SELECT L2.* FROM wb_terms AS L1
JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT L2.* FROM wb_terms AS L1
JOIN wb_terms AS L2... |
4 years ago |
| USE wikidatawiki_p;
SELECT L2.* FROM wb_terms AS L1
JOIN wb_terms AS L2... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_terms WHERE term_language = 'cs' AND... |
4 years ago |
| blank query |
4 years ago |
| USE cswiki_p;
SELECT pp_value, COUNT(*)
FROM page_props
WHERE pp_propname IN... |
4 years ago |
| USE cswiki_p;
SELECT pp_value, COUNT(*)
FROM page_props
WHERE pp_propname =... |
4 years ago |
| USE cswiki_p;
SELECT pp_value, COUNT(*)
FROM page_props
WHERE pp_propname =... |
4 years ago |
| USE cswiki_p;
SELECT pp_value, COUNT(*) FROM page_props
WHERE pp_propname =... |
4 years ago |
| USE cswiki_p;
SELECT * FROM page_props
WHERE pp_propname = 'page_image'
LIMIT 100; |
4 years ago |
| USE cswiki_p;
SELECT DISTINCT pp_propname FROM page_props; |
4 years ago |
| USE cswiki_p;
SELECT DISTINCT pp_propname FROM pageprops; |
4 years ago |
| USE wikidatawiki_p;
SELECT page_namespace, page_title, rev_timestamp,... |
4 years ago |
| blank query |
4 years ago |
| USE wikidatawiki_p;
SELECT page_namespace, page_title, rev_timestamp,... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision
JOIN page ON page_id =... |
4 years ago |
| blank query |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_id, rev.rev_page, comment_text#,... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_id, rev.rev_page, comment_text#,... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_id, rev.rev_page, comment_text#,... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_id, rev.rev_page#, page_namespace, page_title,... |
4 years ago |
| USE cswiki_p;
SELECT page_namespace, page_title, rev.rev_id, actor_name#,... |
4 years ago |
| USE cswiki_p;
SELECT page_namespace, page_title, rev.rev_id
FROM revision AS... |
4 years ago |
| USE cswiki_p;
SELECT page_namespace, page_title, rev.rev_id, actor_name,... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id, actor_name,... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id, parent.rev_comment_id... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id, parent.rev_comment_id... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id, parent.rev_comment_id... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id FROM revision AS... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id FROM revision AS... |
4 years ago |
| USE cswiki_p;
SELECT rev.rev_page AS page, rev.rev_id FROM revision AS... |
4 years ago |
| blank query |
4 years ago |
| USE wikidatawiki_p;
SELECT term_full_entity_id, COUNT(*) FROM wb_terms WHERE... |
4 years ago |
