I am trying to get an assessment of the execution plan of this query for fawiki_p database:
SELECT page_title
FROM page
JOIN (
SELECT
rev_page,
COUNT(DISTINCT rev_actor) AS cnt
FROM revision
GROUP BY rev_page
HAVING cnt = 1
) singleauth
ON page_id = rev_page
LEFT JOIN pagelinks
ON pl_title = page_title
AND pl_namespace = 4
AND pl_from <> 1171408
LEFT JOIN templatelinks
ON tl_title = page_title
AND tl_namespace = 4
WHERE
page_namespace = 4
AND page_is_redirect = 0
AND pl_title IS NULL
AND tl_title IS NULLBut the SQL Optimizer tool gives me an error: Query error: Sort aborted: Query execution was interrupted (max_statement_time exceeded)