select distinct local_url, foreign_url from clickthrough_log where package_id = :parent_package_id order by foreign_url