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(*) AS number_of_itwiki_pages_linking_treccani
	FROM (
	  SELECT * FROM externallinks
	  WHERE el_index
	  LIKE
	  	 'https://it.treccani.%'
	  OR 'http://it.treccani.%'
	  GROUP BY el_from
	) AS to_make_mysql_happy

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...