get_option(‘sticky_posts’) returns stickies that are in trash

Why is that even happening aside, from quick look at core it does the following to achieve that in WP_Posts_List_Table class:

$sticky_posts = implode( ', ', array_map( 'absint', (array) $sticky_posts ) );
$this->sticky_posts_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT( 1 ) FROM $wpdb->posts WHERE post_type = %s AND post_status NOT IN ('trash', 'auto-draft') AND ID IN ($sticky_posts)", $post_type ) );

Related Posts:

  1. Exclude sticky post from main query?
  2. Show Sticky Posts in Category Archive
  3. Set sticky posts schedule (Automatic)
  4. Add a single featured post to all pages?
  5. Display only the most recent sticky post, display other posts in chronological order
  6. Include sticky posts in ‘Blog pages show at most’ X number of posts?
  7. Exclude expired sticky posts
  8. Exclude Sticky posts from Main Query break Pagination
  9. ignore_sticky_posts in WordPress 3.0.3?
  10. Exclude Current and Sticky Post
  11. Front page should display only one category of posts including sticky post with custom featured post box
  12. Make sticky post on save
  13. Pin a post to the top of a page, other than the home page
  14. Why WordPress CMS uses an array in wp_options instead of a field for Sticky posts?
  15. ignore_sticky_posts not working with word press version 3.9.1
  16. How to modify query on category pages to show only sticky posts?
  17. Make posts non-sticky
  18. How to check a post is sticky or not yet?
  19. Custom query: how to get the sticky posts first?
  20. I would like to change the sticky posts label “Featured” to something else
  21. How to display sticky post with custom html
  22. Update a post to remove sticky option
  23. Show image if a post is featured
  24. I do not want my front page sticky post to show up in a category
  25. How to display a sticky post inside a div?
  26. WooThemes Mini Features – modify query_posts to display only sticky_posts
  27. Exclude Sticky Posts as everyone!
  28. Don’t move sticky posts to the first page
  29. Latest Sticky Posts with Grid Thumbnails for static front page
  30. Remove old sticky post on publish
  31. Limit Number of Sticky Posts to Show
  32. Display latest sticky post or display nothing
  33. Create thumbs only when a post is sticky or any other way?
  34. How can I display only sticky posts from a parent category on the homepage?
  35. Images for sticky posts
  36. WP_Query: Why is sticky post not first item in loop?
  37. Ensuring sticky posts are retrieved first (without using two queries)?
  38. Highlight a Featured Post?
  39. Remove Trash / Delete option for Custom Post Type / Taxonomy
  40. How to make my front page display only the most recent sticky post, plus usual widgets?
  41. Limiting query_posts to 1, regardless of sticky post?
  42. How do I show sticky posts on a static front page that also contains content?
  43. How to add/retrieve the post trash link?
  44. How to retrieve sticky post in raw sql?
  45. Trash bin for categories
  46. wp_query for the first sticky, then display the rest of the posts excluding the first sticky
  47. Sticky Posts Not Sticking to Top of Category Archive
  48. How to hook in to bulk trash posts
  49. WordPress has a trash for users? (Wrong result for count_user, greater than expected)
  50. Restrict access to the Trash folder in Posts
  51. How to change redirect after moving a page to trash?
  52. Undelete post (untrash)?
  53. Is there an action that is called when a post is restored from the trash?
  54. get_post() function returns post even if it is trashed
  55. Exclude trash from save_post
  56. Dynamically create/remove terms in taxonomy when custom post type is published/trashed
  57. Include Sticky Posts in Page Post Count for custom query
  58. Query sticky posts with thumbnails
  59. How to remove sticky post capability for a specific user role?
  60. How to use custom fields to enable sticky posts on custom post types?
  61. Restore trashed posts with comments
  62. WP_Query doesn’t get sticky post at the top, when used in a page template
  63. Deleted pages showing up when querying for child pages
  64. Ignore sticky posts if post is not in meta query
  65. When trashing a post, also trash related comments
  66. Deleting the attached “comment replies” when trashing a comment
  67. Shortcode to delete post from front end
  68. Store sticky post’s ids in a transient
  69. Move sticky posts down in main loop
  70. wp_query should show stickies first
  71. How to stick custom post at the top in search results
  72. Woocommerce – Want to move the product tabs below short description
  73. Sticky posts per category
  74. How to display only feautured/sticky listings on the homepage
  75. Showing sticky posts with get_posts()
  76. Difficulty with PHP function that displays a post’s format in WordPress
  77. Sticky post for each category on category pages [duplicate]
  78. Only display sticky post or latest post in custom loop
  79. Exclude current sticky post
  80. Why: sticky front page code, shows latest non-sticky on logged-in front page
  81. How to restore all items from trash
  82. Can’t get pagination to work for sticky posts only
  83. How to display sticky or latest published post on the current category page it belongs to?
  84. Script doesn’t trash custom post types. Instead it duplicates the post and generate new versions in the trash
  85. How to change ‘Move to Trash’ to ‘Move to Draft’ for my blog’s users?
  86. Post deleted in trash [closed]
  87. Get all sticky posts from one user through user ID
  88. Custom loop off by one post
  89. How can I have sticky posts while ALSO showing posts from a specific category using one WP_Query?
  90. WordPress Sticky Post Count “Fix” Breaking Pagecount by 72 pages!
  91. Display Specific Posts at Start of Loop
  92. How to display sticky post always at the top (before regular post) in wordpress?
  93. Staggering featured post using ‘sticky’
  94. WordPress deletes custom posts instead of trash them
  95. Run Jquery Script after delete post in front end
  96. Trash a post, send associated comments into the trash bin (change status)
  97. Different style for first two (sticky) posts
  98. wp_trash_post not firing as expected (also applies to trashed_post)
  99. Why ignore_sticky_posts argument is in sticky post query?
  100. How to prevent users from permanently deleting a post from trash, but allow them to restore it?