Untitled query #30802

SQL

USE arwiki_p;
SELECT CONCAT("| {{subst:formatnum:", @curRow := @curRow + 1, "}} || [[", REPLACE(page_title, "_", " "), "]]||" ,page_len,"|| [[user:", rev_user_text,"|",rev_user_text, "]]\n|-")
  FROM (SELECT page_title,page_len, l.rev_user_text
          FROM page
          JOIN (SELECT rev_page, rev_user_text
                  FROM revision
              GROUP BY rev_page) l ON l.rev_page = page_id
         WHERE page_id NOT IN (SELECT pl_from FROM pagelinks)
           AND page_namespace = 0
           AND page_is_redirect = 0
        ) p
  JOIN (SELECT @curRow := 0) r ORDER BY page_len DESC;
SQL

Checking query status...
