SQL
x
use bnwikisource_p;
#describe bnwikisource_p.categorylinks;
SELECT 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/%',' ','_')
group by page_title, page_len
order by page_len;
#LIMIT 500;
#select page_title, page_len
#from page
#where (page_namespace = 104)
# and (page_title like REPLACE('Vanga Sahitya Parichaya Part 1.djvu/%',' ','_'))
#group by page_title, page_len
#order by page_len;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.