أكثر المستخدمين تعديلًا ضمن مقالات مشروع ويكي طب old

SQL

SELECT actor_name, count(*) from revision 
join actor on rev_actor = actor_id 
join page on rev_page = page_id
WHERE lower(cast(actor_name as CHAR)) NOT LIKE '%bot%' AND page_namespace = 0 AND rev_timestamp like '2023%'
and page_title in (SELECT page_title FROM (
  SELECT tl_from, rd_from
  FROM `templatelinks`
  	LEFT JOIN `redirect`
  		ON ((rd_from = tl_from) AND rd_title = 'مشروع_ويكي_طب' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '10')
  	INNER JOIN `page`
  		ON ((tl_from = page_id))
  	JOIN `linktarget`
  		ON ((tl_target_id = lt_id))
  WHERE
  	lt_namespace = '10' AND
  	lt_title = 'مشروع_ويكي_طب'
  ORDER BY tl_from) `temp_backlink_range` INNER JOIN `page` ON ((tl_from = page_id)) 
                   WHERE page_namespace = '1') 
  group by actor_id 
  order by count(*) desc 
  limit 510;

SQL

Checking query status...