additional common outlinks

SQL

USE enwiki_p;

SELECT foreign_putin_common.pl_title
FROM
  (SELECT trump_outlinks.pl_title AS pl_title 
  FROM
      (SELECT pl_title FROM pagelinks WHERE pl_namespace = 0 AND pl_from = 52233943 AND pl_from_namespace = 0) AS trump_outlinks,
      (SELECT pl_title FROM pagelinks WHERE pl_namespace = 0 AND pl_from = 32817 AND pl_from_namespace = 0) AS putin_outlinks
  WHERE 
      trump_outlinks.pl_title = putin_outlinks.pl_title) as foreign_putin_common
LEFT JOIN  
	(SELECT trump_outlinks.pl_title AS pl_title 
        FROM
            (SELECT pl_title FROM pagelinks WHERE pl_namespace = 0 AND pl_from = 4848272 AND pl_from_namespace = 0) AS trump_outlinks,
            (SELECT pl_title FROM pagelinks WHERE pl_namespace = 0 AND pl_from = 32817 AND pl_from_namespace = 0) AS putin_outlinks
        WHERE 
            trump_outlinks.pl_title = putin_outlinks.pl_title) as trump_putin_common
ON 
	foreign_putin_common.pl_title  =  trump_putin_common.pl_title
WHERE 
	trump_putin_common.pl_title IS NULL
SQL

Checking query status...
