Pages in some books on enwikisource by length

SQL

use enwikisource_p;

select current_date;

select concat("Page:", page_title), page_len
from page
join page_props
on pp_page = page_id
where pp_propname = 'proofread_page_quality_level'
and pp_value = 1
and page_namespace = 104
and   (page_title like replace('Oxford Book of English Verse 1250-1900.djvu%',' ','_')
    or page_title like replace('Speeches And Writings MKGandhi.djvu%',' ','_')
)
group by page_title, page_len
order by page_len;

​x
 
use enwikisource_p;​select current_date;​select concat("Page:", page_title), page_lenfrom pagejoin page_propson pp_page = page_idwhere pp_propname = 'proofread_page_quality_level'and pp_value = 1and page_namespace = 104and   (page_title like replace('Oxford Book of English Verse 1250-1900.djvu%',' ','_')    or page_title like replace('Speeches And Writings MKGandhi.djvu%',' ','_'))group by page_title, page_lenorder by page_len;

SQL

Checking query status...