Subversion Repositories DevTools

/* Package Action Log */
/* Stange query attempts to retain the order of the entries */
/* The date format is not strong enough to ensure correct ordering */
/* The user should have used a timestamp instead */
select alog.action_datetime, 
           usr.FULL_NAME,
       usr.USER_EMAIL, 
       acttype.description as acttype, 
       alog.description
       from (
        SELECT  rownum as rn, action_datetime, ACTTYPE_ID, USER_ID, description
        FROM ACTION_LOG 
        WHERE PV_ID = :PV_ID
 ) alog
   join USERS usr on alog.user_id = usr.user_id
   join ACTION_TYPE acttype on alog.acttype_id = acttype.acttype_id
order by alog.action_datetime DESC, alog.rn DESC