Untitled query #89065

SQL

SELECT
 DATE_FORMAT(img_timestamp, "%b %d %Y %h:%i %p") AS ts,
 REPLACE( img_name ,'_',' ' ) AS img,
 actor_name AS user,
 user_editcount AS uec,
 REPLACE( fa_name ,'_',' ' ) AS dimg,
 second_actor_name AS duser
FROM image
INNER JOIN actor_image
 ON img_actor = actor_id
INNER JOIN (SELECT
             fa_sha1,
             fa_name,
             actor_name AS second_actor_name
            FROM filearchive_userindex
            INNER JOIN actor_filearchive
             ON fa_actor = actor_id
            ) AS deletedfile
ON fa_sha1 = img_sha1
INNER JOIN user ON
 actor_user = user_id
WHERE img_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -60 DAY), '%Y%m%d%H%i%s')
AND user_editcount < 35
ORDER BY img_timestamp, fa_name DESC;
SQL

Checking query status...
