select content_type from cr_items
where item_id = :item_id
select live_revision from cr_items
where item_id = :item_id
select
m.mime_type, m.file_extension
from
cr_mime_types m, cr_revisions r
where
r.mime_type = m.mime_type
and
r.revision_id = $revision_id