- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
A request of the tigerdroppings DBAs
Posted on 3/18/18 at 2:52 pm
Posted on 3/18/18 at 2:52 pm
The downvote thread got me thinking, can we get a list of the top 5 upvoted and top 5 downvoted posts of all time? I would love to use this data to hone in my skills as a valued poster of this sweet and homely community.
Posted on 3/18/18 at 2:54 pm to vuvuzela
There have been several posts through the years that got a rediculous number of down votes!
Posted on 3/18/18 at 2:58 pm to Spankum
quote:
There have been several posts through the years that got a rediculous number of down votes!
And a greeniculous number of upvotes.
Posted on 3/18/18 at 2:58 pm to vuvuzela
quote:
sweet and homely community.
You calling me ugly?
Posted on 3/18/18 at 2:59 pm to vuvuzela
SELECT TOP 5 Poster, COUNT(*) as CNT
FROM VoteTable
WHERE VoteType = 'UP'
GROUP BY Poster
ORDER BY 2 DESC
SELECT TOP 5 Poster, COUNT(*) as CNT
FROM VoteTable
WHERE VoteType = 'DOWN'
GROUP BY Poster
ORDER BY 2 DESC
FROM VoteTable
WHERE VoteType = 'UP'
GROUP BY Poster
ORDER BY 2 DESC
SELECT TOP 5 Poster, COUNT(*) as CNT
FROM VoteTable
WHERE VoteType = 'DOWN'
GROUP BY Poster
ORDER BY 2 DESC
Posted on 3/18/18 at 3:07 pm to DarthRebel
quote:
SELECT TOP 5 Poster, COUNT(*) as CNT FROM VoteTable WHERE VoteType = 'UP' GROUP BY Poster ORDER BY 2 DESC SELECT TOP 5 Poster, COUNT(*) as CNT FROM VoteTable WHERE VoteType = 'DOWN' GROUP BY Poster ORDER BY 2 DESC
I don't know what any of that means, but Hammertime's "Check His Knuckles First" thread had over 1,200 downvotes. It occasionally gets bumped, so new downvoters can add to the tally.
I'd guess MeauxJeaux2's "Better gas mileage at 100 mph" thread got at least 800.
Posted on 3/18/18 at 3:09 pm to DarthRebel
People are going to try to figure that out.
Well played.
Well played.
Posted on 3/18/18 at 3:10 pm to vuvuzela
quote:
hone in my skills as a valued poster
Fake News
Posted on 3/18/18 at 3:17 pm to White Roach
quote:
I don't know what any of that means, but Hammertime's "Check His Knuckles First" thread had over 1,200 downvotes. It occasionally gets bumped, so new downvoters can add to the tally.
I'd guess MeauxJeaux2's "Better gas mileage at 100 mph" thread got at least 800.
RFK’s thread about guys wearing Polo shirts got hammered pretty good, as I recall. And rightfully so.
Posted on 3/18/18 at 3:17 pm to White Roach
quote:
don't know what any of that means
Op requested a DBA. It appears DR’s post went over your head. Do you even SQL, brah?
Posted on 3/18/18 at 3:21 pm to DarthRebel
Are you a SQL guy work wise?
Posted on 3/18/18 at 3:21 pm to DarthRebel
Never thought my SQL knowledge would pay off on the OT
Posted on 3/18/18 at 3:28 pm to vuvuzela
Why? There are a lot of decent threads that get more downvotes than upvotes and a lot of crap threads that get more upvotes. What are you expecting to find?
Posted on 3/18/18 at 3:30 pm to vuvuzela
Rfk telling other men how to dress was pretty much downvoted by everyone.
Posted on 3/18/18 at 3:33 pm to RedFoxx
quote:
And a greeniculous number of upvotes.
Posted on 3/18/18 at 3:33 pm to DarthRebel
This would return the top 5 most upvoted and downvoted posters. OP asked for most upvoted and downvoted POSTS.
Posted on 3/18/18 at 3:33 pm to PiscesTiger
If you want to see some impressive work go to /r/downvotetrolling
Posted on 3/18/18 at 4:01 pm to Dire Wolf
I'm thinking your missing the JOIN of users and posts.
Assuming upvotes and downvotes are just a column on posts
SELECT u.id, u.username, SUM(p.downvotes)
FROM users u
LEFT JOIN posts p
ON p.user_id = u.id
GROUP BY u.id
ORDER BY SUM(p.downvotes) DESC
LIMIT 5
Assuming upvotes and downvotes are just a column on posts
SELECT u.id, u.username, SUM(p.downvotes)
FROM users u
LEFT JOIN posts p
ON p.user_id = u.id
GROUP BY u.id
ORDER BY SUM(p.downvotes) DESC
LIMIT 5
Posted on 3/18/18 at 4:03 pm to vuvuzela
quote:
hone in my skills as a valued poster of this sweet and homely community.
Just look at Rex’s post history and don’t do any of that.
Popular
Back to top
Follow TigerDroppings for LSU Football News