Untitled query #67111

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q", epp_entity_id) AS item, term_language, term_text
    FROM wb_terms
    JOIN wb_entity_per_page
        ON term_entity_id = epp_entity_id
    WHERE term_type = 'label'
        AND term_entity_type = 'item'
        AND epp_entity_type= 'item'
        AND term_language = 'ar'
        AND term_text NOT LIKE 'قالب:%'    #
                                        #OR term_text LIKE 'sister%' OR term_text LIKE '%countess%' OR term_text LIKE '%woman%' OR term_text LIKE '%empress%' OR term_text LIKE '%mother%' OR term_text LIKE '%goddess%' OR term_text LIKE 'wife%' OR term_text LIKE '%murderess%' OR term_text LIKE '%princess%' OR term_text LIKE '%daughter%' OR term_text LIKE '%queen%') AND (term_text NOT LIKE '%impersonator%' AND term_text NOT LIKE '%drag%'
        #	OR (term_language = 'de' AND (term_text LIKE '%terin' OR term_text LIKE '%lerin' OR term_text LIKE '%merin' OR term_text LIKE '%gerin')))
        #ignored: aunt (haunted, Taunton, etc.)
        AND epp_entity_id IN ( SELECT pl_from FROM pagelinks
                            WHERE pl_from_namespace = 0 
                            AND pl_namespace = 0  
                            AND pl_title = 'Q11266439'  
                            and epp_entity_id =pl_from )
     #   AND epp_entity_id NOT IN ( SELECT pl_from FROM pagelinks WHERE pl_from_namespace = 0  AND pl_namespace = 0  AND pl_title = 'Q6581072'  )
        GROUP BY term_language, term_text
        Limit 100
SQL

Checking query status...
