Untitled query #82505

SQL

USE itwiki_p;

SELECT
    -- number of pages linking Treccani
	(
      SELECT COUNT(*)
      FROM (
        SELECT * FROM externallinks
        WHERE el_index
        LIKE
           -- note: this is actually 'https://treccani.it' but it's reverse indexed
           'https://it.treccani.%'
        OR 'http://it.treccani.%'
        GROUP BY el_from
      ) AS to_make_mysql_happy_this_is_unuseful_asd
    ) AS number_of_pages_linking_treccani,

    -- total links to Treccani
    -- same as above but without GROUP BY el_from
    (
      SELECT COUNT(*)
        FROM (
          SELECT * FROM externallinks
          WHERE el_index
          LIKE
          -- note: this is actually 'https://treccani.it' but it's reverse indexed
             'https://it.treccani.%'
          OR 'http://it.treccani.%'
        ) AS to_make_mysql_happy_this_is_unuseful_asd
    ) AS total_links_to_treccani
SQL

Checking query status...
