Untitled query #47152

SQL

USE hiwiki_p;
SELECT CONCAT("# [[:File:", hiwiki_p.image.img_name, "]]") AS Wiki_name, 
       CONCAT("[[:File:", commonswiki_p.image.img_name, "]]") AS Commons_name, 
       commonswiki_p.image.img_timestamp AS Com_time,
       hiwiki_p.logging.log_timestamp AS Wiki_log_time,
       hiwiki_p.logging.log_type AS Wiki_log_type
FROM hiwiki_p.image 
JOIN commonswiki_p.image 
    ON commonswiki_p.image.img_sha1 = hiwiki_p.image.img_sha1
LEFT JOIN hiwiki_p.logging 
    ON hiwiki_p.logging.log_title = hiwiki_p.image.img_name
GROUP BY hiwiki_p.image.img_name ASC;
SQL

Checking query status...
