select object_type from attachments, acs_objects where attachments.object_id = :object_id and attachments.item_id = :attachment_id and attachments.item_id = acs_objects.object_id 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