| use cswiki_p;
select CONCAT("Kategorie:", page_title) from page where... |
7 years ago |
| use cswiki_p;
select CONCAT("Kategorie:", page_title) from page where... |
7 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select count(*) from page where page_title LIKE "Urbanecm/Teahouse%" |
8 years ago |
| use cswiki_p;
select page_title from page
where page_id in (select rev_page... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in (select rev_page from... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in (select rev_page from... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in
#select * from revision... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in
#select * from revision... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in
#select * from revision... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in
#select * from revision... |
8 years ago |
| use cswiki_p;
#select * from page where page_id in
#select * from revision... |
8 years ago |
| use cswiki_p;
#select * from page limit 10;
select * from revision limit 10; |
8 years ago |
| use cswiki_p;
select * from page limit 10; |
8 years ago |
| use cswiki_p;
select page_title from page limit 10; |
8 years ago |
| use cswiki_p;
select count(*) from page where page_namespace=10 and... |
8 years ago |
| use cswiki_p;
select count(*) from page where page_namespace=10 and... |
8 years ago |
| use cswiki_p;
select count(*) from page where page_namespace=10 and... |
8 years ago |
| use cswiki_p;
select count(*) from page where page_namespace=10; |
8 years ago |
| use cswiki_p;
select * from logging where log_action="delete" and log_namespace=3 |
8 years ago |
| use cswiki_p;
select * from logging where log_action="delete" and... |
8 years ago |
| use cswiki_p;
select * from logging where log_action="delete" limit 10 |
8 years ago |
| use cswiki_p;
select * from logging limit 10 |
8 years ago |
| use cswiki_p;
select * from revision where rev_id IN(select page_latest from... |
8 years ago |
| use cswiki_p;
describe page |
8 years ago |
| use cswiki_p;
select * from revision where rev_id IN(select page_lastest... |
8 years ago |
| use cswiki_p;
select * from revisons where rev_id IN(select page_lastest... |
8 years ago |
| use cswiki_p;
select * from revisons where rev_id IN(select page_lastest... |
8 years ago |
| use cswiki_p;
select * from revison where rev_id IN(select page_lastest from... |
8 years ago |
| use cswiki_p;
select * from revision where rev_text_id!=0 |
8 years ago |
| use cswiki_p;
select * from revision limit 10; |
8 years ago |
| use cswiki_p;
select * from page limit 10; |
8 years ago |
| use cswiki_p;
show tables |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log where afl_filter=15 order by... |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log where afl_filter=15 order by... |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log where afl_filter=15 limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log where afi_filter=15 limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_log limit 10; |
8 years ago |
| use cswiki_p;
show tables; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_action where afa_filter=15 limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_action where afa_filter=15 limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_action where afa_filter=17 limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter_action limit 10; |
8 years ago |
| use cswiki_p;
select * from abuse_filter limit 10; |
8 years ago |
| use cswiki_p;
show tables; |
8 years ago |
| use cswiki_p;
select * from logging where log_type="abusefilter" limit 100; |
8 years ago |
| use cswiki_p;
select * from logging where log_type="abusefilter" and... |
8 years ago |
| use cswiki_p;
select * from logging where log_type="abusefilter" limit 100; |
8 years ago |
| use cswiki_p;
select * from logging limit 10; |
8 years ago |
| use cswiki_p;
select CONCAT("Diskuse k Wikipedii:",page_title) as... |
8 years ago |
| USE skwiki_p;
select page_title from page where page_len > 10000 and... |
8 years ago |
| USE skwiki_p;
select page_title from page where page_len > 10000 and... |
8 years ago |
| USE skwiki_p;
select * from page where page_len > 10000 and page_namespace=0... |
8 years ago |
| USE skwiki_p;
select * from page where page_len > 10000 and page_namespace=0... |
8 years ago |
| USE skwiki_p;
select * from page where page_len > 10000 and page_namespace=0... |
8 years ago |
| USE skwiki_p;
select * from page where page_len > 10000 and page_namespace=0... |
8 years ago |
| USE cswiki_p;
SELECT page_title AS page, page_namespace, page_len AS... |
8 years ago |
| USE cswiki_p;
SELECT page_title AS page, page_namespace, page_len AS... |
8 years ago |
| USE cswiki_p;
SELECT page_title AS page, page_namespace, page_len AS... |
8 years ago |
| USE cswiki_p;
SELECT page_title AS page, page_namespace, page_len AS... |
8 years ago |
| use cswiki_p;
select page.page_title from categorylinks, page where... |
8 years ago |
| use cswiki_p;
select * from categorylinks limit 20; |
8 years ago |
| use cswiki_p;
describe categorylinks; |
8 years ago |
| use cswiki_p;
describe categorylinks; |
8 years ago |
| use cswiki_p; |
8 years ago |
| USE cswiki_p;
SELECT CONCAT("Šablona:",page_title),... |
8 years ago |
| USE cswiki_p;
SELECT CONCAT("Kategorie:",page_title), COUNT(cl_from) AS... |
8 years ago |
| USE cswiki_p;
SELECT CONCAT("Kategorie:",page_title), COUNT(cl_from) AS... |
8 years ago |
| use cswiki_p;
describe pagelinks |
8 years ago |
| use cswiki_p;
select pl_title as title from pagelinks where pl_from=(select... |
8 years ago |
| use cswiki_p;
select pl_title as title from pagelinks where pl_from=(select... |
8 years ago |
| use cswiki_p;
select pl_title as title from pagelinks where pl_from=(select... |
8 years ago |
| use cswiki_p;
(select pl_title as title from pagelinks where pl_from=(select... |
8 years ago |
| use cswiki_p;
select * from pagelinks where pl_from=(select page_id from... |
8 years ago |
| use cswiki_p;
select * from page where page_title="Informatika" and page_namespace=0 |
8 years ago |
| use cswiki_p;
select * from page where page_title="Informatika" |
8 years ago |
| use cswiki_p;
select page_id from page where page_title="Informatika" |
8 years ago |
| use cswiki_p;
select * from pagelinks where pl_from=(select page_id from... |
8 years ago |
| use cswiki_p;
select * from pagelinks where pl_title="Informatika" |
8 years ago |
