USE enwiki_p;

SELECT count(*)

FROM page

JOIN templatelinks

ON page_id=tl_from

WHERE tl_title IN ('SuggestBot/userbox', 'SuggestBot/config') -- SuggestBot's templates

AND tl_namespace = 2 -- Both templates are in user-space

AND page_namespace IN (2, 3) -- Links from either User or User talk.

AND page_title NOT LIKE 'SuggestBot%' -- Nothing in SuggestBot's own user space

AND page_title NOT LIKE '%Archive%' -- Skip archives

AND page_len > 250000 -- Above limit

​

​

​

​