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 fs_urls
where
url_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