Subversion Repositories DevTools

/* Package Action Log */
SELECT alog.action_datetime, 
           usr.FULL_NAME,
       usr.USER_EMAIL, 
       acttype.description as acttype, 
       alog.description
  FROM ACTION_LOG alog, ACTION_TYPE acttype, USERS usr
 WHERE alog.PV_ID = :PV_ID
   AND alog.ACTTYPE_ID = acttype.ACTTYPE_ID 
   AND alog.USER_ID = usr.USER_ID
 ORDER BY ( alog.ACTION_DATETIME ) DESC