Fork of
Validated-DeepaArul-என்தமிழ்ப்பணி
by Info-farmer
This query is marked as a draft
This query has been published
by Info-farmer.
SQL
x
use tawikisource_p;
SELECT distinct page_title as Title, actor_name as user, comment_text as comment
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
#(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 = "Fathima kaniyam"
#limit 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.