select url from cr_extlinks where extlink_id = :attachment_id select r.title from cr_revisions r, cr_items i where i.item_id = :attachment_id and r.revision_id = i.live_revision