Joining classification_results table to other tables support request

[JammyDodger]

@Michael12

And if the target_type is something else, like ‘comment’, then I’d join it to the comments table instead?

I’m not sure comments are processed by AI sentiment. Is this a target_type you’re seeing in your data?

I think it may currently be post only, but with a format that allows it to be expanded to other entities in the future. My data set is limited though, so if you could run this query and see what different types you have that would be very useful:

SELECT target_type
FROM classification_results
GROUP BY 1