Licenses
This page lists items with known authors, where the author died less than 100 years ago (or has an unknown death date).
Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `cargo_backlink_page_id_items`,`cargo__people`.`_pageID` AS `cargo_backlink_page_id_people`,`cargo__items`.`_pageName` AS `Item`,`type` AS `Type`,`cargo__items__authors`.`_value` AS `Authors`,CONCAT(IF(date_precision="circa","c.",""),YEAR(date)) AS `Publication date`,YEAR(death_date) AS `Year of death`,YEAR(death_date)+71 AS `Death + 71` FROM `cargo__items` LEFT OUTER JOIN `cargo__items__authors` ON ((`cargo__items`.`_ID`=`cargo__items__authors`.`_rowID`)) RIGHT OUTER JOIN `cargo__people` ON ((`cargo__items__authors`.`_value`=`cargo__people`.`_pageName`)) WHERE authors__full IS NOT NULL AND ( death_date < NOW()-100 OR death_date IS NULL ) ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`people__full` _pageID,`cargo__items`.`_pageName`,`type`,`cargo__items__authors`.`_value` LIMIT 100
