SELECT CASE

        WHEN log_title LIKE '%/%' THEN 'Y'

        ELSE 'N'

        END AS is_subpage,

    CONCAT('[[Portal:', log_title, ']]') AS pagename,

    DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,

    comment_text

FROM logging_userindex

JOIN comment

    ON comment_id = log_comment_id

WHERE log_type = 'delete' AND log_action = 'delete'

    AND log_user = 99037 -- User:Longhair

    AND log_namespace = 100 -- Portal:

    AND EXISTS (SELECT 1

                FROM archive

                WHERE ar_namespace = 100

                    AND ar_title = log_title

                LIMIT 1)

ORDER BY

    is_subpage ASC,

    log_title ASC;