You can do such queries through the Wikidata Query Service (
https://query.wikidata.org/). For example, if you wanted to get a list of 100 paintings by women that have articles in both the French and English Wikipedias, you would do something like:
SELECT DISTINCT ?painting ?paintingLabel ?artist ?artistLabel ?inception
WHERE
{
?painting wdt:P31 wd:Q3305213 . # find instances of painting
?painting p:P170 ?statement . # with a P170 (creator) statement
?statement ps:P170 ?artist . # ... that has the value ?artist
?artist wdt:P21 wd:Q6581072 . # ... where the ?artist has P21 (sex or gender) female
?article schema:about ?painting .
# Now select the inception value of the ?painting
?painting wdt:P571 ?inception .
FILTER EXISTS { ?wen schema:about ?painting . ?wen schema:inLanguage "en" }
FILTER EXISTS { ?wfr schema:about ?painting . ?wfr schema:inLanguage "fr" }
# Optionally, find English labels for painting and artist:
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 100;