select page_title, count(distinct cl_to) as n_categories
from categorylinks... |
2 years ago |
select page_title from categorylinks join page on cl_from = page_id where... |
2 years ago |
select page_title from categorylinks join page on cl_from = page_id where... |
2 years ago |
select page_title from categorylinks join page on cl_from = page_id order by... |
2 years ago |
select cl_from from categorylinks order by count(distinct cl_to) desc limit 1; |
2 years ago |
select * from logging where log_type='upload' and log_title like 'File:%' limit 2; |
2 years ago |
select * from logging where log_type='upload' and log_title like 'File:%' limit 10; |
2 years ago |
select * from logging where log_type='upload' limit 10; |
2 years ago |
select * from logging limit 10; |
2 years ago |
show table logging; |
2 years ago |
select distinct gil_wiki from globalimagelinks order by gil_wiki; |
2 years ago |
select distinct gil_wiki from globalimagelinks; |
2 years ago |
select
page_title
from
categorylinks, page
where cl_to =... |
2 years ago |
select
page_title
from
categorylinks, page
where cl_to =... |
2 years ago |
select
page_title
from
categorylinks, page
where cl_to =... |
2 years ago |
select
*
from
categorylinks, page
where cl_to =... |
2 years ago |
select
*
from
categorylinks
where cl_to =... |
2 years ago |
select
*
from
categorylinks
where cl_to =... |
2 years ago |
select
*
from
categorylinks
where cl_to =... |
2 years ago |
select
*
from
categorylinks
where cl_to =... |
2 years ago |
select
cl_from
from
categorylinks
where cl_to =... |
2 years ago |
select
cl_from
from
categorylinks
where cl_to =... |
2 years ago |
select
cl_from
from
categorylinks
where cl_to =... |
2 years ago |
select
cl_from
from
categorylinks
where cl_to =... |
2 years ago |
select
count(distinct gil_to)
from
globalimagelinks,
page,
... |
2 years ago |
select
count(distinct gil_to)
from
globalimagelinks,
page,
... |
2 years ago |
select
count(distinct gil_to)
from
globalimagelinks,
page,
... |
2 years ago |
select
count(distinct gil_to)
from
globalimagelinks,
page,
... |
2 years ago |
select count(distinct gil_to) from globalimagelinks, image where gil_to =... |
2 years ago |
select gil_wiki, gil_page_namespace, gil_page_title, gil_to from... |
2 years ago |
select gil_wiki, gil_page_namespace, gil_page_title, gil_to from... |
2 years ago |
select gil_wiki, gil_page_namespace, gil_page_title, gil_to from... |
2 years ago |
select * from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select count(*) from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select count(*) from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select * from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select * from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select * from globalimagelinks, image where gil_to = img_name and... |
2 years ago |
select * from globalimagelinks, image where gil_to = img_name limit 100;
|
2 years ago |
select * from globalimagelinks limit 100;
|
2 years ago |
select * from globalimagelinks limit 100;
|
2 years ago |