SELECT rev.rev_id, p.page_id, p.page_title, ctgd.ctd_name, rev.rev_actor, a.actor_name

FROM revision rev

JOIN change_tag ctg ON ctg.ct_rev_id = rev.rev_id

JOIN change_tag_def ctgd ON ctg.ct_tag_id = ctgd.ctd_id

JOIN page p ON rev.rev_page = p.page_id

JOIN actor a ON rev.rev_actor = a.actor_id

WHERE p.page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_10.pdf/%"

  AND ctgd.ctd_name = 'proofreadpage-quality2'

  AND NOT EXISTS (

    SELECT 1

    FROM revision later_rev

    JOIN change_tag later_ctg ON later_ctg.ct_rev_id = later_rev.rev_id

    JOIN change_tag_def later_ctgd ON later_ctg.ct_tag_id = later_ctgd.ctd_id

    WHERE later_rev.rev_page = p.page_id

      AND later_rev.rev_timestamp > rev.rev_timestamp

      AND (later_ctgd.ctd_name = 'proofreadpage-quality3' OR later_ctgd.ctd_name = 'proofreadpage-quality4')

  )

ORDER BY rev.rev_timestamp DESC;