User:Jonesey95/Linter errors in Wikipedia space

[News]

test

← Previous revision​	Revision as of 20:42, 29 April 2024​
Line 5:	Line 5:
select page_namespace, page_title, count(*) as page_count	select page_namespace, page_title, count(*) as page_count
from linter	from linter
join page on page.page_id = linter.linter_page and linter_cat != 20 and linter_cat != 22 and page.page_count < 16	join page on page.page_id = linter.linter_page and linter_cat != 20 and linter_cat != 22
where page.page_namespace = 4 and page.page_title LIKE 'Articles_for_d%' and page.page_title NOT LIKE '%Log%'	where page.page_namespace = 4 and page.page_title LIKE 'Articles_for_d%' and page.page_title NOT LIKE '%Log%' and page.page_count < 16
group by page.page_id	group by page.page_id
order by count(*) desc, page_title asc	order by count(*) desc, page_title asc

Okumaya devam et...