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?
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
jivedw_content.user_id = jivedw_user.user_id;
Any guidance would be much appreciated.