QUERY: SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params, comment_rc_comment.comment_text AS `rc_comment_text`, comment_rc_comment.comment_data AS `rc_comment_data`, comment_rc_comment.comment_id AS `rc_comment_cid`, actor_rc_user.actor_user AS `rc_user`, actor_rc_user.actor_name AS `rc_user_text`, rc_actor, wl_user, wl_notificationtimestamp, page_latest, (SELECT GROUP_CONCAT(ctd_name SEPARATOR ', ') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags`, fp_stable, fp_pending_since, ores_damaging_cls.oresc_probability AS `ores_damaging_score`, ores_goodfaith_cls.oresc_probability AS `ores_goodfaith_score` FROM `recentchanges` JOIN `actor` `actor_rc_user` ON ((actor_rc_user.actor_id = rc_actor)) LEFT JOIN `user` ON ((actor_rc_user.actor_user = user_id)) JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `watchlist` ON (wl_user = REDACTED AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) LEFT JOIN `flaggedpages` ON ((fp_page_id = rc_cur_id)) LEFT JOIN `ores_classification` `ores_damaging_cls` ON (ores_damaging_cls.oresc_model = 37 AND (ores_damaging_cls.oresc_rev=rc_this_oldid) AND ores_damaging_cls.oresc_class = 1) LEFT JOIN `ores_classification` `ores_goodfaith_cls` ON (ores_goodfaith_cls.oresc_model = 38 AND (ores_goodfaith_cls.oresc_rev=rc_this_oldid) AND ores_goodfaith_cls.oresc_class = 1) WHERE ((actor_rc_user.actor_user IS NULL) OR (NOT ( (user_editcount >= 10) AND (user_registration <= '20200220144929') ))) AND rc_bot = 0 AND ((rc_this_oldid = page_latest) OR rc_type = 3) AND (rc_type != 6) AND (rc_source != 'wb') AND (rc_namespace IN ('6', '7')) AND (rc_timestamp >= '20200224144839') AND rc_new IN (0, 1) ORDER BY rc_timestamp DESC LIMIT 500
TRACE: {
"steps": [
{
"join_preparation": {
"select_id": 1,
"steps": [
{
"join_preparation": {
"select_id": 2,
"steps": [
{
"expanded_query": "/* select#2 */ select group_concat(change_tag_def.ctd_name separator ', ') from (change_tag join change_tag_def on(change_tag.ct_tag_id = change_tag_def.ctd_id)) where change_tag.ct_rc_id = recentchanges.rc_id"
}
]
}
},
{
"expanded_query": "/* select#1 */ select recentchanges.rc_id AS rc_id,recentchanges.rc_timestamp AS rc_timestamp,recentchanges.rc_namespace AS rc_namespace,recentchanges.rc_title AS rc_title,recentchanges.rc_minor AS rc_minor,recentchanges.rc_bot AS rc_bot,recentchanges.rc_new AS rc_new,recentchanges.rc_cur_id AS rc_cur_id,recentchanges.rc_this_oldid AS rc_this_oldid,recentchanges.rc_last_oldid AS rc_last_oldid,recentchanges.rc_type AS rc_type,recentchanges.rc_source AS rc_source,recentchanges.rc_patrolled AS rc_patrolled,recentchanges.rc_ip AS rc_ip,recentchanges.rc_old_len AS rc_old_len,recentchanges.rc_new_len AS rc_new_len,recentchanges.rc_deleted AS rc_deleted,recentchanges.rc_logid AS rc_logid,recentchanges.rc_log_type AS rc_log_type,recentchanges.rc_log_action AS rc_log_action,recentchanges.rc_params AS rc_params,comment_rc_comment.comment_text AS rc_comment_text,comment_rc_comment.comment_data AS rc_comment_data,comment_rc_comment.comment_id AS rc_comment_cid,actor_rc_user.actor_user AS rc_user,actor_rc_user.actor_name AS rc_user_text,recentchanges.rc_actor AS rc_actor,watchlist.wl_user AS wl_user,watchlist.wl_notificationtimestamp AS wl_notificationtimestamp,`page`.page_latest AS page_latest,(/* select#2 */ select group_concat(change_tag_def.ctd_name separator ', ') from (change_tag join change_tag_def on(change_tag.ct_tag_id = change_tag_def.ctd_id)) where change_tag.ct_rc_id = recentchanges.rc_id) AS ts_tags,flaggedpages.fp_stable AS fp_stable,flaggedpages.fp_pending_since AS fp_pending_since,ores_damaging_cls.oresc_probability AS ores_damaging_score,ores_goodfaith_cls.oresc_probability AS ores_goodfaith_score from ((((((((recentchanges join actor actor_rc_user on(actor_rc_user.actor_id = recentchanges.rc_actor)) left join `user` on(actor_rc_user.actor_user = `user`.user_id)) join `comment` comment_rc_comment on(comment_rc_comment.comment_id = recentchanges.rc_comment_id)) left join watchlist on(watchlist.wl_user = REDACTED and watchlist.wl_title = recentchanges.rc_title and watchlist.wl_namespace = recentchanges.rc_namespace)) left join `page` on(recentchanges.rc_cur_id = `page`.page_id)) left join flaggedpages on(flaggedpages.fp_page_id = recentchanges.rc_cur_id)) left join ores_classification ores_damaging_cls on(ores_damaging_cls.oresc_model = 37 and ores_damaging_cls.oresc_rev = recentchanges.rc_this_oldid and ores_damaging_cls.oresc_class = 1)) left join ores_classification ores_goodfaith_cls on(ores_goodfaith_cls.oresc_model = 38 and ores_goodfaith_cls.oresc_rev = recentchanges.rc_this_oldid and ores_goodfaith_cls.oresc_class = 1)) where (actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and recentchanges.rc_bot = 0 and (recentchanges.rc_this_oldid = `page`.page_latest or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) order by recentchanges.rc_timestamp desc limit 500"
}
]
}
},
{
"join_optimization": {
"select_id": 1,
"steps": [
{
"condition_processing": {
"condition": "WHERE",
"original_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and recentchanges.rc_bot = 0 and (recentchanges.rc_this_oldid = `page`.page_latest or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and comment_rc_comment.comment_id = recentchanges.rc_comment_id and actor_rc_user.actor_id = recentchanges.rc_actor",
"steps": [
{
"transformation": "equality_propagation",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
},
{
"transformation": "constant_propagation",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
},
{
"transformation": "trivial_condition_removal",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
"original_condition": "recentchanges.rc_bot = 0 and comment_rc_comment.comment_id = recentchanges.rc_comment_id and actor_rc_user.actor_id = recentchanges.rc_actor and (actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (`page`.page_latest = recentchanges.rc_this_oldid or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1)",
"attached_conditions_computation": [],
"attached_conditions_summary": [
{
"table": "recentchanges",
"attached": "recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1)"
},
{
"table": "watchlist",
"attached": null
},
{
"table": "actor_rc_user",
"attached": null
},
{
"table": "user",
"attached": "trigcond(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and trigcond(trigcond(actor_rc_user.actor_user is not null))"
},
{
"table": "page",
"attached": "trigcond(`page`.page_latest = recentchanges.rc_this_oldid or recentchanges.rc_type = 3)"
},
{
"table": "flaggedpages",
"attached": null
},
{
"table": "ores_damaging_cls",
"attached": null
},
{
"table": "ores_goodfaith_cls",
"attached": null
},
{
"table": "comment_rc_comment",
"attached": null
}
]
}
},
{
"join_optimization": {
"select_id": 2,
"steps": [
{
"condition_processing": {
"condition": "WHERE",
"original_condition": "change_tag.ct_rc_id = recentchanges.rc_id and change_tag.ct_tag_id = change_tag_def.ctd_id",
"steps": [
{
"transformation": "equality_propagation",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"
},
{
"transformation": "constant_propagation",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"
},
{
"transformation": "trivial_condition_removal",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"
QUERY: SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params, comment_rc_comment.comment_text AS `rc_comment_text`, comment_rc_comment.comment_data AS `rc_comment_data`, comment_rc_comment.comment_id AS `rc_comment_cid`, actor_rc_user.actor_user AS `rc_user`, actor_rc_user.actor_name AS `rc_user_text`, rc_actor, wl_user, wl_notificationtimestamp, page_latest, (SELECT GROUP_CONCAT(ctd_name SEPARATOR ', ') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags`, fp_stable, fp_pending_since, ores_damaging_cls.oresc_probability AS `ores_damaging_score`, ores_goodfaith_cls.oresc_probability AS `ores_goodfaith_score` FROM `recentchanges` USE INDEX (tmp_3) JOIN `actor` `actor_rc_user` ON ((actor_rc_user.actor_id = rc_actor)) LEFT JOIN `user` ON ((actor_rc_user.actor_user = user_id)) JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `watchlist` ON (wl_user = REDACTED AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) LEFT JOIN `flaggedpages` ON ((fp_page_id = rc_cur_id)) LEFT JOIN `ores_classification` `ores_damaging_cls` ON (ores_damaging_cls.oresc_model = 37 AND (ores_damaging_cls.oresc_rev=rc_this_oldid) AND ores_damaging_cls.oresc_class = 1) LEFT JOIN `ores_classification` `ores_goodfaith_cls` ON (ores_goodfaith_cls.oresc_model = 38 AND (ores_goodfaith_cls.oresc_rev=rc_this_oldid) AND ores_goodfaith_cls.oresc_class = 1) WHERE ((actor_rc_user.actor_user IS NULL) OR (NOT ( (user_editcount >= 10) AND (user_registration <= '20200220144929') ))) AND rc_bot = 0 AND ((rc_this_oldid = page_latest) OR rc_type = 3) AND (rc_type != 6) AND (rc_source != 'wb') AND (rc_namespace IN ('6', '7')) AND (rc_timestamp >= '20200224144839') AND rc_new IN (0, 1) ORDER BY rc_timestamp DESC LIMIT 500
TRACE: {
"steps": [
{
"join_preparation": {
"select_id": 1,
"steps": [
{
"join_preparation": {
"select_id": 2,
"steps": [
{
"expanded_query": "/* select#2 */ select group_concat(change_tag_def.ctd_name separator ', ') from (change_tag join change_tag_def on(change_tag.ct_tag_id = change_tag_def.ctd_id)) where change_tag.ct_rc_id = recentchanges.rc_id"
}
]
}
},
{
"expanded_query": "/* select#1 */ select recentchanges.rc_id AS rc_id,recentchanges.rc_timestamp AS rc_timestamp,recentchanges.rc_namespace AS rc_namespace,recentchanges.rc_title AS rc_title,recentchanges.rc_minor AS rc_minor,recentchanges.rc_bot AS rc_bot,recentchanges.rc_new AS rc_new,recentchanges.rc_cur_id AS rc_cur_id,recentchanges.rc_this_oldid AS rc_this_oldid,recentchanges.rc_last_oldid AS rc_last_oldid,recentchanges.rc_type AS rc_type,recentchanges.rc_source AS rc_source,recentchanges.rc_patrolled AS rc_patrolled,recentchanges.rc_ip AS rc_ip,recentchanges.rc_old_len AS rc_old_len,recentchanges.rc_new_len AS rc_new_len,recentchanges.rc_deleted AS rc_deleted,recentchanges.rc_logid AS rc_logid,recentchanges.rc_log_type AS rc_log_type,recentchanges.rc_log_action AS rc_log_action,recentchanges.rc_params AS rc_params,comment_rc_comment.comment_text AS rc_comment_text,comment_rc_comment.comment_data AS rc_comment_data,comment_rc_comment.comment_id AS rc_comment_cid,actor_rc_user.actor_user AS rc_user,actor_rc_user.actor_name AS rc_user_text,recentchanges.rc_actor AS rc_actor,watchlist.wl_user AS wl_user,watchlist.wl_notificationtimestamp AS wl_notificationtimestamp,`page`.page_latest AS page_latest,(/* select#2 */ select group_concat(change_tag_def.ctd_name separator ', ') from (change_tag join change_tag_def on(change_tag.ct_tag_id = change_tag_def.ctd_id)) where change_tag.ct_rc_id = recentchanges.rc_id) AS ts_tags,flaggedpages.fp_stable AS fp_stable,flaggedpages.fp_pending_since AS fp_pending_since,ores_damaging_cls.oresc_probability AS ores_damaging_score,ores_goodfaith_cls.oresc_probability AS ores_goodfaith_score from ((((((((recentchanges USE INDEX (tmp_3) join actor actor_rc_user on(actor_rc_user.actor_id = recentchanges.rc_actor)) left join `user` on(actor_rc_user.actor_user = `user`.user_id)) join `comment` comment_rc_comment on(comment_rc_comment.comment_id = recentchanges.rc_comment_id)) left join watchlist on(watchlist.wl_user = REDACTED and watchlist.wl_title = recentchanges.rc_title and watchlist.wl_namespace = recentchanges.rc_namespace)) left join `page` on(recentchanges.rc_cur_id = `page`.page_id)) left join flaggedpages on(flaggedpages.fp_page_id = recentchanges.rc_cur_id)) left join ores_classification ores_damaging_cls on(ores_damaging_cls.oresc_model = 37 and ores_damaging_cls.oresc_rev = recentchanges.rc_this_oldid and ores_damaging_cls.oresc_class = 1)) left join ores_classification ores_goodfaith_cls on(ores_goodfaith_cls.oresc_model = 38 and ores_goodfaith_cls.oresc_rev = recentchanges.rc_this_oldid and ores_goodfaith_cls.oresc_class = 1)) where (actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and recentchanges.rc_bot = 0 and (recentchanges.rc_this_oldid = `page`.page_latest or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) order by recentchanges.rc_timestamp desc limit 500"
}
]
}
},
{
"join_optimization": {
"select_id": 1,
"steps": [
{
"condition_processing": {
"condition": "WHERE",
"original_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and recentchanges.rc_bot = 0 and (recentchanges.rc_this_oldid = `page`.page_latest or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and comment_rc_comment.comment_id = recentchanges.rc_comment_id and actor_rc_user.actor_id = recentchanges.rc_actor",
"steps": [
{
"transformation": "equality_propagation",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
},
{
"transformation": "constant_propagation",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
},
{
"transformation": "trivial_condition_removal",
"resulting_condition": "(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (multiple equal(recentchanges.rc_this_oldid, `page`.page_latest) or multiple equal(3, recentchanges.rc_type)) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1) and multiple equal(0, recentchanges.rc_bot) and multiple equal(comment_rc_comment.comment_id, recentchanges.rc_comment_id) and multiple equal(actor_rc_user.actor_id, recentchanges.rc_actor)"
"original_condition": "recentchanges.rc_bot = 0 and comment_rc_comment.comment_id = recentchanges.rc_comment_id and actor_rc_user.actor_id = recentchanges.rc_actor and (actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and (`page`.page_latest = recentchanges.rc_this_oldid or recentchanges.rc_type = 3) and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1)",
"attached": "recentchanges.rc_bot = 0 and recentchanges.rc_type <> 6 and recentchanges.rc_source <> 'wb' and recentchanges.rc_namespace in ('6','7') and recentchanges.rc_timestamp >= '20200224144839' and recentchanges.rc_new in (0,1)"
},
{
"table": "watchlist",
"attached": null
},
{
"table": "actor_rc_user",
"attached": null
},
{
"table": "user",
"attached": "trigcond(actor_rc_user.actor_user is null or `user`.user_editcount < 10 or `user`.user_registration > '20200220144929') and trigcond(trigcond(actor_rc_user.actor_user is not null))"
},
{
"table": "page",
"attached": "trigcond(`page`.page_latest = recentchanges.rc_this_oldid or recentchanges.rc_type = 3)"
},
{
"table": "flaggedpages",
"attached": null
},
{
"table": "ores_damaging_cls",
"attached": null
},
{
"table": "ores_goodfaith_cls",
"attached": null
},
{
"table": "comment_rc_comment",
"attached": null
}
]
}
},
{
"join_optimization": {
"select_id": 2,
"steps": [
{
"condition_processing": {
"condition": "WHERE",
"original_condition": "change_tag.ct_rc_id = recentchanges.rc_id and change_tag.ct_tag_id = change_tag_def.ctd_id",
"steps": [
{
"transformation": "equality_propagation",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"
},
{
"transformation": "constant_propagation",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"
},
{
"transformation": "trivial_condition_removal",
"resulting_condition": "change_tag.ct_rc_id = recentchanges.rc_id and multiple equal(change_tag.ct_tag_id, change_tag_def.ctd_id)"