Untitled query #89066

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,
 afa.actor_name AS duser
FROM image AS img
INNER JOIN actor_image AS ai ON img.img_actor = ai.actor_id
INNER JOIN filearchive_userindex AS fa ON fa_sha1 = img_sha1
INNER JOIN actor_filearchive AS afa ON fa.fa_actor = afa.actor_id
INNER JOIN user ON ai.actor_user = 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...
