SQL
AخA
use dewiki_p;
SELECT count(*) AS Anzahl, actor_name
FROM page, revision, actor_revision, comment_revision
WHERE page_title LIKE "Löschkandidaten/%"
AND page_namespace = 4
AND page_id = rev_page
AND rev_actor = actor_id
AND comment_id = rev_comment_id
AND comment_text like "Neuer Abschnitt%"
GROUP by actor_name
HAVING Anzahl > 10
ORDER BY Anzahl DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.