Fork of
Untitled query #50876
by Mahir256
This query is marked as a draft
This query has been published
by Mahir256.
SQL
AخA
SELECT
page_title as চিত্রের_নাম,
cast(substr(regexp_substr(img_metadata, '"Pages":"\\d+"'), 10) as signed integer) as পাতার_সংখ্যা
#img_metadata
FROM page
JOIN image
ON page.page_title=image.img_name
JOIN categorylinks
ON categorylinks.cl_from = page.page_id
WHERE cl_to = "Books_in_Bengali"
AND page_namespace = 6
AND img_minor_mime='pdf'
#limit 5;
order by পাতার_সংখ্যা asc;
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.