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

Category: One-on-One Communication Index of Articles only

";
id Rvw artid file title description art_title
127[rvw] [art:2] [campaigns/7454867_clarity-first-november-30-2018-120.html] Clarity First, November 30, 2018, #120 The ultimate inspiration How to listen so people talk.
CONTENT
138[rvw] [art:4] [campaigns/7579863_clarity-first-february-22-2019-131.html] Clarity First, February 22, 2019, #131 Then do that. Humble inquiry. The gentle art of asking and not telling
CONTENT