Proof-reader pages for a book

SQL

use tawikisource_p;
SELECT distinct page_title, actor_name, page_content_model as count
FROM revision
join page ON page_id = rev_page
join comment on comment_id = rev_comment_id
join actor ON rev_actor = actor_id where 
#rev_comment_id = 10076 
#page_content_model like "%proofread-page%"
#(comment_text like "%மெய்ப்புப் பார்க்கப்பட்டவை%" or comment_text like "%Proofread%")
(comment_text like "%சரிபார்க்கப்பட்டது%" or comment_text like "%Validated%")
and  rev_page IN (select page_id from page where page_title like "வெற்றி_முழக்கம்.pdf%")
#and actor_name = "Booklover kaniyam" 

limit 10;
SQL

Checking query status...
