Factually, how many SD members have more than 1,000 posts?
Well, I’ll get the count started:
One!
Two.
Wheeeeeeeeee
Since this is a question about this message board, I’ll move the thread to the ATMB forum.
bibliophage
moderator GQ
Three!
Three!
Eventually, right?
(five)
Foul!!!, you have only 733.
Five.
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.
six
Seven.
Eight.
Gee, what’s with all the Aussies (and Kiwi)? Aren’t we supposed to be at work?
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!
Nine - but yes, there really should be a way for an Admin person to do this, and satisfy those curious minds we have!
Ten!
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.
Twelve.
My WAG is 103.
Thirteen!
14