| use guwikisource_p;
select *
from categorylinks
join page p ON cl_from =... |
5 years ago |
| use bnwikisource_p;
select *
from categorylinks
join page p ON cl_from =... |
5 years ago |
| use bnwikisource_p;
select cl_from
from categorylinks
join page p ON... |
5 years ago |
| use bnwikisource_p;
select cl_from
from categorylinks
where cl_to =... |
5 years ago |
| use bnwikisource_p;
select count(cl_from)
from categorylinks
where cl_to =... |
5 years ago |
| use bnwikisource_p;
select count(cl_from)
from categorylinks
where cl_to =... |
5 years ago |
| use aswikisource_p;
select count(cl_from)
from categorylinks
where cl_to =... |
5 years ago |
| use aswikisource_p;
select *
from categorylinks
where cl_to = "সূচীৰ_বৈধকৰণ_হৈছে" |
5 years ago |
| use orwikisource_p;
select *
from categorylinks
where cl_to = "সূচীৰ_বৈধকৰণ_হৈছে" |
5 years ago |
| use orwikisource_p;
select count(cl_from)
from categorylinks
where cl_to =... |
5 years ago |
| use orwikisource_p;
select count(cl_from)
from categorylinks
where cl_to =... |
5 years ago |
| use orwikisource_p;
select count(page_title)
from page
where... |
5 years ago |
| use bnwikisource_p;
select count(page_title)
from page
where... |
5 years ago |
| use bnwikisource_p;
select /* SLOW_OK */ count(distinct page_id)
from page... |
5 years ago |
| use bnwikisource_p;
select /* SLOW_OK */ count(distinct tl_from) as num... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as number
from categorylinks... |
5 years ago |
| use bnwikisource_p;
select count(cl_from)
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p
select count(cl_from) as num from categorylinks where... |
5 years ago |
| use bnwikisource_p;
select count(page_title)
from page
where... |
5 years ago |
| use sawikisource_p;
select count(page_title)
from page
where... |
5 years ago |
| use sawikisource_p;
select /* SLOW_OK */ count(distinct page_id)
from page... |
5 years ago |
| use sawikisource_p;
select count(distinct tl_from) as num
from... |
5 years ago |
| use sawikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use sawikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use sawikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(cl_from) as num
from categorylinks
where... |
5 years ago |
| use bnwikisource_p;
select count(page_id) as num
from page
where... |
5 years ago |
| blank query |
5 years ago |
| use bnwiki_p;
select rev_user, count(*)
from revision |
5 years ago |
| use bnwiki_p;
select rev_user, count(*)
from revision
ORDER BY count(*) DESC; |
5 years ago |
| use bnwiki_p;
select rev_user, count(*)
from revisions
ORDER BY count(*) DESC; |
5 years ago |
| use bnwiki_p;
select rev_user, count(*)
ORDER BY count(*) DESC; |
5 years ago |
| use bnwiki_p;
select rev_user, count(*)
ORDER BY DESC; |
5 years ago |
