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

Category: Brand Perception Index of Articles only

";
id Rvw artid file title description art_title
375[rvw] [art:7] [campaigns/9159046_love-work-august-4-2023-362.html] Love & Work, August 4, 2023, #362 The peace of quiet Poll: Patagonia has best brand reputation, ranking first in the Character, Trajectory, Ethics, Citizenship, and Products & Services categories.
CONTENT