use hewiki_p;
select * from categorylinks
where cl_from = 1436339
|
8 years ago |
use hewiki_p;
select * from categorylinks inner join page cat
on... |
8 years ago |
use hewiki_p;
select * from categorylinks inner join page cat
on... |
8 years ago |
use hewiki_p;
select * from categorylinks inner join page cat
on... |
8 years ago |
use hewiki_p;
select distinct(concat('משתמש:',p.page_title)) from... |
8 years ago |
use hewiki_p;
select * from page p
where p.page_namespace=2
and p.page_title... |
8 years ago |
use hewiki_p;
select * from page p
where p.page_namespace=2
and cl_to not... |
8 years ago |
use hewiki_p;
select * from page
where p.page_namespace=2
and cl_to not like... |
8 years ago |
use hewiki_p;
select distinct(concat('משתמש:',p.page_title)) from... |
8 years ago |
use hewiki_p;
select distinct(concat('משתמש:',p.page_title)) from... |
8 years ago |
use hewiki_p;
select distinct(concat('משתמש:',p.page_title)) from... |
8 years ago |
use hewiki_p;
select page_title, tl_title from page join templatelinks
on... |
8 years ago |
use hewiki_p;
select * from page join templatelinks
on page_id =... |
8 years ago |
use hewiki_p;
select * from page join templatelinks
on page_id =... |
8 years ago |
use hewiki_p;
select * from page
where
page_namespace = 0 and (
page_title... |
8 years ago |
use hewiki_p;
select * from page
where
page_namespace = 0 and (
page_title... |
8 years ago |
use hewiki_p;
select * from page
where
page_namespace = 0 and (
page_title... |
8 years ago |
use hewiki_p;
select * from page
where
page_title like "%s%s%" or
page_title... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp '[0-9]+'
and... |
8 years ago |
use hewiki_p;
select * from page
where page_title regexp '[0-9]+'
limit 10
|
8 years ago |
use hewiki_p;
select concat('# [[', page_title, ']]') from page
where... |
8 years ago |
use hewiki_p;
select * from page
where page_namespace = 0
and page_title... |
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 t
where tl_title =... |
8 years ago |
use hewiki_p;
select * from templatelinks
where tl_title = "קטגורית_תחזוקה" |
8 years ago |
use hewiki_p;
select * from templatelinks
where tl_title = "קטגוריית_תחזוקה" |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges
where rc_timestamp like... |
8 years ago |
use hewiki_p;
select * from recentchanges limit 1000
|
8 years ago |
use hewiki_p;
select * from recentchanges order by desc limit 1000
|
8 years ago |
use hewiki_p;
select * from recentchanges order by desc limit 1000
|
8 years ago |
use hewiki_p;
select * from recentchanges limit 1000 order by desc
|
8 years ago |
use hewiki_p;
select * from recentchanges limit 1000
|
8 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select distinct(cl_to) from categorylinks
where not... |
9 years ago |
use hewiki_p;
select * from categorylinks
where not exists
(select * from... |
9 years ago |
use hewiki_p;
select * from categorylinks
where not exists
(select * from... |
9 years ago |
use hewiki_p;
select * from categorylinks
where not exists
(select * from... |
9 years ago |
use hewiki_p;
select * from categorylinks
where not exists
(select * from... |
9 years ago |
use hewiki_p;
select * from logging_logindex
where log_type = "thanks"
order... |
9 years ago |
use hewiki_p;
select * from logging_logindex
where log_type = "thanks"
order... |
9 years ago |
use hewiki_p;
select * from logging_logindex
where log_type = "thanks" limit... |
9 years ago |
use hewiki_p;
select * from logging_logindex
where log_type = "thanks" limit... |
9 years ago |
use hewiki_p;
select * from logging_logindex
where log_type = "thanks" limit 10
|
9 years ago |
use hewiki_p;
select distinct(log_action) from logging_logindex
where... |
9 years ago |
use hewiki_p;
select * from logging
where log_action = "thank" limit 10
|
9 years ago |
use hewiki_p;
select distinct(log_action) from logging |
9 years ago |
use hewiki_p;
select count(*) from wikilove_image_log limit 10 |
9 years ago |
use hewiki_p;
select * from wikilove_image_log limit 10 |
9 years ago |
use hewiki_p;
select * from wikilove_log limit 10 |
9 years ago |
use hewiki_p;
select * from math limit 100 |
9 years ago |
use hewiki_p;
select * from math limit 10 |
9 years ago |
use hewiki_p;
select * from math limit 1 |
9 years ago |
use hewiki_p;
select * from math |
9 years ago |
use hewiki_p;
select * from mark_as_helpful |
9 years ago |
use hewiki_p;
select * from mark_as_helpful limit 1 |
9 years ago |