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

Category: Guerrilla Marketing Index of Articles only

";
id Rvw artid file title description art_title
115[rvw] [art:7] [campaigns/7416947_clarity-first-september-7-2018-108.html] Clarity First, September 7, 2018, #108 We all agree on Aretha. Rather than litigate, this pork products brand got into the slip stream of the brand that copied them. Now both are winning.
CONTENT
117[rvw] [art:2] [campaigns/7417335_clarity-first-september-21-2018-110.html] Clarity First, September 21, 2018, #110 We need to learn as fast as the world changes. 'Customer focused advertising is the future of advertising.'
CONTENT
391[rvw] [art:6] [campaigns/9198685_love-work-november-24-2023-378.html] Love & Work, November 24, 2023, #378 Thankfulness brings alertness How to open doors and build bridges
CONTENT
440[rvw] [art:5] [campaigns/10330985_love-work-august-30-2024-426.html] Love & Work, August 30, 2024, #426 A hell of a lot more interesting life A London illustrator is using his experience in advertising to help freelancers in his neighborhood.
CONTENT