| select ROW_NUMBER() OVER(order by 'Page title') num, -- get row number
... |
1 year ago |
| select ROW_NUMBER() OVER(order by 'Page title') num, -- get row number
... |
1 year ago |
| select CONCAT('[[', pt_title, ']]') as title -- format as wikilink
from... |
2 years ago |
| select CONCAT('[[', pt_title, ']]') as title -- format as wikilink
from... |
2 years ago |
| select CONCAT('[[', pt_title, ']]') as title -- format as wikilink
from... |
2 years ago |
| select CONCAT('[[', pt_title, ']]') as title -- format as wikilink
from... |
2 years ago |
| select CONCAT('[[', pt_title, ']]') as title -- format as wikilink
from... |
2 years ago |
| select CONCAT('[[', pt_title, ']]') as title
from protected_titles
where... |
2 years ago |
| select *
from protected_titles
where pt_namespace = 0
and pt_create_perm =... |
2 years ago |
| select *
from protected_titles
where pt_namespace = 0
and pt_create_perm =... |
2 years ago |
| select *
from protected_titles
where pt_namespace = 0
and pt_create_perm =... |
2 years ago |
| select *
from protected_titles
where pt_namespace = 0
and pt_create_perm =... |
2 years ago |
| select *
from protected_titles
where pt_namespace = 0
limit 1; |
2 years ago |
