SELECT DISTINCT 
    id, url, isModal,
    targetDescription, targetType, targetValue, 
    searchConcernRoleId, searchDate, preferredTabs
INTO 
     :id, :url, :isModal,
     :targetDescription, :targetType, :targetValue,     
     :searchConcernRoleId, :searchDate, :preferredTabs
FROM 
    (

	SELECT 
            id, url, isModal, targetDescription, targetType, targetValue,         
            searchConcernRoleId, searchDate, preferredTabs
        FROM 
              SMARTNAVIGATORSEARCHHISTORY    
	WHERE
     		username = :username
        ORDER BY searchDate DESC
     )
ORDER BY searchDate DESC