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 `items`.`_pageID` AS `cargo_backlink_page_id_items`,`people`.`_pageID` AS `cargo_backlink_page_id_people`,`items`.`_pageName` AS `Item`,`type` AS `Type`,`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` `items` LEFT OUTER JOIN `cargo__items__authors` `items__authors` ON ((`items`.`_ID`=`items__authors`.`_rowID`)) RIGHT OUTER JOIN `cargo__people` `people` ON ((`items__authors`.`_value`=`people`.`_pageName`)) WHERE authors__full IS NOT NULL AND ( death_date < NOW()-100 OR death_date IS NULL ) ORDER BY `items`.`_pageID`,`items`.`people__full` _pageID,`items`.`_pageName`,`type`,`items__authors`.`_value` LIMIT 100
