rc_patrolled propagation

SQL

SELECT wd.rc_title, wd.rc_timestamp, wd.rc_patrolled as wd_rc_patrolled, wp.rc_patrolled as wp_rc_patrolled
FROM (
  select rc_title, rc_timestamp, rc_user_text, rc_comment, rc_patrolled 
  from wikidatawiki_p.recentchanges 
  where rc_patrolled=0 and rc_namespace=0 and rc_source="mw.edit" limit 10
) as wd, (
  select pp_value, rc_title,rc_timestamp, rc_user_text, rc_comment, rc_patrolled 
  from enwiki_p.page_props, enwiki_p.recentchanges 
  where pp_propname = "wikibase_item" and pp_page=rc_cur_id and rc_namespace=0 and rc_source="wb"
) as wp 
where wp.pp_value=wd.rc_title and wp.rc_timestamp=wd.rc_timestamp and wp.rc_user_text=wd.rc_user_text;
SQL

Checking query status...
