postgresql - Jive 5.0 Current Profile Image -

I am currently trying to export profile images from live 5.0 databases. Pulls my PostgreSQL query that picture I but I'm having difficulty in determining whether the currently chosen went image of the profile

  SELECT * U jiveuser left waiting When jiveusercontainer include u.userid = c.userid left on c left are jivecontent ct.containerid = c.usercontainerid whistles joined jiveattachment ja on ja.objectid = ct. Content Where ct.contenttype = 501 and ja.objecttype = 501 and u.userid (4794) and filename = 'profile_image_500.png' ja.modificationdate desc  order 

Anyone Know where is this information stored in the organism database?

This will pull the current profile, which I believe he is the query image:

< pre> select ja.attachmentid, c.displayname, ja.creationdate, ja.filename, (jivecontentprop select propvalue from jcpi where jcpi.contentid = ct.contentid and propname = 'index') U left the jiveuser Join jiveusercontainer c u.userid = c.userid where lEFT JOIN TID being left ct.containerid = c.usercontainerid whistle on jivecontent include jiveattachment ja on ja.objec = ct.contentid ct.contenttype = 501 And ja.objecttype = 501 and u.userid (4794) and in Order 1

from the name l = name 'profile_image_500.png' propvalue