Untitled query #7465

SQL

USE ptwiki_p;
SELECT concat("*https://pt.wikipedia.org/w/index.php?diff=",rev_id) AS link,
       page_title,
       rev_comment,
       rev_user_text,
       rev_timestamp,
       page_len #page_title,
       rev_comment,
       rev_user_text,
       rev_timestamp,
       rev_minor_edit,
       page_len
FROM revision
JOIN page ON rev_page = page_id
AND page_namespace = 0
AND rev_deleted = 0
AND rev_user = 0
WHERE rev_timestamp >= 20160101000000/**/
  AND /*(rev_comment like "%ortografi%" or rev_comment like "%gramatic%"
or rev_comment like "%orectur%" or rev_comment like "%just%")*/rev_comment LIKE "%archive%"
ORDER BY rev_timestamp DESC LIMIT 5
SQL

Checking query status...
