Wikidata male description for female persons

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 = 'description'
        AND term_entity_type = 'item'
        AND epp_entity_type= 'item'
        AND ((term_language = 'en' AND (term_text LIKE '% male %' OR term_text LIKE '%brother%' OR term_text LIKE '%count' OR term_text LIKE 'emperor%' OR term_text LIKE '%father%' OR term_text LIKE '%husband%' OR term_text LIKE '%nephew%' OR term_text LIKE '%prince' OR term_text LIKE '% son %' OR term_text LIKE '%uncle%') AND (term_text NOT LIKE '%her father%' AND term_text NOT LIKE '%her husband%'))
        	OR (term_language = 'de' AND (term_text LIKE '%aler' OR term_text LIKE '%eler' OR term_text LIKE '%stler' OR term_text LIKE '%iker')))
            
        #ignored: man (WOman), god, king (speaking, kingdom, etc.), ...
        #also ignored per e.g. https://www.theguardian.com/theobserver/2011/sep/25/readers-editor-actor-or-actress: actor, murderer, master
            
        AND epp_page_id 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
SQL

Checking query status...
