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 = 'Color') and (art.category = 'Color') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Color Index of Articles only


";
id Rvw artid file title description art_title
122[rvw] [art:5] [campaigns/7438699_clarity-first-october-26-2018-115.html] Clarity First, October 26, 2018, #115 Maybe we're thinking too hard. Let's play instead. Centuries after naturalists used it to define the colors they saw in the natural world, Werner’s Nomenclature of Colours is back.
CONTENT
138[rvw] [art:6] [campaigns/7579863_clarity-first-february-22-2019-131.html] Clarity First, February 22, 2019, #131 Then do that. What does color mean across the world, and what is the history behind these perceptions?
CONTENT
143[rvw] [art:7] [campaigns/7597623_clarity-first-march-22-2019-135.html] Clarity First, March 22, 2019, #135 Conflicting loyalties are deep in our nature A mini master class in design-meets-marketing
CONTENT
173[rvw] [art:6] [campaigns/7673623_clarity-first-october-4-2019-163.html] Clarity First, October 4, 2019 #163 There's a bit of magic in everything... UK paper manufacturer, G.F Smith, has found the world’s most relaxing color.
CONTENT
185[rvw] [art:3] [campaigns/7703259_clarity-first-december-27-2019-175.html] Clarity First, December 27, 2019 #175 Don't look for flaws, look for potential. Could it be pure coincidence or did the Simpsons really predict the Pantone color of the year ten years in or row?
CONTENT
228[rvw] [art:5] [campaigns/7886452_clarity-first-october-23-2020-218.html] Clarity First, October 23, 2020, #218 The future you are dreaming. Oops. It seems that the neutral colors that most of choose for our homes' walls don't make for great workspaces.
CONTENT
239[rvw] [art:7] [campaigns/7896904_clarity-first-january-8-2021-229.html] Clarity First, January 8, 2021, #229 Learn, unlearn and relearn. Necessity as the mother of invention: 'The color that nobody wanted'.
CONTENT
248[rvw] [art:4] [campaigns/7902796_clarity-first-february-26-2021-236.html] Clarity First, February 26, 2021, #236 The beginning of everything Dieter Rams was a brillant colorist, too.
CONTENT
321[rvw] [art:5] [campaigns/9036701_love-work-july-22-2022-308.html] Love & Work, July 22, 2022, #308 The forces of reason, sanity and civilization How an obscure manifesto for 'spiritual synesthesia' sowed the seeds for the US’s 1920s Chromatic Revolution
CONTENT
322[rvw] [art:7] [campaigns/9038345_love-work-july-29-2022-309.html] Love & Work, July 29, 2022, #309 The future is up for grabs. How a teenage chemistry student inadvertently discovered aniline dyes
CONTENT