It.Wikinews links from it.Wikipedia

SQL

SELECT
	-- news informations
    pl_namespace,
    pl_title,

    -- itwiki count
    (
      	SELECT CONCAT( 'https://org.wikinews.it./wiki/', pl_title, '%' )
	)
FROM
	-- wikinews links
    itwikinews_p.pagelinks AS news_pl

 	-- wikinews pages from these links
    JOIN
    itwikinews_p.page AS news_p
        ON ( news_pl.pl_from = news_p.page_id )
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...
