USE commonswiki_p;

SELECT

    CAST(LEFT(SUBSTR( comment_text, INSTR(comment_text,'(retry ') + 6, LENGTH(comment_text) - INSTR(comment_text,') (batch') - 2), 3) AS INT) AS Tries,

    ROUND(img_size/(1024*1024)) AS Size_MB,

    img_name AS Document

FROM image

JOIN page ON page_title = img_name

JOIN revision_userindex ON page_id=rev_page

JOIN comment_revision AS cr ON cr.comment_id = rev_comment_id

JOIN actor_revision AS ar ON rev_actor = ar.actor_id AND ar.actor_name="Fæ"

JOIN actor_image AS ai ON ai.actor_id = img_actor AND ai.actor_name = "Fæ"

AND img_name LIKE "%\(IA%" ESCAPE "\\"

AND img_timestamp > 20200531000000

AND comment_text LIKE "%\(retry%" ESCAPE "\\"

AND comment_text NOT LIKE "%\(retry 1\)%" ESCAPE "\\"

HAVING Tries > 5

ORDER BY Tries DESC;