Common participants wlebd 24 & 25

SQL

SELECT 
  A.actor_name, 
  COUNT(DISTINCT I.img_name) AS total_files
FROM commonswiki_p.image I
JOIN commonswiki_p.page P ON I.img_name = P.page_title
JOIN commonswiki_p.categorylinks CL ON P.page_id = CL.cl_from
JOIN commonswiki_p.actor A ON I.img_actor = A.actor_id
WHERE P.page_namespace = 6
  AND CL.cl_to IN (
    'Images_from_Wiki_Loves_Earth_2024_in_Bangladesh',
    'Images_from_Wiki_Loves_Earth_2025_in_Bangladesh'
  )
GROUP BY A.actor_name
HAVING COUNT(DISTINCT CL.cl_to) = 2
ORDER BY total_files DESC;

​x
 
SELECT   A.actor_name,   COUNT(DISTINCT I.img_name) AS total_filesFROM commonswiki_p.image IJOIN commonswiki_p.page P ON I.img_name = P.page_titleJOIN commonswiki_p.categorylinks CL ON P.page_id = CL.cl_fromJOIN commonswiki_p.actor A ON I.img_actor = A.actor_idWHERE P.page_namespace = 6  AND CL.cl_to IN (    'Images_from_Wiki_Loves_Earth_2024_in_Bangladesh',    'Images_from_Wiki_Loves_Earth_2025_in_Bangladesh'  )GROUP BY A.actor_nameHAVING COUNT(DISTINCT CL.cl_to) = 2ORDER BY total_files DESC;​

SQL

Checking query status...