Untitled query #51487

SQL

use afwiki_p;
-- show tables;
-- select distinct pp_propname from page_props;
select page_title, page_len, actor_name from page as p
join revision_userindex on rev_page = page_id
join actor_revision on rev_actor = actor_id
where
  page_namespace = 0
  and page_is_new = 1
  and page_is_redirect = 0
  and actor_name = "naudefj"
  and page_len > 400 -- bez razdvojbi ?
  order by page_len ASC
limit 100;
SELECT
    p.page_id AS "page_id",
    CAST(p.page_title AS CHAR(10000) CHARACTER SET utf8) AS "page_title",
    r.rev_comment AS "comment"
FROM
    page p
        INNER JOIN revision r
            ON p.page_latest = r.rev_id
LIMIT 100;
SQL

Checking query status...
