Untitled query #26854

SQL

select p1.page_title, p1.page_namespace, linter_cat,
       concat('https://en.wikipedia.org/wiki/', p1.page_title, '?action=parsermigration-edit&lintid=', linter_id) as url,
       linter_params as more_info, linter_id as linter_id, linter_start as start_offset, linter_end as end_offset
from linter
join page p1 on p1.page_id = linter.linter_page and p1.page_namespace in (0, 12, 100, 118) 
join page p2 on p2.page_title=p1.page_title and p2.page_namespace = p1.page_namespace + 1 
join categorylinks on categorylinks.cl_from=p2.page_id and (categorylinks.cl_to='A-Class_video_game_articles' or categorylinks.cl_to='B-Class_video_game_articles' or categorylinks.cl_to='C-Class_video_game_articles' or categorylinks.cl_to='Stub-Class_video_game_articles' or categorylinks.cl_to='Start-Class_video_game_articles' or categorylinks.cl_to='GA-Class_video_game_articles' or categorylinks.cl_to='FA-Class_video_game_articles' or categorylinks.cl_to='Template-Class_video_game_articles' or categorylinks.cl_to='List-Class_video_game_articles' or categorylinks.cl_to='Unassessed-Class_video_game_articles') 
where linter.linter_cat=7 or linter.linter_cat=12 order by linter_cat;
SQL

Checking query status...
