Wikidata female description for male persons

Next to quite some false positives (and a lot of simply suboptimal descriptions), this lists many items with plain wrong descriptions or wrong (often vandalized) gender values

Expensive query; tends to time out

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 '%female%' OR term_text LIKE '%actress%' 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_language = 'de' AND (term_text LIKE '%terin' OR term_text LIKE '%lerin' OR term_text LIKE '%merin' OR term_text LIKE '%gerin')))
            
        #ignored: queen (drag queen, etc.), aunt (haunted, Taunton, etc.)
            
        AND epp_page_id IN (
            SELECT pl_from
                FROM pagelinks
                WHERE pl_from_namespace = 0
                    AND pl_namespace = 0
                    AND pl_title = 'Q6581097'
            )
    GROUP BY term_language, term_text

SQL

Checking query status...