| select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 7) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select substr(cl_sortkey, 1, 7) as block, count(distinct cl_sortkey_prefix)... |
1 year ago |
| select count(distinct cl_sortkey_prefix) from categorylinks
where cl_to =... |
1 year ago |
| select count(distinct cl_sortkey_prefix) from categorylinks
where cl_to =... |
1 year ago |
| select count(distinct cl_sortkey_prefix) from categorylinks
where cl_to =... |
1 year ago |
| select count(distinct cl_sortkey_prefix) from categorylinks
where cl_to =... |
1 year ago |
| select count(distinct cl_sortkey_prefix) from categorylinks
where cl_to =... |
1 year ago |
| select count(*) from globalimagelinks; |
2 years ago |
| select count(*) from globalfileusage; |
2 years ago |
| select * from page where page_namespace=6 and page_title like 'Plik:%' limit 1000; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '/%' limit 1000; |
2 years ago |
| select * from page where page_namespace=6 and page_title like 'File:%' limit 1000; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%\_.jpg' limit 1000; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%\_.jpg' limit 100; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%\_.jpg'; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%\_.jpg' limit 10; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%\_.%' limit 10; |
2 years ago |
| select * from page where page_namespace=6 and page_title like '%_.%' limit 10; |
2 years ago |
| select * from page where page_title like '% .%' limit 10; |
2 years ago |
| select * from page where page_title like '%;%' limit 10; |
2 years ago |
| select page_title from page where page_title like '%;%' limit 10; |
2 years ago |
| select
page_title, img_metadata
from
categorylinks, page, image
where... |
2 years ago |
| select
page_title, json_value(img_metadata, '$.data.Orientation')
from
... |
2 years ago |
| select
page_title, json_value(img_metadata, '$.data.Orientation')
from
... |
2 years ago |
| select
page_title
from
categorylinks, page, image
where cl_to =... |
2 years ago |
| select
page_title
from
categorylinks, page, image
where cl_to =... |
2 years ago |
| select
page_title
from
categorylinks, page, image
where cl_to =... |
2 years ago |
| select
page_title
from
categorylinks, page, image
where cl_to =... |
2 years ago |
| select
page_title
from
categorylinks, page, image
where cl_to =... |
2 years ago |
