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