Number of it.wiki pages with external links to Treccani

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

Just for the sake of curiosity with this query you discover how much pages are citing Treccani as source.

I've done this research just to discover how much "thanks" Treccani should give to Wikipedia while the community is improving their pagerank and visibility :)
Also some credits to iopensa who has lot of ideas about how to invest my spare time. asd

Documentation:
https://www.mediawiki.org/wiki/Manual:Externallinks_table

SQL

USE itwiki_p;

SELECT COUNT(*) FROM (
  SELECT * FROM externallinks
  WHERE el_index
  LIKE
  	 'https://it.treccani.%'
  OR 'http://it.treccani.%'
  GROUP BY el_from) pages;

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.

SQL

Checking query status...