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

Category: Generations Index of Articles only


";
id Rvw artid file title description art_title
309[rvw] [art:3] [campaigns/9013289_love-work-april-29-296.html] Love & Work, April 29, #296 The best way to predict the future New survey reveals a dramatic distance between the generations in terms of how the young identify with the world around them, their outlook, and in some areas their values.
CONTENT
310[rvw] [art:2] [campaigns/9015097_love-work-may-6-297.html] Love & Work, May 6, #297 Doom scenarios don't work. Generation Z: the first global citizens?
CONTENT