Untitled query #54333

SQL

# ID 41345117 and above use Like, all below use equal

/*
SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params LIKE '%"AAA"%'
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params LIKE '%"MediaWiki talk:ADFDsdfBVCGA"%' AND log_id < 94961978
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params LIKE '%"AAA"%' AND log_id < 94961938
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params LIKE '%"File talk:Aafgdh45wg364"%' AND log_id < 94961932
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params = 'AAA' AND log_id < 94961917
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params = 'Talk:AAAAA' AND log_id < 7933675
ORDER BY log_id DESC
LIMIT 1;

SELECT log_timestamp, log_title, log_actor, log_namespace, log_id FROM logging
WHERE log_type = 'move' AND log_params = 'AAA' AND log_id < 7933160
ORDER BY log_id DESC
LIMIT 1;
*/

SELECT /* IndexPager::buildQueryInfo (LogPager)  */ /*! STRAIGHT_JOIN */ log_id,
log_type,
log_action,
log_timestamp,
log_namespace,
log_title,
log_params,
log_deleted,
user_id,
user_name,
user_editcount,
log_actor,
logging_actor.actor_user         AS `log_user`,
logging_actor.actor_name         AS `log_user_text`,
comment_log_comment.comment_text AS `log_comment_text`,
comment_log_comment.comment_data AS `log_comment_data`,
comment_log_comment.comment_id   AS `log_comment_cid`,
(SELECT Group_concat(ctd_name SEPARATOR ',')
 FROM   `change_tag`
        JOIN `change_tag_def`
          ON (( ct_tag_id = ctd_id ))
 WHERE  ct_log_id = log_id)      AS `ts_tags`
FROM   `logging`
       JOIN `actor` `logging_actor`
         ON (( actor_id = log_actor ))
       LEFT JOIN `user`
              ON (( user_id = logging_actor.actor_user ))
       JOIN `comment` `comment_log_comment`
         ON (( comment_log_comment.comment_id = log_comment_id ))
WHERE  log_type = 'move'
       AND log_namespace = 0
       AND log_title = 'Main_Page'
ORDER  BY log_timestamp DESC
LIMIT  51
SQL

Checking query status...
