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;
SQL

Checking query status...
