Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select rev_user_text, oresm_name, avg(oresc_probability) from ( select rev_id, rev_timestamp, rev_user_text, ores_classification.*, oresm_name from ores_classification join ores_model on oresm_id = oresc_model join revision on oresc_rev = rev_id join page on rev_page = page_id where page_title = 'حسن_شماعیزاده' and oresm_name = 'damaging' and page_namespace = 0 and rev_timestamp > '20170610000000' -- order by rev_id desc ) T group by rev_user_text, oresm_name
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