مضامین بدون داخلی روابط

SQL

SELECT CONCAT("| {{subst:formatnum:", @curRow := @curRow + 1, "}} || [[", REPLACE(page_title, "_", " "), "]]||[http://ur.wikipedia.org/w/index.php?title=",page_title,"&action=history تاریخچہ]|| ",
              page_len,
              "|| [[user:", rev_actor,"|",rev_actor, "]] ([[تبادلۂ خیال صارف:",rev_actor,"|تبادلۂ خیال]])\n|-")  
              FROM (SELECT page_title,page_len, l.rev_actor          
                    FROM page 
                    JOIN (SELECT rev_page, rev_actor
                          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...
