Numbers of pages in the PDFs of Commons category:Behar Herald

SQL

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;

AخA
 
SELECT  #page_title as চিত্রের_নাম,  cl_to,  sum(cast(substr(regexp_substr(img_metadata, '"Pages":"\\d+"'), 10) as signed integer)) as পাতার_সংখ্যা  #img_metadataFROM pageJOIN imageON page.page_title=image.img_nameJOIN categorylinksON categorylinks.cl_from = page.page_idWHERE cl_to in ("Behar_Herald")AND page_namespace = 6AND img_minor_mime='pdf'#limit 5;group by cl_to order by পাতার_সংখ্যা asc;

SQL

Checking query status...