Untitled query #2359

SQL

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, page
WHERE page_id = rev_page
AND page_namespace = 4
AND page_title = 'VisualEditor/Commenti'
AND rev_timestamp > NOW() - INTERVAL 6 MONTH))
GROUP BY rev_user_text
HAVING COUNT(*) >= 3
ORDER BY COUNT(*) DESC
SQL

Checking query status...
