Pages deleted on some wiki that are linked to frwiki

SQL

SELECT comment.*, recentchanges.*, wb_items_per_site.*
  FROM recentchanges
      JOIN change_tag ON ct_rev_id = recentchanges.rc_this_oldid
      JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id
      JOIN comment on recentchanges.rc_comment_id = comment.comment_id
      JOIN wb_items_per_site ON ips_item_id = REPLACE(recentchanges.rc_title, 'Q', '')

  WHERE rc_namespace = 0
      AND recentchanges.rc_timestamp >= curdate() - interval 4 day
      AND change_tag_def.ctd_name = 'client-automatic-update'
      AND comment.comment_text LIKE '%clientsitelink-remove%'
      AND ips_site_id='frwiki'
LIMIT 10

SQL

Checking query status...