It errors out complaining about the GROUP BY. This query basically makes a change to testimonials that do not have an associated trademarked product topic tag.
a.testimonialID = b.testimonialID
b.topicID = c.topicID
a.title = a.compliantTitle, a.body = a.compliantBody, a.keywords = a.compliantKeywords
a.approved = 'Yes'
and a.compliantTitle is not null
max(c.product) < 'Yes'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘set t.title = t.compliantTitle, t.body = t.compliantBody, t.keywords = t.complia’ at line 11
Good to see you’re still around r937. I haven’t seen you in a while and thought you were no longer with us.
It’s grouped by testimonialID because otherwise it would produce lots of rows for each testimonialID.
Yes, the goal is to update testimonials that do not have a very specific topic assigned to it…one that it identified as a trademarked product. Thousands of testimonials may have the general topic of lemon-oil, but I’m trying to find those that don’t yet have a trademarked product topic like purification-oil.
I’m updating columns from other columns in the same row because I’m basically backing up data before changes are made by one of my editor employees.
I look forward to the wisdom offered in your next reply. Thanks!