why the posts queried from sql is more than those showed on the page?

Related Posts:

1. How to Display Network Post Count?
2. How to cache a shortcode functions output?
3. When is the ‘post_content_filtered’ column in database cleared by WordPress?
4. How to mark every 3rd post
5. Can posts have parents?
6. Where is the old post permalink slug stored?
7. Count posts within a custom post type and specific taxonomy and terms?
8. How to Display a List of Users Who Have Made at Least 1 Post?
9. Separate Database Tables For Different Post Types
10. How can I safely increase the character limit for post passwords?
11. How to Group Posts by the First Letter or Number?
12. Restore contents of deleted user
13. Querying post from a multisite network
14. How are terms connected with posts in database?
15. Moving WordPress to new server: no posts found
16. Count posts in category including child categories
17. How to get a post content from another wordpress blog/site?
18. how to enable different number of revisions for different blogs when using WPMU?
19. Count singular post views automatically
20. Set font size automatically according to number of words in post
21. Custom Taxonomies Incorrectly Counting Revisions?
22. Network wide post count (WP Multisite)
23. Synchronizing Two WordPress Sites Content
24. Strange switch_to_blog() issue
25. Redirect based on user post count
26. Alternate custom content in the loop
27. How to hook a function only when I need to delete permanently a post?
28. How to share same post to multiple site in wordpress?
29. database columns: post_title vs post_name
30. Sanitizing `wp_editor();` Values for Database, Edit, and Display
31. How to create post in WP network using WP-CLI
32. Exporting Data from WordPress into a flat table
33. Show that current post is number X out of X
34. Pull posts from another wordpress install on same server
35. Insert posts in two tables
36. Show the author’s count of total amount of posts assign to a custom taxonomy term
37. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
38. Importing New Posts from Live Site into Local Dev Site
39. Double count view in archive.php
40. Query posts from different categories in multisite
41. Manually removing revision post types
42. Count to how many categories a post belongs to
43. How much of my site can I recover from public_html?
44. Reset/Reorder posts ID in the MySQL wp_posts table
45. How to store an extra (surrogate) ID when creating a post with wp_insert_post?
46. Count total number across post types
47. How do I find which articles are missing a featured image in The WordPress database?
48. Count search results in heading
49. How to hide first gallery for every post?
50. Split WP_POST table based on post types
51. Most recent post from another database
52. What structure should post_content have in the database?
53. Multisite – Get current post id
54. Multiples Empty Posts were created and cannot delete them
55. Counter of posts ever posted – even deleted ones
56. How to delete all the content of a wordpress site without deleting the Post and pages?
57. Display Published Posts Count for Certain Time Period
58. Extracting post categories
59. How to modify post content?
60. How to show last post of each website of a MU wordpress in HomePage
61. How to display content from the main blog on another from multisite network as it would be its own
62. After database migration, posts not showing up in dashboard
63. How can I get global $post to work for CPT and update user?
64. Multisite: Can’t Post or Create Categories
65. Unable to restore from backup – how to obtain old blog posts?
66. Transferring WordPress Database – Serialised data
67. Emojis replaced by ‘?’ automatically
68. Pagination with an array of post objects?
69. WordPress Local And Live Site
70. WordPress Multisite – Create Default Post and New Category On New Site Install
71. Can’t update old posts 3.5.2
72. Set static page/post from another blog on same network
73. Copy post to separate database with “add_action(….)”
74. When open add new post or page WordPress add post with ID=0 continuously [closed]
75. wp_posts table: safely remove unused columns to save database storage
76. Anyone know why wordpress converts some html entities to their numeric equivalents?
77. Remove a shortcode from all WordPress posts
78. Display Notification Bar on Header on Certain Post Count
79. What do these phpMyAdmin errors mean on my WordPress databaes?
80. Show posts count for Categories and Tags in wp_nav_menu
81. How to add category post count in main navigation menu [closed]
82. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
83. Count number of posts of current month
84. why there are so many posts whoes post_type is revision? will these records waste too much database space?
85. How to WP_Query() from multiple blogs and order them?
86. Delete all drafts?
87. Is it possible to use WP_Query to only pull posts with attachments?
88. Howto show comment count by post in post?
89. Get posts and include taxonomy term
90. Why my wp_posts data is so huge?
91. Is it possible to filter the main loop to exclude posts from a specific category?
92. Counter is skipping post when I still want it visible [closed]
93. Add field to user meta table in database when link is clicked
94. How do I show posts from another wordpress installation?
95. How safe is it to delete old posts edits to save database space?
96. Display password protected posts to logged in users
97. Delete post revisions only for a single post
98. Count several post tags
99. Move posts from a non-wordpress site to wordpress
100. wp_posts table extremely large