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",
                                                         "BaseBot", "AKBot", "VladimirPF-Bot", "ButkoBot",
                                                         "タチコマ robot", "TheStoneBot", "Mjbmrbot", "PBot",
                                                         "GrondinBot", "JAnDbot", "KrBot", "Glavkos bot",
                                                          "VolkovBot", "Diego Grez Bot", "CommonsDelinker",
                                                          "BetaBot", "AvocatoBot", "ArtushakBot", "Alexbot",
                                                          "AkishinBot")
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
) IN ("NewsBots") 
AND count(actor_name) = 0
GROUP BY page_title
SQL

Checking query status...
