Untitled query #49014

SQL

use arwiki_p;
SELECT concat('تصنيف:',page_title) AS title , el_index

FROM revision
    INNER JOIN page ON rev_page = page_id
    INNER JOIN actor ON rev_actor = actor.actor_id
    INNER JOIN externallinks ON el_from = page_id
    WHERE actor_name = 'Mr.Ibrahembot'
    AND page_namespace = 14
    AND el_index LIKE '%commons.wikimedia.org%'
    AND page_namespace = 14
    AND rev_parent_id = 0
    AND page.page_is_redirect = 0
    #AND rev_timestamp between 20170901000000 and 20201201000000
    AND rev_timestamp > 20170901000000

    AND page_id not IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "en" )
    
    AND page_title not like 'بذرة_%'
    AND page_title not like 'قرى_%'
    
    AND page_id not IN ( select tl_from from templatelinks where tl_title in ( 
	'تصنيف_بذرة', 
	'تحويل_تصنيف'
    )
	)
    LIMIT 100
    ;
SQL

Checking query status...
