SELECT

    p.page_id,

    p.page_title,

    p.page_len,

    p.page_touched,

    p.page_is_redirect,

    p.page_latest,

    p.page_content_model,

    p.page_links_updated,

    a.actor_user AS last_updated_user_id,

    a.actor_name AS last_updated_user_name,

    ac.actor_user AS created_user_id,

    ac.actor_name AS created_user_name

FROM

    categorylinks AS cl

    JOIN page AS p ON cl.cl_from = p.page_id

    JOIN revision AS r ON p.page_latest = r.rev_id

    JOIN actor AS a ON r.rev_actor = a.actor_id

    JOIN revision AS rc ON p.page_id = rc.rev_page

    JOIN actor AS ac ON rc.rev_actor = ac.actor_id

    LEFT JOIN langlinks AS ll ON p.page_id = ll.ll_from AND ll.ll_lang = 'te'

WHERE

    cl.cl_to = 'Rayalaseema'

    AND p.page_namespace = 0

    AND ll.ll_from IS NULL

    AND rc.rev_timestamp = (SELECT MIN(rev_timestamp) 

                            FROM revision 

                            WHERE rev_page = p.page_id);