| use ruwiki_p;
select replace(page_title, '_', ' ') as статья, replace(cl_to,... |
6 years ago |
| use ruwiki_p;
select replace(page_title, '_', ' ') as статья, replace(cl_to,... |
6 years ago |
| use ruwiki_p;
select page_title as статья, cl_to as метакатегория from page... |
6 years ago |
| use ruwiki_p;
select * from page p join categorylinks
on page_id =... |
6 years ago |
| use ruwiki_p;
select * from page p join categorylinks
on page_id =... |
6 years ago |
| use ruwiki_p;
select * from page p join categorylinks
on page_id =... |
6 years ago |
| use ruwiki_p;
select * from page join categorylinks
on page_id =... |
6 years ago |
| use enwiki_p;
select count(*) from page
where page_namespace = 0
and not... |
6 years ago |
| use ruwiki_p;
select count(distinct(cl_to)) from categorylinks
where not... |
6 years ago |
| use ruwiki_p;
select count(*) from categorylinks
where not exists
(select *... |
6 years ago |
| use ruwiki_p;
select * from categorylinks
where exists
(select * from page
... |
6 years ago |
| use ruwiki_p;
select * from categorylinks
where not exists
(select * from... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_title =... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_title =... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_title =... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_title =... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_title =... |
6 years ago |
| use ruwiki_p;
select count(*) from templatelinks
where tl_to =... |
6 years ago |
| use hewiki_p;
select page_title from categorylinks join page
on page_id =... |
6 years ago |
| use hewiki_p;
select * from categorylinks join page
on page_id =... |
6 years ago |
| use hewiki_p;
select * from categorylinks
where cl_to = "כדורגלני_מונדיאל_2018"
|
6 years ago |
| use hewiki_p;
select * from categorylinks
where cl_to = "כדורגלני מונדיאל 2018"
|
6 years ago |
| use hewiki_p;
select page_title from page
where page_title like '%ל"ה%'
and... |
7 years ago |
| use hewiki_p;
select * from page
where page_title like '%ל"ה%'
and... |
7 years ago |
| use hewiki_p;
select * from page
where page_title like '%ל"ה%'
|
7 years ago |
| use hewiki_p;
select * from page
where page_title like 'ל"ה'
|
7 years ago |
| use hewiki_p;
select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title... |
8 years ago |
| use hewiki_p;
select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title... |
8 years ago |
| use hewiki_p;
select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title... |
8 years ago |
| use hewiki_p;
select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title... |
8 years ago |
| use hewiki_p;
select page_namespace, count(page_title) from page
group by... |
8 years ago |
| use hewiki_p;
select page_title, pl_title from page join pagelinks
on... |
8 years ago |
| use hewiki_p;
select page_title, pl_title from page join pagelinks
on... |
8 years ago |
| use hewiki_p;
select * from page join pagelinks
on pl_from = page_id
where... |
8 years ago |
| use hewiki_p;
select count(*) from page join pagelinks
on pl_from =... |
8 years ago |
| use hewiki_p;
select count(*) from page join pagelinks
on pl_from =... |
8 years ago |
| use hewiki_p;
select distinct(pl_namespace) from page join pagelinks
on... |
8 years ago |
| use hewiki_p;
select * from page join pagelinks
on pl_from = page_id
where... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 8
limit 10
|
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
and not... |
8 years ago |
| use hewiki_p;
select * from page
where page_title like "%.js"
|
8 years ago |
| use hewiki_p;
select concat('קטגוריה:', page_title) from page
where... |
8 years ago |
| use hewiki_p;
select concat('קטגוריה:', page_title) from page
where... |
8 years ago |
| use hewiki_p;
select concat('קטגוריה:', page_title) from page
where... |
8 years ago |
| use hewiki_p;
select * from page
where exists
(select * from templatelinks
... |
8 years ago |
| use hewiki_p;
select * from page
where exists
(select * from templatelinks
... |
8 years ago |
| use hewiki_p;
select * from templatelinks
where tl_title = "קטגוריית_רמה"
|
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 10000000
order by... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 10000000
order by... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 2000000
order by rev_id... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 19900000
order by... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 19000000
order by... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id >= 1000000
order by rev_id... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_id > 4999
order by rev_id limit 10
|
8 years ago |
| use hewiki_p;
select * from revision
where rev_id > 999
order by rev_id limit 10
|
8 years ago |
| use hewiki_p;
select * from revision
when rev_id > 999
order by rev_id limit 10
|
8 years ago |
| use hewiki_p;
select * from revision order by rev_id limit 10
|
8 years ago |
| use hewiki_p;
select * from revision limit 10
|
8 years ago |
| use hewiki_p;
select distinct(cl_to) from categorylinks
where cl_to like... |
8 years ago |
| use hewiki_p;
select distinct(cl_to) from categorylinkדs
where cl_to like... |
8 years ago |
| use hewiki_p;
select distinct(cl_to) from categorylink
where cl_to like... |
8 years ago |
| use hewiki_p;
select distinct(cl_to) from categorylink
where cl_to like... |
8 years ago |
| use hewiki_p;
select * from revision_userindex
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision_userindex
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision_userindex
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision_userindex
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision_userindex
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision_user_index
where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision
#where rev_user_text = "Bikoret"
limit... |
8 years ago |
| use hewiki_p;
select * from revision
#where rev_user_text = "Bikoret"
limit 10
|
8 years ago |
| use hewiki_p;
select * from revision
#where rev_user_text = "Bikoret"
limit 10
|
8 years ago |
| use hewiki_p;
select * from user_revision
#where rev_user_text =... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_user_text = "Bikoret" limit 10
|
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where (rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_comment like "% #%"
or... |
8 years ago |
| use hewiki_p;
select * from revision
where rev_comment like "%#%"
limit 10
|
8 years ago |
| use hewiki_p;
select * from revision
where rev_comment like "%a%"
limit 10
|
8 years ago |
| use hewiki_p;
select * from revision limit 1
|
8 years ago |
| use hewiki_p;
select * from revision limit 1
|
8 years ago |
| use hewiki_p;
select * from revisions limit 1
|
8 years ago |
| use hewiki_p;
select * from langlinks
|
9 years ago |
| use hewiki_p;
select * from interwiki
|
9 years ago |
| select * from hewiki_p.interwiki
|
9 years ago |
