It.Wikinews links from it.Wikipedia

SQL

SELECT
    pl_namespace,
    pl_title, (
		SELECT
			COUNT( * )
		FROM
			itwiki_p.iwlinks AS wiki_iwl
		WHERE
			wiki_iw.iwl_prefix = 'wikinews' AND
			wiki_if.iwl_title LIKE pl_title
	)
FROM
	-- wikinews pages linked from a certain page
    itwikinews_p.pagelinks AS news_pl
    JOIN
    itwikinews_p.page      AS news_p
        ON ( news_pl.pl_from = news_p.page_id )

	-- wikipedia articles linking these pages
WHERE
    -- from https://it.wikinews.org/wiki/Wikinotizie:Concorso_2018/Votazione
    news_p.page_namespace = 4 -- Wikinews:
    AND
    news_p.page_title = "Concorso_2018/Votazione"

    -- just News
    AND
    news_pl.pl_namespace = 0;
SQL

Checking query status...
