My pages (enwikisource)

Fork of Vaklidated Pages propety names (enwikisource) by ShakespeareFan00

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

SQL

USE enwikisource_p;
SELECT  ##p.page_id, 
SUBSTRING_INDEX(p.page_title,'/',1) as page_title
 pp1.pp_value, r.rev_id, 
 ## r.rev_comment_id, ## c.comment_id, 
c.comment_text 
FROM revision r 
JOIN page p ON r.rev_page=p.page_id
JOIN page_props pp1 ON pp1.pp_page=p.page_id 
JOIN comment c ON c.comment_id=r.rev_comment_id
## JOIN revision_comment_temp rc ON r.rev_id = rc.revcomment_rev

WHERE pp1.pp_propname='proofread_page_quality_level' 
AND rev_user_text IN ('Sfan00 IMG','ShakespeareFan00')
AND r.rev_id<7408348
AND c.comment_id NOT IN (2, 539, 11, 701829, 632, 564, 1063, 654151, 1110322 )
AND page_title NOT IN ('Zodiac_stories_by_Blanche_Mary_Channing.pdf')
AND pp_value=4
ORDER BY page_title ASC, page_id ASC, rev_id ASC

SQL

Checking query status...