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:
- 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?
- How can I remove the “Add New” button in my custom post type?
- Add content in custom post type page after the title and before columns
- Change the edit page for a custom post type?
- How do I filter the excerpt metabox description in admin?
- 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
- 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
- Custom Metabox with Taxonomy Dropdown – Saving Issue
- how to create my own edit.php admin page code or template for my custom post type
- 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]
- Custom Post Type Name Causing Problem
- 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
- 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
- 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 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]
- submenu item edit a specific post
- Remove rows in the manage post/page view
- How to avoid manage posts screen duplicates when two plugins use the same library
- Display post meta on edit page in admin
- Modify action buttons for custom post type
- Add a button or image button that calls wp functions in the wp-admin
- Selecting a post in Dashboard
- 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?
- CPT post count is 0 for the authors in the User list
- 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
- 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
- Custom Postype specific changes in admin panel
- Grouping of CPTs and taxonomies into menu groups in admin
- Add a custom text to admin footer in a Custom Post Type page
- Creat new admin url for custom post type
- Custom Field values not Showing in Edit Page of Custom Post Type
- Set thumbnail and title for a post type archive (not post itself!)
- Custom WP_Query doesn’t display all posts
- Copy order items with metadata between orders – Woocommerce
- Change link for “add new” buttons on custom post type
- Custom Post Type – Portfolio no longer works
- How do I edit the WordPress post.php file?
- Add data to post edit page, when post is published
- Custom capabilities not reflecting on admin panel
- How to limit what Editors see in the admin?
- Multiple wp_editor instances in custom post type using Ajax
- Change Post Meta via AJAX from the posts list table
- Custom Attachment Type
- How to display magic field’s custom write panel in wordpress theme?
- Change ordering of fields of custom post type in admin page
- How to display author details in a custom post type in the wordpress backend?
- Add Content Column to Custom Post Type backend
- Change Text in Admin Panel
- Admin slow on Postlist (over 30k Posts in Database)
- How can I put content before my custom post type default pages?
- get_posts() returns empty on custom post type /wp-admin/edit.php
- Put featured image under post title in admin area
- list articles in admin showing nested categories or slugs?
- How we can create menu from Appearance > Menu and use as a add-submenu-page for admin menu?
- WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
- How to display an admin-notice after custom post type edit modification
- Sort custom post column by generated value?
- Add Custom Field in Product in WP Admin and send to Order Webhook
- Publishing failed. The response is not a valid JSON response
- Limiting the Number of User Posts to Their Own Posts
- How to overwrite function to display parent page combobox for custom post type in Edit Post Page?
- How do I create a customised table list of a custom post type (in the admin area)?
- How to redirect from wp-admin/edit.php to a frontend page for specific custom post type?
- exclude admin archive edit screen
- In the admin, how can you list thumbnails instead of titles for a custom post type?
- Custom post meta box as a sub form
- How to override post-new.php with custom template
- Add filter button to custom post type in admin area
- “Trash”, “Draft” and count not showing for custom post type in admin panel
- Edit is changing my custom’s post type parent id
- Custom Post Type Pagination Problem in Admin Section
- 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 posts of parent in edit.php
- Change CPT Edit Target Link for Admin List