USE fawiki_p;

SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')

FROM revision AS r1 JOIN page AS p1 ON r1.rev_page = p1.page_id JOIN actor ON r1.rev_actor = actor_id

WHERE p1.page_namespace = 0

AND p1.page_is_redirect = 0

AND LOWER(actor_name) = "Aryagolparvar"

AND page_title NOT LIKE "%(ابهام•زدایی)"

AND page_title NOT LIKE "موتور%"

AND page_title NOT LIKE "مزرعه%"

AND page_title NOT LIKE "تلمبه%"

​

AND NOT EXISTS (

  SELECT null

  FROM revision AS r2 JOIN page AS p2 ON r2.rev_page = p2.page_id

  WHERE p2.page_namespace = 0

  AND p2.page_is_redirect = 0

  AND p1.page_id = p2.page_id 

  AND r1.rev_timestamp > r2.rev_timestamp

)

ORDER BY page_title;