Untitled query #88860

SQL

SELECT DISTINCT 
  CONCAT('https://www.wikidata.org/wiki/', term_entity_id) AS wikidata_item,
  term_text AS author_name
FROM 
  wikidatawiki_p.wb_terms
JOIN 
  wikidatawiki_p.wb_items_per_site ON term_entity_id = ips_item_id
WHERE 
  term_type = 'label' AND
  term_language = 'ta' AND
  term_entity_id IN (
    SELECT DISTINCT property_value
    FROM (
      SELECT 
        cl_entity_id AS property_value
      FROM 
        wikidatawiki_p.claims
      WHERE 
        cl_property = 'P570' AND  -- Date of death property
        YEAR(FROM_UNIXTIME(cl_value)) = 1965
    ) AS subquery
  )
  AND ips_site_id = 'tawiki';
SQL

Checking query status...
