This query is marked as a draft This query has been published by Lucarosty.

SQL

x
 
select totale, count(*) as page_count_error, totale * count(*) as weight from (
  select page.page_id, page.page_title, count(*) as totale from linter join page on page.page_id = linter.linter_page
  group by page.page_id, page.page_title) as tmp
group by totale
order by totale desc;
select tmp.*, linter.linter_params, count(*) as ptotale from (
  select page.page_id, page.page_title, page.page_len, linter_cat, page_namespace, count(*) as totale 
  from linter join page on page.page_id = linter.linter_page
  group by page.page_id, page.page_title, page.page_len, linter_cat, page_namespace
  having totale >= 10
  order by totale desc) as tmp join linter on tmp.page_id = linter.linter_page
group by page_id, page_title, totale, linter.linter_params
order by totale desc, tmp.page_len asc, tmp.page_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...