# Factually, how many SD members have more than 1,000 posts?

**URL:** <https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082>\
**Category:** About This Message Board\
**Created:** [March 8, 2004, 4:59am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082 "2004-03-08T04:59:22Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![SwingWing](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@SwingWing](https://boards.straightdope.com/u/SwingWing)\
**Post date:** [March 8, 2004, 4:59am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/1 "2004-03-08T04:59:22Z")

</div>

Factually, how many SD members have more than 1,000 posts?

---

<div class="post-metadata">

**Author:** ![Smeghead](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Smeghead](https://boards.straightdope.com/u/Smeghead)\
**Post date:** [March 8, 2004, 5:07am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/2 "2004-03-08T05:07:11Z")

</div>

Well, I’ll get the count started:

One!

---

<div class="post-metadata">

**Author:** ![kambuckta](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@kambuckta](https://boards.straightdope.com/u/kambuckta)\
**Post date:** [March 8, 2004, 5:14am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/3 "2004-03-08T05:14:17Z")

</div>

Two.

Wheeeeeeeeee

---

<div class="post-metadata">

**Author:** ![bibliophage](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/bibliophage/32/7615_2.png) [@bibliophage](https://boards.straightdope.com/u/bibliophage)\
**Post date:** [March 8, 2004, 5:37am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/4 "2004-03-08T05:37:28Z")

</div>

Since this is a question about this message board, I’ll move the thread to the ATMB forum.

bibliophage  
moderator GQ

---

<div class="post-metadata">

**Author:** ![Ruby](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@Ruby](https://boards.straightdope.com/u/Ruby)\
**Post date:** [March 8, 2004, 5:45am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/5 "2004-03-08T05:45:13Z")

</div>

Three!

---

<div class="post-metadata">

**Author:** ![Lamar\_Mundane](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@Lamar\_Mundane](https://boards.straightdope.com/u/Lamar_Mundane)\
**Post date:** [March 8, 2004, 5:47am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/6 "2004-03-08T05:47:04Z")

</div>

Three!

---

<div class="post-metadata">

**Author:** ![Q.E.D](https://avatars.discourse-cdn.com/v4/letter/q/51bf81/32.png) [@Q.E.D](https://boards.straightdope.com/u/Q.E.D)\
**Post date:** [March 8, 2004, 5:54am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/7 "2004-03-08T05:54:51Z")

</div>

> [@bibliophage](#):
>
> Since this is a question about this message board, I’ll move the thread to the ATMB forum.

Eventually, right? 😃

(five)

---

<div class="post-metadata">

**Author:** ![Ale](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@Ale](https://boards.straightdope.com/u/Ale)\
**Post date:** [March 8, 2004, 6:00am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/8 "2004-03-08T06:00:09Z")

</div>

> [@Lamar Mundane](#):
>
> Three!

Foul!!!, you have only 733. 😉

---

<div class="post-metadata">

**Author:** ![hawthorne](https://avatars.discourse-cdn.com/v4/letter/h/c89c15/32.png) [@hawthorne](https://boards.straightdope.com/u/hawthorne)\
**Post date:** [March 8, 2004, 6:25am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/9 "2004-03-08T06:25:07Z")

</div>

Five.

---

<div class="post-metadata">

**Author:** ![Fish](https://avatars.discourse-cdn.com/v4/letter/f/bc8723/32.png) [@Fish](https://boards.straightdope.com/u/Fish)\
**Post date:** [March 8, 2004, 6:30am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/10 "2004-03-08T06:30:42Z")

</div>

I presume factually that you’re factually asking for which factual SD members factually have more than 1,000 factual posts… **on** the SDMB. If you count posts in other places, I certainly qualify. 🙂

---

<div class="post-metadata">

**Author:** ![Cazzle](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cazzle/32/75_2.png) [@Cazzle](https://boards.straightdope.com/u/Cazzle)\
**Post date:** [March 8, 2004, 7:01am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/11 "2004-03-08T07:01:49Z")

</div>

six

---

<div class="post-metadata">

**Author:** ![Ice\_Wolf](https://avatars.discourse-cdn.com/v4/letter/i/dfb087/32.png) [@Ice\_Wolf](https://boards.straightdope.com/u/Ice_Wolf)\
**Post date:** [March 8, 2004, 7:17am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/12 "2004-03-08T07:17:40Z")

</div>

Seven.

---

<div class="post-metadata">

**Author:** ![Jervoise](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@Jervoise](https://boards.straightdope.com/u/Jervoise)\
**Post date:** [March 8, 2004, 7:27am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/13 "2004-03-08T07:27:32Z")

</div>

Eight.

Gee, what’s with all the Aussies (and Kiwi)? Aren’t we supposed to be at work? 😃

---

<div class="post-metadata">

**Author:** ![Noone\_Special](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/noone_special/32/2863_2.png) [@Noone\_Special](https://boards.straightdope.com/u/Noone_Special)\
**Post date:** [March 8, 2004, 7:28am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/14 "2004-03-08T07:28:30Z")

</div>

```auto

SELECT count(*), <status> FROM <member_table>
   WHERE <posts> > 1000
   GROUP BY <status>

```

…where the names in \<brackets\> are table/column names that I don’t know exactly, but almost certainly exist. This would also give a breakdown by status (MEMBER, BANNED, other(?)).  
If we could get a Mod/Admin or Tech to run this by the server at some off-hour, we’d have a definitive answer. Shouldn’t even be too hard on the hamsters, since this query only accesses the \<member\_table\> - _circa_ 40000 records - and doesn’t touch any tables related to storage of the actual posts on the board (~4,000,000 records - much tougher on the little critters!)

Any chance of this happening?

Dani

And no, I don’t qualify yet… so there!

---

<div class="post-metadata">

**Author:** ![Jman](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/jman/32/4416_2.png) [@Jman](https://boards.straightdope.com/u/Jman)\
**Post date:** [March 8, 2004, 7:47am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/15 "2004-03-08T07:47:51Z")

</div>

Nine - but yes, there really should be a way for an Admin person to do this, and satisfy those curious minds we have!

---

<div class="post-metadata">

**Author:** ![Alereon](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@Alereon](https://boards.straightdope.com/u/Alereon)\
**Post date:** [March 8, 2004, 7:50am UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/16 "2004-03-08T07:50:53Z")

</div>

Ten!

---

<div class="post-metadata">

**Author:** ![hawthorne](https://avatars.discourse-cdn.com/v4/letter/h/c89c15/32.png) [@hawthorne](https://boards.straightdope.com/u/hawthorne)\
**Post date:** [March 8, 2004, 1:18pm UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/17 "2004-03-08T13:18:49Z")

</div>

Idiot-features here miscounted, so we’re up 11. Good job I didn’t make that snarky post about numeracy last night. My WAG for the answer FWIW is 70.

---

<div class="post-metadata">

**Author:** ![Algernon](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Algernon](https://boards.straightdope.com/u/Algernon)\
**Post date:** [March 8, 2004, 2:10pm UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/18 "2004-03-08T14:10:04Z")

</div>

Twelve.

My WAG is 103.

---

<div class="post-metadata">

**Author:** ![BrotherCadfael](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BrotherCadfael](https://boards.straightdope.com/u/BrotherCadfael)\
**Post date:** [March 8, 2004, 3:46pm UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/19 "2004-03-08T15:46:14Z")

</div>

Thirteen!

---

<div class="post-metadata">

**Author:** ![In\_Conceivable](https://avatars.discourse-cdn.com/v4/letter/i/4bbf92/32.png) [@In\_Conceivable](https://boards.straightdope.com/u/In_Conceivable)\
**Post date:** [March 8, 2004, 3:51pm UTC](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082/20 "2004-03-08T15:51:21Z")

</div>

14

[Next page](https://boards.straightdope.com/t/factually-how-many-sd-members-have-more-than-1-000-posts/233082.md?page=2)