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