SELECT CONCAT (

        "[[Draft:"

        ,draft.page_title

        ,"]]"

        ) AS draft

    ,draft.page_len AS draftlength

    ,CONCAT (

        "[["

        ,main.page_title

        ,"]]"

        ) AS mainspace

    ,main.page_len AS mainlength

FROM page AS draft

INNER JOIN page AS main ON draft.page_title = main.page_title

    AND main.page_namespace = 0

WHERE draft.page_namespace = 118

    AND draft.page_is_redirect = 0;