SQL
AخA
SELECT
#page_title as চিত্রের_নাম,
cl_to,
sum(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 in ("Behar_Herald")
AND page_namespace = 6
AND img_minor_mime='pdf'
#limit 5;
group by cl_to
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.