Replicas browser and optimizer
This query is marked as a draft
This query has been published
use tewiki_p; select concat("వాడుకరి చర్చ:", page_title) as page_title, count(distinct(rev_id)) as edits, count(distinct(actor_name)) as editors, count(distinct(floor(rev_timestamp/1000000))) as days, count(distinct(IF (comment_text LIKE "%usi osio%",rev_id,NULL))) as uusi_osio from page, revision_userindex LEFT JOIN change_tag ON ct_rev_id=rev_id LEFT JOIN change_tag_def ON ct_tag_id=ctd_id, actor_revision LEFT JOIN ipblocks AS ipb2 ON actor_user=ipb_user, user LEFT JOIN ipblocks AS ipb1 ON user_id=ipb_user, comment_revision where rev_comment_id=comment_id and page_title=user_name and page_namespace=3 and page_id=rev_page and actor_id=rev_actor and rev_timestamp> 20200000000000 and user_id!=actor_user and actor_name not regexp "4shadowwBOT|MediaWiki message delivery|UKBot" and (ctd_name IS NULL OR ctd_name NOT IN ("mw-reverted", "mw-undo", "mw-rollback", "mw-manual-revert")) and ipb1.ipb_user IS NULL and ipb2.ipb_user IS NULL group by page_title order by edits desc limit 25;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in