تقدم نمو مقالة 3

SQL

use arwiki_p;
SELECT /*SLOW OK */ CONCAT('{{مستخدم:FShbib/قوالب/تقدم نمو مقالة|',page_title,'|'), CONCAT('',rev_len,'}}')
FROM revision
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
    AND rev_user_text like ucase ("%JarBot") collate utf8_general_ci
    #AND rev_timestamp BETWEEN "20190101000000" AND "20190601000000"
    #AND page_title REGEXP '^أ.*$'
    #and page_id in (select cl_from from categorylinks  where cl_to REGEXP 'بذرة_ممثل_(.*)' ) 
    and page_id in (select cl_from from categorylinks  where cl_to Like 'بذرة_ممثل_أمريكي' ) 
    AND rev_parent_id = 0
    AND page.page_is_redirect = 0
ORDER BY page_title
#LIMIT 100
;
SQL

Checking query status...
