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 DISTINCT  ##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 r.rev_id=p.page_latest
## AND c.comment_id IN ( 107  )

## 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...