Query Run
select ROW_NUMBER() OVER(order by pt_namespace asc, pt_title asc) num, --... 1 year ago
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 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 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 ROW_NUMBER() OVER(order by title) num, -- get row number ... 1 year ago
select CONCAT('# [[', case when pt_namespace = 2303 then 'Gadget definition... 1 year ago
select CONCAT('# [[', case when pt_namespace = 2303 then 'Gadget definition... 1 year ago
select CONCAT('# [[', case when pt_namespace = 2303 then 'Gadget definition... 1 year ago
select CONCAT('# [[', case when page_namespace = 2303 then 'Gadget... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', pt_title,... 1 year ago
select case when pt_namespace = 2 then CONCAT('# {{noping|', page_title,... 1 year ago
select case when page_namespace = 2 then CONCAT('# {{noping|', page_title,... 1 year ago
select CONCAT('[[', pt_title, ']]') as title -- format as wikilink from... 1 year ago