BLP images - Quarry

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', '2015_deaths',
'2014_deaths', '2013_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...
