Zero2Cool
14 years ago
I'm trying to clean up the database.

My goal is to remove the posts from members that have been deleted.

I want a select statement that shows me how many of them there are before deleting.


I think I'll be using three tables with this.

table (field)
[ul]users (user_id)
posts (poster_id)
posts_text (post_id)[/ul]

Every post is given and id number. Then that id number is assigned to the post text.

The relationship between users and posts is the user_id and poster_id.
The relationship between posts and posts_text is the post_id.

I tried this, but it didn't work so well.

[php]SELECT *
FROM posts LEFT JOIN users
ON posts.poster_id != users.user_id[/php]


I think I caused some site load errors with this query too, lol.
UserPostedImage
dhpackr
14 years ago
bummer you can't delete posts
So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste
dhpackr
14 years ago
don't you want to use count

SELECT posts, COUNT(*) FROM posts WHERE Posterid=poster_id GROUP BY poster_id;

you have to play around with the table names, and you add quite a bit to a query with 'where' & 'group by' as well as 'orderby'

just running a select or count query should not break the site
So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste
Zero2Cool
14 years ago
I dunno, do I?
UserPostedImage
dhpackr
14 years ago
you know the answer, just play around till you get the query.

wanna let me in?

i'll try
otherwise this will help 
So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste
Nonstopdrivel
14 years ago
I'm confused. Are you wanting to clean up deleted posts or posts by deleted members? The owner of the other board I used to administrate did the latter routinely; unfortunately, some of the most prolific members (e.g., instructors) were getting deleted. This resulted in some of our best threads being rendered nearly indecipherable, with members responding to phantom statements and questions. Threads came to resemble Swiss cheese, with much of the best content missing, rendering them all but useless. If this is what you want to do, I'd urge caution in implementing it.
UserPostedImage
Zero2Cool
14 years ago
627 posts returned.


Every post should have a valid relationship to a member.
Every topic should have a valid relationship to a post.
Every post should have a valid relationship to a topic.

I don't want rogue data out there.
UserPostedImage
Pack93z
14 years ago
Yes use the count, cleaner approach for your request in the first post.. as a review.
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Pack93z
14 years ago
Okay.. with the timeout error, more than likely due to query gen, my comment now seems out of place. lol.
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
14 years ago
627 is what I got back, which is just a list of members who have 1 or more posts.

The member list shows 618 with a post.

That to me means we have posts for 9 members that have been deleted.
UserPostedImage
Fan Shout
dfosterf (25-Jul) : It's my one day deal complaint dept. on shareholder meeting day
dfosterf (25-Jul) : Probably a homer access credential intimidation kinda thing
dfosterf (25-Jul) : Meathead "journalists" skip this, concentrating on operational revenue when convenient. They switch when net revenue is more favorable.
dfosterf (25-Jul) : Resulting in an actual drop of net revenue of 12.5%. She is from Minnesota. Just sayin'
dfosterf (25-Jul) : Any plans to hold Maureen Smith (CFO) accountable for a 95% drop in investment revenue?
Mucky Tundra (25-Jul) : In your face, HBO!
Mucky Tundra (25-Jul) : @ByRyanWood Mark Murphy: “A great source of pride of mine is that we were never on Hard Knocks.”
Mucky Tundra (25-Jul) : *years
Mucky Tundra (25-Jul) : @mattschneidman Mark Murphy says he anticipates “many Packers games” being played in Germany, Ireland and/or the U.K. over the next 5-10 yea
dfosterf (25-Jul) : *cafeteria* I have hit my head also, so I sympathize
dfosterf (25-Jul) : Possibly hit his head leaning into the glass protecting the food in the cafateria
dfosterf (25-Jul) : Maybe a low flying drone
dfosterf (25-Jul) : Did Savion Williams run into a goalpost or something?
Mucky Tundra (25-Jul) : also, no bueno when a guy starts getting concussions right off the bat in his career
Zero2Cool (25-Jul) : Concussion is worse. Banks probably vet off day via back booboo claim
Mucky Tundra (25-Jul) : @AndyHermanNFL Jordy Nelson out at camp today. No word if he’s in play for one of the two open roster spots ; )
dfosterf (25-Jul) : Is that better or worse than Banks bad back?
Zero2Cool (25-Jul) : Savion concussion ... not good.
packerfanoutwest (24-Jul) : Aaron Rodgers’s first pass of first team period was picked off
Mucky Tundra (24-Jul) : tbh I didn't hear of his passing
Zero2Cool (24-Jul) : Cosby Show. Malcom Jamal Warner I think is real name
Mucky Tundra (24-Jul) : I was thinking of Ozzy and Hulk
Mucky Tundra (24-Jul) : Who's Theo?
Zero2Cool (24-Jul) : How is Theo alliteration?
Mucky Tundra (24-Jul) : Bad week for people whose names are alliterations
Zero2Cool (24-Jul) : Hulk Hogan gone too.
Zero2Cool (24-Jul) : Oh, it's toe injury
Zero2Cool (24-Jul) : Hope it's not serious. that would stink
dfosterf (24-Jul) : Sounds like an ankle not a knee for Fields
dfosterf (24-Jul) : Ya Flaccp on Browns
Zero2Cool (24-Jul) : Maybe Tyrod Taylor instead
Zero2Cool (24-Jul) : He's on Browns, right?
dfosterf (24-Jul) : They would probably go with Flacco is my guess if Fields out
dfosterf (24-Jul) : Fleece 'em again!
Zero2Cool (24-Jul) : Malik Willis might be someone Jets come after
packerfanoutwest (24-Jul) : Packers introduce 1923-inspired classic uniform, leather-look helmet
Zero2Cool (23-Jul) : Both LB Quay Walker and Rookie DB Micah Robinson have passed their physicals
Zero2Cool (23-Jul) : Happy to see site feels more snappy snappy
Zero2Cool (23-Jul) : No sir. I did not.
dfosterf (23-Jul) : You didn't get free childcare when you were at work?
wpr (23-Jul) : These guys make hundreds of thousands of dollars a year. Pay for their own childcare.
dfosterf (23-Jul) : 2nd issue. Number 1 issue was no gameday childcare. 1 of 3 teams not providing it
Zero2Cool (23-Jul) : Suppose if locker room is main issue, we sitting pretty
wpr (23-Jul) : I thought so Mucky. In those useless player polls GB always rates high overall. Locker is a part of it.
Mucky Tundra (23-Jul) : Wasn't the locker room just updated like 6 or 7 years ago?
Zero2Cool (23-Jul) : I have forum updated on different site. We'll see how this one goes before going to that
Zero2Cool (23-Jul) : Elgton Jenkins has a back injury, is expect to end contract dispute
wpr (23-Jul) : It's funny the PA complained about the locker room. It wasn't that long ago it was top shelf. Things change in a hurry.
wpr (23-Jul) : The site is much more better.
Zero2Cool (23-Jul) : NFLPA report said Packers lockerroom needed upgrade. Whining bout where you change?
Please sign in to use Fan Shout
2025 Packers Schedule
Sunday, Sep 7 @ 3:25 PM
LIONS
Thursday, Sep 11 @ 7:15 PM
COMMANDERS
Sunday, Sep 21 @ 12:00 PM
Browns
Sunday, Sep 28 @ 7:20 PM
Cowboys
Sunday, Oct 12 @ 3:25 PM
BENGALS
Sunday, Oct 19 @ 3:25 PM
Cardinals
Sunday, Oct 26 @ 7:20 PM
Steelers
Sunday, Nov 2 @ 12:00 PM
PANTHERS
Monday, Nov 10 @ 7:15 PM
EAGLES
Sunday, Nov 16 @ 12:00 PM
Giants
Sunday, Nov 23 @ 12:00 PM
VIKINGS
Thursday, Nov 27 @ 12:00 PM
Lions
Sunday, Dec 7 @ 12:00 PM
BEARS
Sunday, Dec 14 @ 3:25 PM
Broncos
Friday, Dec 19 @ 11:00 PM
Bears
Friday, Dec 26 @ 11:00 PM
RAVENS
Saturday, Jan 3 @ 11:00 PM
Vikings
Recent Topics
25-Jul / Around The NFL / Mucky Tundra

25-Jul / Green Bay Packers Talk / Mucky Tundra

25-Jul / Green Bay Packers Talk / TheKanataThrilla

25-Jul / Green Bay Packers Talk / dfosterf

25-Jul / Around The NFL / beast

24-Jul / Green Bay Packers Talk / Martha Careful

24-Jul / Around The NFL / beast

24-Jul / Green Bay Packers Talk / Mucky Tundra

23-Jul / Green Bay Packers Talk / beast

23-Jul / Green Bay Packers Talk / wpr

22-Jul / Random Babble / Zero2Cool

22-Jul / Green Bay Packers Talk / Zero2Cool

22-Jul / Green Bay Packers Talk / Zero2Cool

20-Jul / Green Bay Packers Talk / Mucky Tundra

20-Jul / Green Bay Packers Talk / Mucky Tundra

Headlines
Copyright © 2006 - 2025 PackersHome.com™. All Rights Reserved.