select p.pname, ub.username, ps.propertyvalue from userbase ub,propertyentry pe, propertystring ps, project pwhere ub.id=pe.entity_id and pe.property_key=’email’ and ps.id=pe.id and p.lead=ub.username order by p.pname
Reference:http://confluence.atlassian.com/display/JIRA/Database+Schema
