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