test
Okumaya devam et...
← 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...