Determining Author post count

This thread on the wordpress codex shows how you can scope your SQL query:

$author_post_count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_author="" . $$username->ID . "" AND post_type="post" AND post_status="publish"");

Related Posts:

  1. why ignore_sticky_posts in sticky post query
  2. get custom post type by tag
  3. Does tax_query really beats meta_query in all situations?
  4. WP_Query by post ID doesn’t work if post is in custom post_status
  5. Using WP_Query To Get Posts Randomly From today
  6. How to know which one is the main query?
  7. WP_Query orderby taxonomy term value (numeric)
  8. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  9. How to order posts by custom WP role?
  10. posts2posts query using connected_items array issue [closed]
  11. WP Query and order by particular specified IDs
  12. Get the post permalink within the loop but without additional DB query
  13. Display revision if post status is pending
  14. Meta query field order together with post_date order causes posts without the meta field to be unordered
  15. How To Remove/hide some specific categories from two different categories widget from sidebar
  16. WP Query search for attachments and their exact title
  17. How to add another parameters to WP_Query?
  18. Display link to taxonomy archive only if it has posts with certain custom field values
  19. How to display posts month by month?
  20. Programmatically set ‘meta_query’ for filter
  21. Display posts with date wordpress default
  22. WP Query Exclude and Start by Menu Order Offset
  23. Extending woocommerce admin product search
  24. Pagination is broken and I need help fixing it
  25. Query total number of posts
  26. Category attribute not working in custom shortcode
  27. WP_Query Excluding pages with Order is 0
  28. How to display a posts 1 year ago with custom WP_Query loop?
  29. Check on which page specific result exist
  30. WC displaying products from category
  31. Show all post for a given category
  32. Loop returning only 1 result
  33. Fetch posts that match term slug first two letters (wp query)
  34. pagination with numbers for WP_User_Query
  35. How does one perform a sub query with different post types
  36. Query with search and subscribers only output
  37. Stuck in the query loop
  38. Query Page Content From Theme Options?
  39. Filter wordpress post categories with jquery/ajax and pagination?
  40. Taxonomy order exception for specific term
  41. next_post_link / previous_post_link not working with WP_Query
  42. How to Create a Random List of Child Pages
  43. How to display the featured image for each post?
  44. How do I amend wp_query before it is run/executed?
  45. Post Thumbnail URL isn’t pulling into the background of div
  46. Is there a way to make this kind of loop shorter and nicer?
  47. WP query is calling get_userdata and throws error [closed]
  48. How to set up hierarchical relationships without using plugins / meta query
  49. Single field to search for matches on post ID or meta values
  50. 2 column recent post query not respecting float right [closed]
  51. Meta query compare for ID’s greater than specific ID
  52. WP_Query->request has a limit
  53. Slider won’t work with custom query
  54. wordpress udpate query not equal to
  55. How to generate feed for custom template
  56. Add parameter to first post only
  57. using nav menu id’s
  58. Ignore image urls in wp_query search
  59. Performance concerns: index.php vs taxonomy-$taxonomy.php
  60. Why does apply_filters behave different inside and outside a loop?
  61. Having a variable based on $post_count increase when i move to the next page of results
  62. Post order by custom fields
  63. WP Query and multiple pages
  64. meta_query where the meta value is not the post title
  65. Elementor posts custom query based on tag [closed]
  66. How can I do a orderby by the number of items? So basically list by starting with the array with the largest number of post
  67. Is WP Query skipping to check next post when an argument is not met?
  68. How do you do a meta query on an encrypted field?
  69. meta_query is overriding default search
  70. Custom Woocommerce Product Query
  71. Multiple WP_Query args combinations according to post type
  72. How can I write a WP_Query that is this specific?
  73. in_the_loop() issue with custom query
  74. Pagination inside the blog page not working
  75. How to restrict add media library only to images of the same post family?
  76. How to query most recent post for each author?
  77. Custom Query Pagination not working on static front page
  78. Post Template Query with WP_Query?
  79. Wp Query sort order
  80. get_posts query caching?
  81. Adding additional taxonomies to wordpress taxonomy page
  82. why doesn’t this pre_get_posts code work?
  83. pre_get_posts with WP_Query to prevent posts from specific tags
  84. Query Top Set Custom Taxonomy In Given Timeperiod
  85. Custom taxonomy and query multi conditions
  86. Best way to Order Post in Home without a plugin
  87. Retrieving category pages from subcategory returns empty sets
  88. WP_query issue with no posts
  89. How to get query results for the next page
  90. Loop through multiple custom fields with increasing number
  91. Different number of posts showing in development vs production server
  92. Get post closest to today
  93. Multiple loop for “featured” items returns wrong posts
  94. Get WP_Query query after execution?
  95. Pagination in custom query not working [duplicate]
  96. Query string form $_GET[‘value’] is not working as meta value in wp_query
  97. query_posts problem – need help
  98. $query_args for loop to only get posts from “current category”?
  99. 294 Queries on Mainpage of WordPress
  100. Pagination on custom post type not working