| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
8 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:",page_title) as page_title,... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:",page_title) as page_title,... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:",page_title) as page_title,... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:",page_title) as page_title,... |
9 years ago |
| use cswiki_p;
select * from page where page_is_redirect=1 and page_namespace=1 |
9 years ago |
| use cswiki_p;
select CONCAT("https://cs.wikipedia.org/wiki/Kategorie:",... |
9 years ago |
| use cswiki_p;
select CONCAT("https://cs.wikipedia.org/wiki/", page_title,... |
9 years ago |
| use cswiki_p;
select CONCAT("https://cs.wikipedia.org/wiki/", page_title) as... |
9 years ago |
| use cswiki_p;
select CONCAT("https://cs.wikipedia.org/wiki/", page_title) as... |
9 years ago |
| use cswiki_p;
select CONCAT("Kategorie:", page_title) as... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:", page_title) as... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:", page_title) as... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:", page_title) as page_title from page... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:", page_title) as page_title from page... |
9 years ago |
| use cswiki_p;
select CONCAT("Diskuse:", page_title) from page where... |
9 years ago |
| use cswiki_p;
select * from page where page_is_redirect=1 and... |
9 years ago |
| use cswiki_p;
select * from page limit 10; |
9 years ago |
| use cswiki_p;
select * from page where page_title="Spalovací_motor" limit 1; |
9 years ago |
| use cswiki_p;
select * from categorylinks limit 10; |
9 years ago |
| use cswiki_p;
select * from categorylinks limit 10; |
9 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site where ips_item_id="207434" |
9 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site where ips_item_id="Q207434" |
9 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from wb_entity_per_page limit 10 |
9 years ago |
| use wikidatawiki_p;
show tables |
9 years ago |
| use wikidatawiki_p;
select * from archive limit 100 |
9 years ago |
| use wikidatawiki_p;
select * from archive where ar_rev_id=262899735 limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from archive limit 10 |
9 years ago |
| use wikidatawiki_p;
show tables |
9 years ago |
| use wikidatawiki_p;
select * from text where old_id=262899735 limit 1 |
9 years ago |
| use wikidatawiki_p;
select * from archive limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from archive where ar_rev_id=262899735 limit 1 |
9 years ago |
| use wikidatawiki_p;
select * from revision limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from revision |
9 years ago |
| use wikidatawiki_p;
select * from page where page_namespace=0 limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from page limit 10 |
9 years ago |
| select * from page limit 10 |
9 years ago |
| show tables from wikidatawiki_p;
|
9 years ago |
| use wikidatawiki_p;
select * from page where page_namespace=0 limit 10; |
9 years ago |
| use wikidatawiki_p;
select * from page limit 10; |
9 years ago |
| use cswiki_p;
select page_title from page where page_len < 2000 and... |
9 years ago |
| use cswiki_p;
select page_title from page where page_len < 2000 and... |
9 years ago |
| use cswiki_p;
select * from page where page_len < 2000 and page_namespace=0... |
9 years ago |
| use cswiki_p;
select * from page where page_len < 2000 and page_namespace=0 limit 10 |
9 years ago |
| use cswiki_p;
select * from page where page_len < 2000 limit 10 |
9 years ago |
| use wikidatawiki_p;
select * from page limit 10 |
9 years ago |
| show tables from wikidatawiki_p; |
9 years ago |
| show tables from wikidata; |
9 years ago |
| show tables from wikidata; |
9 years ago |
| show tables from wikidata_p; |
9 years ago |
| use cswiki_p;
select * from categorylinks limit 10 |
9 years ago |
| use cswiki_p;
select * from categorylinks limit 10 |
9 years ago |
| use cswiki_p;
describe categorylinks |
9 years ago |
| show tables from cswiki_p; |
9 years ago |
| use cswiki_p;
select page.page_title, count(pagelinks.pl_from) from... |
9 years ago |
| use cswiki_p;
select page.page_title, count(pagelinks.*) from pagelinks,... |
9 years ago |
| use cswiki_p;
(select page_id as id, page_title as title from page) as... |
9 years ago |
| use cswiki_p;
(select page_id as id, page_title as title from page) as... |
9 years ago |
| use cswiki_p;
(select page_id as id, page_title as title from page) as... |
9 years ago |
| use cswiki_p;
select count(*) from pagelinks where pl_title="Knihovna" and... |
9 years ago |
| use cswiki_p;
select count(*) from pagelinks where pl_title="Knihovna" and... |
9 years ago |
| use cswiki_p;
select count(*) from pagelinks where pl_title="9_mm" and... |
9 years ago |
| use cswiki_p;
select * from pagelinks where pl_title="9_mm" and pl_from_namespace=0 |
9 years ago |
| use cswiki_p;
select * from pagelinks where pl_title="9_mm" and pl_from_namespace=0 |
9 years ago |
| use cswiki_p;
describe pagelinks; |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_namespace=0 and... |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_namespace=0 and... |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_namespace=0 LIMIT 10 |
9 years ago |
| use cswiki_p;
SELECT * FROM page LIMIT 10 |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_title="E!_Rank" LIMIT 1 |
9 years ago |
| use cswiki_p;
DESCRIBE page; |
9 years ago |
| use cswiki_p;
DESCRIBE pagelinks; |
9 years ago |
| SHOW TABLES FROM cswiki_p; |
9 years ago |
| use cswiki_p;
SELECT * FROM pagelinks LIMIT 100 |
9 years ago |
| use cswiki_p;
SELECT * FROM pagelinks LIMIT 10 |
9 years ago |
| use cswiki_p;
SELECT * FROM page LIMIT 10 |
9 years ago |
| use cswiki_p;
DESCRIBE categorylinks; |
9 years ago |
| use cswiki_p;
DESCRIBE pagelinks; |
9 years ago |
| use cswiki_p;
DESCRIBE page; |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_id=255; |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_id=15510; |
9 years ago |
| use cswiki_p;
SELECT * FROM page WHERE page_id=4726; |
9 years ago |
| use cswiki_p;
DESCRIBE page; |
9 years ago |
