Tamil wikisource - Pages under index with all violet chages

This query is marked as a draft This query has been published by Ranjithsiji.

SQL

SELECT rev.rev_id, p.page_id, p.page_title, ctgd.ctd_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

WHERE
#	p.page_namespace = 104
    p.page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_8.pdf/%"
	AND ctgd.ctd_name = 'proofreadpage-quality2'
ORDER BY
    rev.rev_timestamp DESC
#LIMIT 10

​x
 
SELECT rev.rev_id, p.page_id, p.page_title, ctgd.ctd_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​WHERE#   p.page_namespace = 104    p.page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_8.pdf/%"    AND ctgd.ctd_name = 'proofreadpage-quality2'ORDER BY    rev.rev_timestamp DESC#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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...