, r.content select r.title, r.mime_type, i.name, i.item_id from cr_items i, cr_revisions r where i.parent_id = :comment_id and r.revision_id = i.live_revision select i.item_id, e.label, e.url from cr_items i, cr_extlinks e where i.parent_id = :comment_id and e.extlink_id = i.item_id insert into general_comments (comment_id, object_id, category) values (:comment_id, :object_id, :category)