| SELECT * FROM wb_id_counters; |
2 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
5 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
6 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
6 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
6 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
8 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
/* SELECT * FROM wb_id_counters; */
SELECT * From... |
9 years ago |
| use wikidatawiki_p;
/* SELECT * FROM wb_id_counters; */
DESCRIBE revision; |
9 years ago |
| use wikidatawiki_p;
/* SELECT * FROM wb_id_counters; */
DESCRIBE page; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
SELECT * From wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_id_counters; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site;/*wb_id_counters*/ |
9 years ago |
| use wikidatawiki_p;
Show Tables; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_entity_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_entity_per_page; |
9 years ago |
| use wikidatawiki_p;
SHOW TABLES; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_changes; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE revision; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE templatelinks; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE pagelinks; |
9 years ago |
| use wikidatawiki_p;
SELECT * From revision Where rev_user_text = 'Matěj... |
9 years ago |
| use wikidatawiki_p;
SELECT * From revision Where rev_user = 'Matěj... |
9 years ago |
| use wikidatawiki_p;
DESCRIBE revision; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE page; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE page; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM page WHERE page_namespace = 1 AND... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM page WHERE page_namespace= 2 AND... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM page WHERE page_title = 'User:Matěj Suchánek'; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE page; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
SELECT * from wb_property_info WHERE pi_property_id = 31; |
9 years ago |
| use wikidatawiki_p;
SELECT * from wb_property_info WHERE pi_property_id <> 5; |
9 years ago |
| use wikidatawiki_p;
SELECT * from wb_property_info WHERE pi_property_id = 5; |
9 years ago |
| use wikidatawiki_p;
SELECT * from wb_terms
WHERE term_entity_id = 5
AND... |
9 years ago |
| use wikidatawiki_p;
SELECT * from wb_terms
WHERE term_entity_id < 10
AND... |
9 years ago |
| USE wikidatawiki_p;
DESCRIBE wb_terms.term_type; |
9 years ago |
| USE wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| USE wikidatawiki_p;
SELECT pl_title, count(*)
FROM... |
9 years ago |
| USE wikidatawiki_p;
SELECT pl_title, count(*)
FROM... |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE pagelinks; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_items_per_site AS item where... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_items_per_site AS item where... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_items_per_site AS item where ips_item_id = 213; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_items_per_site; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE pagelinks; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE page_props; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE page; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_terms; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_entity_per_page WHERE epp_entity_type =... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_entity_per_page WHERE epp_entity_type =... |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_entity_per_page WHERE epp_entity_id < 11; |
9 years ago |
| use wikidatawiki_p;
SELECT * FROM wb_entity_per_page WHERE epp_entity_id = 1; |
9 years ago |
| use wikidatawiki_p;
DESCRIBE wb_entity_per_page; |
9 years ago |
