Pages in some books on bnwikisource by length

This query, as written, only lists those pages marked 'not proofread'. (Tackle the easy stuff first before moving on to longer pages!)

SQL

use bnwikisource_p;

select current_date;

select concat("পাতা:", page_title), page_len
from page
join categorylinks
on cl_from = page_id
where cl_to = replace("মুদ্রণ সংশোধন করা হয়নি", ' ', '_')
and page_namespace = 104
and (page_title like replace('Vanga Sahitya Parichaya Part 1.djvu%',' ','_') or page_title like replace('বঙ্গ-সাহিত্য-পরিচয় (দ্বিতীয় খণ্ড).djvu%',' ','_'))
group by page_title, page_len
order by page_len;

SQL

Checking query status...