SQL=SELECT DISTINCT c.id, artid, file, title, description, cat.art_title FROM campaigns as c, catbyid as cat, artbyid as art WHERE (cat.category = 'Biodiversity') and (art.category = 'Biodiversity') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Biodiversity Index of Articles only


";
id Rvw artid file title description art_title
219[rvw] [art:3] [campaigns/7877904_clarity-first-august-21-2020-209.html] Clarity First, August 21, 2020, #209 It's time for a new dream. Poor, urban communities of color are also low on biodiversity, while high on rodents, disease-carrying pests, and temperature.
CONTENT
440[rvw] [art:1] [campaigns/10330985_love-work-august-30-2024-426.html] Love & Work, August 30, 2024, #426 A hell of a lot more interesting life Tiny urban forests are transforming urban landscapes and contributing to the fight against climate change.
CONTENT