Untitled query #17762

SQL

SELECT
   CONCAT ('[[:File:',
   endeletelog.log_title,
   ']]')      
FROM
   fawiki_p.image as faimage 
inner join
   enwiki_p.image as enimage  
      on  faimage.img_name=enimage.img_name
inner join
(SELECT *
FROM enwiki_p.logging
WHERE enwiki_p.log_type = 'delete'
    AND enwiki_p.log_action = 'delete'
    AND enwiki_p.log_namespace = 6
GROUP BY enwiki_p.log_timestamp) as endeletelog on enimage.img_name in endeletelog.log_title
inner join 
(SELECT *
FROM fawiki_p.logging
WHERE fawiki_p.log_type = 'delete'
    AND fawiki_p.log_action = 'delete'
    AND fawiki_p.log_namespace = 6
GROUP BY fawiki_p.log_timestamp) as fadeletelog where not faimage.img_name = fadeletelog.log_title limit 5;
SQL

Checking query status...
