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

Category: Retail Index of Articles only

";
id Rvw artid file title description art_title
99[rvw] [art:7] [campaigns/7368815_clarity-first-may-18-2018-92.html] Clarity First, May 18, 2018, #92 The best way to take care of the future Follow a leader
CONTENT
321[rvw] [art:1] [campaigns/9036701_love-work-july-22-2022-308.html] Love & Work, July 22, 2022, #308 The forces of reason, sanity and civilization 'When you fully commit to what you believe in and change your lifestyle to accommodate that vision, the universe starts providing the resources and the energy to keep pursuing that vision.'
CONTENT
327[rvw] [art:5] [campaigns/9047025_love-work-september-2-2022-314.html] Love & Work, September 2, 2022, #314 What is it that really makes us, us? British department store group responds to customers’ demand for more sustainable shopping.
CONTENT
330[rvw] [art:7] [campaigns/9052873_love-work-september-23-2022-317.html] Love & Work, September 23, 2022, #317 aEURoeRock and roll is here to stay.aEUR How grocers and brands can enhance the store to make it a richer and more communal experience for shoppers
CONTENT
344[rvw] [art:6] [campaigns/9083565_love-work-december-30-2022-331.html] Love & Work, December 30, 2022, #331 The horizon leans forward Turning the focus from the buildings that house the shopping to the people who do the shopping
CONTENT
348[rvw] [art:4] [campaigns/9090841_love-work-january-27-2023-335.html] Love & Work, January 27, 2023, #335 Learning to love An in-store sign that made us smile
CONTENT
348[rvw] [art:6] [campaigns/9090841_love-work-january-27-2023-335.html] Love & Work, January 27, 2023, #335 Learning to love An in-store sign that made us smile
CONTENT
368[rvw] [art:1] [campaigns/9140869_love-work-june-16-2023-355.html] Love & Work, June 16, 2023, #355 Think downstream Redefining the architecture of the neighborhood bakery
CONTENT
389[rvw] [art:6] [campaigns/9191566_love-work-november-10-2023-376.html] Love & Work, November 10, 2023, #376 Art is optimistic A bookstore designed to mobilize the literary arts was inspired by the food trucks of LA.
CONTENT