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