12 Replies Latest reply on Mar 12, 2013 8:15 AM by allison.doherty

    Trying to calculate the people with the most followers


      I have written this query, which returns to me people and their number of followers:

      select objectid, count(*) frrom jiveuserwatches where objecttype = 3 group by objectid order by 2 desc


      But something is off... for example, I have 359 followers (I can see this when I click on my profile)

      But, when I query this in the EAE database (using the query above for my userid), it says I only have 355...


      Does anyone know a different query? Or what this one always seems off by a few?