Untitled query #78185

SQL

-- Count the number of Wikidata items with gender 'man' and interwiki link to Ukrainian Wikipedia

USE wikidatawiki_p;

SELECT COUNT(DISTINCT pl_title) AS count
FROM (
    SELECT DISTINCT pagelinks.pl_title
    FROM pagelinks
    JOIN page ON page.page_id = pagelinks.pl_from
    WHERE pagelinks.pl_namespace = 0
      AND pagelinks.pl_title = 'Q5' -- Q5 represents human
      AND EXISTS (
        SELECT 1
        FROM langlinks
        WHERE langlinks.ll_from = page.page_id
        AND langlinks.ll_lang = 'uk'
      )
      AND EXISTS (
        SELECT 1
        FROM wb_claims
        WHERE page.page_title = wb_claims.claim_id
        AND wb_claims.property = 'P21' -- Property for gender
        AND wb_claims.value = 'Q6581097' -- Q6581097 represents male gender
      )
) AS subquery;
SQL

Checking query status...
