I was playing around with the SQL queries tonight trying to figure out who wrote some content that was liked, but my numbers just aren't matching up. Has anyone run a similar query? Can anyone verify that at least I'm thinking about this the right way?
I find the content that was liked in the jivedw_acclaim table.
The object_id in jivedw_acclaim corresponds with the content_id value in jivedw_content.
The jivedw_content table gives me a user_id for each piece of content, and I can then grab the user_id from jivedw_user.
Therefore, if I pull the data below, I should be able to get it to line up, right? I could filter by acclaim_type and creation_ts to limit it to just likes in a particular month.
jivedw_acclaim.object_id = jivedw_content.content_id AND