I think your best bet is to hook save_post and save the count for each post to a meta field. It’s not feasible to do the calculation when the back end is loaded, every post will have to be queried and sorted in memory. Likewise, doing it all in MySQL will require some significant query modification, and still then you won’t be able to remove shortcodes and markup from the numbers.
as far as the columns and sort are concerned, there are several answers here on how to do that, start with the Related questions column to the right. Also see this post by Scribu on the subject.
Related Posts:
- Change the text on the Publish button
- Placing a Custom Post Type Menu Above the Posts Menu Using menu_position?
- Row actions for custom post types?
- Loading External Scripts in Admin but ONLY for a Specific Post Type?
- Register CPTs using Dashicons for admin menu icon in WP 3.8
- How can I remove the “Add New” button in my custom post type?
- Remove “posts” from admin but show a custom post
- Add content in custom post type page after the title and before columns
- Change the edit page for a custom post type?
- How to check if I’m on a custom post type archive in the admin area
- Admin Filter – Add Post Type Description on Post Type Page
- how to group custom post types
- How do I filter the excerpt metabox description in admin?
- How to add custom columns to Custom Post Type admin screen
- Is it OK to move admin menu items?
- Hide/Show only specific categories in wp-admin new-post.php
- Best way to filter featured image text for a custom post type?
- WordPress Custom Post Type Admin Page really slow
- Add content before/after admin post wp-list-table
- Custom post type Admin Page
- Post slug changed using code doesn’t reflect on editor when post is published
- Filtering Posts by Multiple Taxonomy Terms such as in an Admin Post Listing?
- WP Admin default view mode for Custom Post Type
- Remove date and category filters when editing custom post types
- Ordering Post 2 Post admin meta box by meta from CPT
- Custom Metabox with Taxonomy Dropdown – Saving Issue
- how to create my own edit.php admin page code or template for my custom post type
- Displaying Post Title on Post Edit page?
- Backend search; include CPT meta?
- How to programatically set the post title of a CPT on wp-admin
- How to Change the Title of a Meta Box on a Specified Custom Post Type? [duplicate]
- Make a custom column sortable, by custom post count
- Sort custom post types by last name in the backend
- Using multiple instances of wp_editor in Custom Post Type admin area
- How i add new link after Edit | Quick Edit | Trash | View in quick edit section
- Custom Post Type Name Causing Problem
- How to add post_author column to custom post type
- Use a textarea for a custom post type
- Restrict categories to a custom post type
- Changing the header on post listing page in admin area
- How do I add a custom button to my “edit” list? ( edit.php?post_type= ) beside “Add New”
- WordPress User Roles, Custom Post Types, and Admin views
- Add text to post list/edit screens?
- Adding menu_order to CPT admin page
- Remove “Get Shortlink” button in admin of custom post type
- Need functionality with all post list available at edit.php
- Show hierarchical relationship between to custom post types on admin list
- Show Custom Post Type values in WordPress grid view
- How to make in WordPress admin panel sortable column for the custom field, that count the number of page impressions?
- WP-Admin edit.php & post.php slowdown after import of 10k users
- How to remove ‘create new post’ entry for a custom post type?
- How to make post sticky in the admin page?
- How to customize admin posts based on the user who is logged in
- Get all of user’s custom post types in WP Admin for plugin
- Change headers in admin posts list
- Admin notice not displaying
- Custom Post Type + 20k posts = blank/404 within Admin edit.php [duplicate]
- How do increase the amount of links shown down the left in the admin menu?
- submenu item edit a specific post
- Remove rows in the manage post/page view
- Admin not showing all custom post type posts and views not working
- How to avoid manage posts screen duplicates when two plugins use the same library
- Unable to retrieve any posts of CPT in wp-admin
- Display post meta on edit page in admin
- Modify action buttons for custom post type
- Admin Pointers on a custom post type
- Add a button or image button that calls wp functions in the wp-admin
- Selecting a post in Dashboard
- Custom Post List View: Page or something else?
- Custom admin post.php page
- Custom Taxonomy back-end customizations
- How to add a custom-post-type post within another custom-post-type post edit screen using AJAX?
- Filter term taxonomy metabox in custom post type
- CPT post count is 0 for the authors in the User list
- Addition of custom option panel crashes Media Library & Admin Area
- Tracking changes in admin-page so user gets warning when leaving the page
- Possibilities for the edit.php admin panel? [closed]
- Filter hierarchical custom post type admin page by parent, and include children & grandchildren
- Admin Filter – Add Post Type Description on Post Type Page
- Custom post type editor with dynamic selects, one drop down populating a second second drop down not working
- WP-ADMIN – Listing all CPT in “posts” listing
- manage_edit-{post_type}_sortable_columns sorts, but wrong!
- Custom Postype specific changes in admin panel
- Grouping of CPTs and taxonomies into menu groups in admin
- It’s possible to hide body copy box for a custom post type?
- Show data from one Custom Post Type in another Custom Post Type
- Add a custom text to admin footer in a Custom Post Type page
- Filtering in admin broken for custom post type in 3.8.1?
- Custom post type won’t take my custom fields
- Change the text on the Publish button
- Show a custom field instead of username in the backend author area
- Can’t preview custom post – Redirected to home page
- How to make an admin create/edit post page to look like taxonomy page?
- Show posts of parent in edit.php
- admin search of pages returns custom post types
- Custom order of CPT posts by title, in wp-admin area by default
- Change CPT Edit Target Link for Admin List
- Display posts of only a certain category in WP Admin section?
- Display box in sidebar of custom post type
- How to set up a private custom post type that is accessible in the administrative dashboard?