USE itwiki_p;

SELECT CONCAT('*{{target | page = Discussioni utente:', rev_user_text, ' | site = it.wikipedia.org}}')

FROM page, revision

WHERE page_id = rev_page

AND page_namespace = 4

AND page_title = 'VisualEditor/Commenti'

AND rev_user_text IN

(SELECT user_name

FROM user

WHERE user_id NOT IN

(SELECT ug_user

FROM user_groups

WHERE ug_group = 'bot')

AND user_id IN

(SELECT rev_user

FROM revision

WHERE rev_timestamp > 20150101000000)

AND user_id NOT IN

(SELECT ipb_user

FROM ipblocks

WHERE (ipb_expiry = 'infinite' OR ipb_expiry > NOW())

AND ipb_user <> 0)

GROUP BY rev_user_text

HAVING COUNT(*) >= 3

ORDER BY COUNT(*) DESC