I think you're looking for the jiveDocVersion table .. each row is related to parent document via the internalDocID column. I think there should only be one published version for each document - check the state column for that version of the document's title.
This is what I was looking for. Thanks!
Here is the query I was trying to make:
select v.title, d.documentID, u.name, c.viewCount from jiveDocVersion v, jiveUser u, jiveDocument d, jiveViewCount c where u.userID = d.userID and v.internalDocID=d.internalDocID and u.email not like '%landesk%' and v.state like '%published%' and c.objectType=102 and c.objectID=d.internalDocID order by c.viewCount DESC