SQL
AخA
USE fawiki_p;
SELECT count (1)
FROM (select rev_id,rev_page,rev_actor,rev_comment_id from revision where rev_timestamp > NOW() - INTERVAL 6 MONTH) R JOIN page ON R.rev_page=page_id AND page_namespace = 0
JOIN actor ON R.rev_actor = actor_id and actor_name NOT LIKE 'Yamaha5'
JOIN comment ON R.rev_comment_id = comment_id and
comment_text LIKE '%خنثی•سازی%' and comment_text LIKE '%Yamaha5%'
group by R.rev_id;
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.