Untitled query #20539

SQL

SELECT
       log_title AS image,
       DATE_FORMAT(log_timestamp, "%Y-%m-%dT%H:%i:%s" ) AS timestamp,
       COUNT(*) AS "numb BLPs",
       IF( abs( img_timestamp - log_timestamp ) < 8, "Current", "Replaced" ) AS top,
       log_comment,
       oi_timestamp
FROM commonswiki_p.logging_logindex
INNER JOIN commonswiki_p.globalimagelinks ON log_title = gil_to AND gil_wiki = 'enwiki'
LEFT OUTER JOIN commonswiki_p.image ON img_name = log_title
INNER JOIN enwiki_p.categorylinks ON gil_page = cl_from
AND enwiki_p.categorylinks.cl_to IN ('Living_people', 'Possibly_living_people', '2016_deaths', '2015_deaths', '2014_deaths')
INNER JOIN commonswiki_p.user ON log_user = user_id AND user_editcount < 1000
LEFT OUTER JOIN enwiki_p.user u2 ON log_user_text = u2.user_name
LEFT OUTER JOIN commonswiki_p.oldimage ON img_name = oi_name
WHERE log_type = 'upload' AND
       log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -8 DAY), "%Y%m%d%H%i%s") AND
       log_action = 'overwrite' AND
       oi_user != img_user AND
       (u2.user_editcount < 2000 OR u2.user_editcount IS NULL) AND
       NOT img_minor_mime = "svg+xml"
GROUP BY log_timestamp, log_title
HAVING oi_timestamp = MIN(oi_timestamp)
ORDER BY log_timestamp DESC, oi_timestamp DESC
LIMIT 1000;
SQL

Checking query status...
