Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mess
.
Toggle Highlighting
SQL
USE itwiki_p; SELECT CONCAT("# [[", page_title, "]] (", C, ")") FROM (SELECT tl_from, COUNT(*) C FROM templatelinks WHERE tl_namespace = 10 AND tl_title IN ('S', 'Stub', 'W', 'PW', 'Wikificare','A', 'C', 'Da_controllare', 'E', 'T', 'T_sezione', 'P', 'V', 'Bufala', 'L', 'Localismo', 'F', 'Senza_fonti', 'Senzafonti','U', 'Merge', 'Da_unire', 'Correggere', 'Da_correggere', 'Errori_grammaticali', 'NN', 'N', 'Controlcopy', 'Voci_senza_uscita', 'Categorizzare', 'Tmp', 'Manca_template', 'Tradurre', 'O', 'Dividi', 'Chiarire', 'Non_chiaro', 'Da_chiarire', 'D', 'Recentismo', 'Organizzare', 'Finzione', 'Fact', 'Citazione_necessaria', 'Senza fonte', 'CN', 'Sf', 'Cn', 'Citation_needed', 'S_sezione', 'Da_aggiornare') GROUP BY tl_from HAVING C > 3 ORDER BY C DESC) T, page WHERE page_id = tl_from AND page_namespace = 0 AND page_id IN (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND tl_title IN ('O')) ORDER BY C DESC;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...