উইকি লাভস মনুমেন্টস স্বতন্ত্র অংশগ্রহণকারী বাংলাদেশ

SQL

SELECT actor_name, count(*) AS uploads
FROM commonswiki_p.page p 
INNER JOIN commonswiki_p.categorylinks cl ON p.page_id = cl.cl_from 
INNER JOIN commonswiki_p.revision r ON p.page_id = r.rev_page
join actor on rev_actor = actor_id and actor_user is not null
WHERE cl.cl_to IN (
  "Images_from_Wiki_Loves_Monuments_2023_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2022_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2020_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2019_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2018_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2017_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2016_in_Bangladesh"
 ,"Images_from_Wiki_Loves_Monuments_2015_in_Bangladesh"
)
AND p.page_namespace = 6 
AND r.rev_parent_id = 0
GROUP BY actor_name
ORDER BY uploads DESC;

SQL

Checking query status...