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

Category: Intellectual Property Index of Articles only


";
id Rvw artid file title description art_title
233[rvw] [art:6] [campaigns/7891120_clarity-first-november-27-2020-223.html] Clarity First, November 27, 2020, #223 ThereaEURtms no such thing as a mistake. This year the Dr. Seuss brand made $33 million. How his widow laid the groundwork.
CONTENT
344[rvw] [art:5] [campaigns/9083565_love-work-december-30-2022-331.html] Love & Work, December 30, 2022, #331 The horizon leans forward On January 1, 2023, copyrighted works from 1927 will enter the US public domain.
CONTENT