Display post x of y within category

Raw SQL is inconvenient.

You can use get_posts() (or WP_Query which it wraps) with 'fields' => 'ids' (see fields parameter ) for lightweight counting, while retaining compatibility with all arguments it accepts, including category parameters

Related Posts:

  1. How to detect single.php (but not single-portfolio.php)?
  2. Changing the post date and time with function
  3. Get current post id in functions.php
  4. Dynamically add id to heading tags
  5. disable WP automatically inserted line breaks after an image
  6. Getting the post_id in wp_ajax function
  7. How to publish a post with empty title and empty content?
  8. delete post also attachments
  9. How to call function within a page/post, to dynamically generate content?
  10. Restrict users from editing post based on the age of the post
  11. How do I use element instead of tags in WordPress post content having webP support?
  12. List only child categories a post is in, of a specific parent category
  13. How to change post status from publish to draft using hook in wordpress?
  14. Guest Author – How to modify my custom function code if the guest author URL will follow a particular pattern/format?
  15. Human Time Diff, change mins to minutes
  16. How to get new post URL?
  17. Force update all posts in custom post type, no content changes
  18. Disable REST API for a user ROLE
  19. How to display post tags
  20. How to Display Post View Count
  21. Remove double space after a period
  22. Add confirmation popup on “Move to Trash”
  23. Allow role to delete posts but block him the wp-admin
  24. WP_Query in functions.php overrides global $post object, even with wp_reset_query()
  25. $post object is null
  26. How to change the page break URL from ../post/2 to …/post/page2/
  27. How can I list random authors from current post category?
  28. Disable single post page
  29. Enabling post thumbnails for custom post type
  30. Run a function when post is deleted?
  31. Getting current post ID in functions.php
  32. Add icon/badge next to posttitle of specific category
  33. Prepend or add an Image to the content of a Post
  34. Load post attached images on a single page site with fancybox
  35. Exclude category from
  36. Setting posts_per_page for taxonomy term template
  37. Change post order random through out the entire WordPress
  38. How to display the link (title) and thumbnail post?
  39. How to do set post permalinks using 6 digit random unique function?
  40. Can’t get buddypress notifications in front-end; why do I get this error?
  41. How do I display some posts fully on the homepage, and some as an excerpt only?
  42. Send post id through ajax and get the post content back
  43. WordPress Automatic Filename Changer
  44. Change all author links in Blog roll
  45. disable Tab post on nav-menus page (Admin)
  46. Adding bootstrap classes to video shortcodes
  47. Every second post different class in blog view
  48. Format latest/newest post differently
  49. is_page Funtion for Posts ?
  50. Get post meta retrieving wrong value
  51. The_excerpt() doesn’t parse – how to change that?
  52. How to only publish posts with image in it
  53. Add custom text automatically on each post
  54. Getting Whitescreen when publishing a post [closed]
  55. Using system date format
  56. Un-highlight Blog Menu Item when Category Menu Item is Selected
  57. Is it advisable to use $post->comment_count instead of get_comments_number( $post_id )
  58. Related Posts: Changing Function For Posts Per Page
  59. saving/reading custom field value does not work – no value gets POSTed
  60. Same post appears in related Posts?
  61. Internal linking to posts permalink fail because of spaces and stripe at postname
  62. Help on conditional statement to accompany wp_insert_post function please?
  63. How to implement a WordPress comments function?
  64. How to add content above footer in posts from specific category
  65. Set Default Post as Parent Child (Nested) Relation
  66. how to show comments only author which send own posts in wordpress
  67. get category in list of posts // shortcode for custom related posts
  68. shortcode // get posts by ids
  69. Alt text attributes not showing over portfolio images
  70. Find most used words in post titles
  71. $post->post_content empty while all other properties are correct
  72. Set a post expiration and delete a post when expirate
  73. I want to change the WordPress comments file
  74. Replace Tag Keyword With Link Within Post Content
  75. Excluding tag Link from html tags in Post content
  76. Changing a users posts to drafts upon role change
  77. AJAX load more posts not using correct category and repeating the same few posts
  78. Get post id outside loop : Notice: Trying to get property of non-object
  79. How to correctly escape data
  80. Trim excerpt to first paragraph
  81. im trying make a function to auto correct posts when i open the posts in the backoffice
  82. How to change number of posts shown on homepage vs other pages?
  83. Show only top 3 posts from 3 categories in order on home page
  84. How to edit label_submit styling?
  85. How to get posts from network blog
  86. Get post title by Alphabet
  87. How can I create a menu items from meta box based on users input
  88. How to use wp_editor(); in functions.php then retrieve content in the template
  89. List direct children of page
  90. How *not* to show the last post on the latest posts list
  91. save_post not working
  92. Display a custom field rating system in the front end
  93. wp trim function not working
  94. Insert Shortcode exactly at the end of the content
  95. Ajax calls in wordpress
  96. display last post modified date in genesis child themes
  97. What function does the loop of displaying posts?
  98. Custom Post-Rename Function Does Not Function in WordPress 6.x
  99. How to use shortcode to get the second to newest post?
  100. How to sort posts alphabetically based on a specific parent category