SELECT DISTINCT page_title, page_len, CONCAT('https://enwp.org/Draft:', page_title) as URL

FROM page

WHERE page_namespace = 118

  AND page_is_redirect = 0

  AND page_id NOT IN

      (

          SELECT rev_page

          FROM revision_userindex

          WHERE rev_timestamp > (NOW() - INTERVAL 5 MONTH)

            AND rev_actor NOT IN

                (

                    SELECT actor_id

                    FROM actor

                             INNER JOIN user_groups ON (ug_user = actor_user AND

                                                        ug_group = 'bot')

                )

      );