Untitled query #15109

SQL

/*USE arwiki_p;
select * #DISTINCT concat("قالب:",page_title) as pagename, count(*) as tot
from page 
where page_namespace = 10          -- count templates
#and page_title like "%/doc"
AND page_is_redirect = 1
and exists ( -- file not already in "Media_missing_infobox_template" or subcategories
          select * 
          from categorylinks
          where 
            cl_from=page_id and 
            cl_to = "تحويلات_قوالب_معطيات_بلد"
         #and   cl_to = "قوالب_تنسيق_ويكيبيديا"
          limit 1 
        )
limit 50;
*/
USE arwiki_p;
SELECT *#CONCAT('# [[User:', page_title, ']]') AS page_title, page_len, user_editcount
FROM page, revision, user
WHERE page.page_id = revision.rev_page
#and page_len > 3000
and revision.rev_user = user.user_id
AND page_namespace = 10 #and page_title not like "%/%"
AND rev_parent_id = 0
AND page_is_redirect = 1
and exists ( -- file not already in "Media_missing_infobox_template" or subcategories
          select * 
          from categorylinks
          where 
            cl_from=page_id and 
            cl_to = "تحويلات_قوالب_معطيات_بلد"
         #and   cl_to = "قوالب_تنسيق_ويكيبيديا"
          limit 1 
        )
#and user_editcount < 51
#and page_id in (select el_from from externallinks)
#and rev_user in (select ipb_user from ipblocks)
ORDER BY page_len desc
limit 50;
SQL

Checking query status...
