Longest titles in dewiki

SQL

SELECT REPLACE(page_title, '_', ' ') AS 'Longest ns0 page title', CHAR_LENGTH(page_title) AS 'Length'
	FROM page
    WHERE page_namespace = 0
    ORDER BY CHAR_LENGTH(page_title) DESC
    LIMIT 1;

SELECT REPLACE(page_title, '_', ' ') AS 'Longest article title', CHAR_LENGTH(page_title) AS 'Length'
	FROM page
    WHERE page_namespace = 0 AND page_is_redirect = 0
    ORDER BY CHAR_LENGTH(page_title) DESC
    LIMIT 1;

SELECT REPLACE(page_title, '_', ' ') AS 'Longest one-word title', CHAR_LENGTH(page_title) AS 'Length'
	FROM page
    WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_title NOT LIKE '%\\_%'
    ORDER BY CHAR_LENGTH(page_title) DESC
    LIMIT 1;
SQL

Checking query status...
