ویکیپدیا:واحد ضد خرابکاری/ربات/کوئری ۱
use fawiki_p;
SELECT DISTINCT rev_id
FROM revision JOIN page ON rev_page=page_id
JOIN actor ON rev_actor = actor_id
JOIN comment ON rev_comment_id = comment_id
WHERE actor_name LIKE 'Ahmad252'
AND comment_text LIKE '%خنثیسازی%'
AND comment_text NOT LIKE '%Ahmad252'
AND page_namespace = 0;