Untitled query #73575

SQL

SELECT p1.page_title, count(actor_name) FROM templatelinks
JOIN linktarget ON tl_target_id = lt_id
JOIN page AS p1 ON tl_from = p1.page_id
JOIN revision ON p1.page_id = rev_page
JOIN actor ON rev_actor = actor_id AND actor_name not in ("IluvatarBot", "NewsBots", "InternetArchiveBot")



WHERE lt_title = "NEWSru.com" AND lt_namespace = 10
AND (
  SELECT actor_name FROM page
  JOIN revision ON page_id = rev_page
  JOIN actor ON rev_actor = actor_id
  WHERE page_id = p1.page_id
  ORDER BY rev_timestamp ASC
  LIMIT 1) NOT IN ("IluvatarBot", "NewsBots", "InternetArchiveBot")

  
  

GROUP BY page_title
LIMIT 1000
SQL

Checking query status...
