"-im" in user warning templates

SQL

SELECT page_title, page_is_redirect
FROM page
WHERE
  page_namespace = 10
  AND page_title LIKE "%im"
/* This will only work if the above is efficient. I suspect it may not be. */
/* USE enwiki_p;
SELECT
  rev_timestamp,
  page_title,
  page_is_redirect
FROM revision
INNER JOIN page ON page_id = rev_page
WHERE
  page_namespace = 10
  AND NOT page_is_redirect
  AND page_title LIKE "%im"
ORDER BY rev_timestamp ASC
*/

AخA
 
SELECT page_title, page_is_redirectFROM pageWHERE  page_namespace = 10  AND page_title LIKE "%im"/* This will only work if the above is efficient. I suspect it may not be. *//* USE enwiki_p;SELECT  rev_timestamp,  page_title,  page_is_redirectFROM revisionINNER JOIN page ON page_id = rev_pageWHERE  page_namespace = 10  AND NOT page_is_redirect  AND page_title LIKE "%im"ORDER BY rev_timestamp ASC*/

SQL

Checking query status...