Question deletion on SU

Ivo Flipse

Jan 25, 2011 00:05

does anyone know how to query data.SE for really old, low views and low votes questions?

TomWij

@IvoFlipse: Let me try

date views and votes

seems we need to throw that in a formula and sort on it

KronoS

Jan 25, 2011 00:28

data.stackexchange.com/superuser/q/65777/…

like this @IvoFlipse

Ivo Flipse

what's the date range?

oh wait this one has 'high votes' @KronoS

I'm after low votes

TomWij

Hmm

What would be a reasonable upper limit for views/votes?

KronoS

data.stackexchange.com/superuser/q/65777/…

made changes... just barely getting my hands dirty on this...

Ivo Flipse

change the > 0 to < 1

KronoS

data.stackexchange.com/superuser/q/65777/…

I know have it less than 2... and views less than 350

Ivo Flipse

Jan 25, 2011 00:33

damn I need to stop checking out those questions or they'll get more views :(

KronoS

-1

Q: Hardware Pen device for presentation

Hi I have a scenario. Hope you could suggest the software and hardware required? I teach maths. I write math equations as i do in a paper/ohp and this should get displayed on the screen. I find hardware 'pen' - writing and pointing device. Tablet pen- I accept my limited knowledge on that. Here...

Mark Szymanski

o.o

KronoS

like this one... I think this maybe the type your looking for

Mark Szymanski

Apparently I have like 241 comments.

KronoS

I'm going to save the query

TomWij

Jan 25, 2011 00:34

@IvoFlipse: What about this one?

data.stackexchange.com/superuser/q/65816/…

Ivo Flipse

I like that one

I think I'll delete a bunch of those tomorrow

TomWij

Just made that query up, but something is still bothering me...

Changing the "Score, ViewCount" part of the ORDER BY clause into a formula and changing the limits specified in the WHERE clause might give better results, but anyhow... Should be sufficient enough to get the oldest cleaned.

Tried Score * ViewCount, but that obviously doesn't work as Score is 0 most of the times. :D

Ivo Flipse

yeah I'm planning on outright deleting anything that get's no attention, no votes, no answers, no views

and preferably has been asked by an inactive user

studiohack

@MarkSzymanski: I have 487 - but only 2 of them have a score of 5 or higher...I must not be sarcastic enough.....

Mark Szymanski

Heh.

Only one of mine have a +5 score.

TomWij

Jan 25, 2011 00:39

Yeah, 1.5 years later he probably has already solved the problem or the problem just doesn't exist anymore.

And we can't spend time on fixing such a problem either given we don't know if it (or its user) is still there.

Ivo Flipse

exactly

but it remains unanswered

and it's hurting our stats

so if we delete a 1000 bad ones :P

studiohack

yeah

that will really help our stats @IvoFlipse

Ivo Flipse

66k questions

I'm sure we can loose some dead weight

studiohack

that's for sure...

Ivo Flipse

out of those 12k or so that's unanswered

Mark Szymanski

Jan 25, 2011 00:40

If I could delete questions, I would help.

TomWij

@IvoFlipse: Hmm, just thinking about it, my query doesn't check if they are answered.

Ivo Flipse

you can flag questions that should be deleted @MarkSzymanski

studiohack

as in without checkmarks or absolutely no answers posted?

TomWij

Want me to adjust?

studiohack

@IvoFlipse

Ivo Flipse

Jan 25, 2011 00:41

please do

Mark Szymanski

Ok.

Ivo Flipse

preferably no answers at all @studiohack

and if they have, no upvotes on those answers

TomWij

@studiohack: It doesn't check answers at all, it just looks for lowest votes/views questions of a long time ago.

hmm

Mark Szymanski

I found one that is more than a year old, with no accepted answers. The asker seems to be dead, too.

Flagged it.

studiohack

makes sense @IvoFlipse

TomWij

Jan 25, 2011 00:42

How could I easily check if they are unanswered, one moment...

Ivo Flipse

low views, very old, no activity and no upvoted material

studiohack

@TomWij: ah okay...

Ivo Flipse

but watch out, if we all start looking at questions now

the views go up!

Mark Szymanski

They'll get more views ;)

I'll stop looking now :P

I'll just keep browsing the front page to try to find questions to answer and get more rep from :P

Ivo Flipse

good boy ;)

studiohack

Jan 25, 2011 00:45

@IvoFlipse: does this question have any lasting value? confusingly worded, etc

0

Q: Facebook pop ups

How do you allow Facebook to create pop ups so i can upload a video on my page? It says it wont let me until I disable my pop-up blocker or allow this page to create popups, then try again. Any idea how to do any of those things?

facebook web-browser

Ivo Flipse

not anymore it does

but preferably no or really only one upvote

studiohack

yippee! this is fun!

@IvoFlipse: right.

Ivo Flipse

let's start with the real lowest hanging fruit

I had to upvote the champ, because he lost 2 upvotes there :P

studiohack

would I just go to the questions page and start browsing?

as in, start at the first page @IvoFlipse

Ivo Flipse

no I'd wait for @TomWij or @KronoS to come up with a better query

the first page doesn't have old questions does it?

or sorted for date? :P

Mark Szymanski

Jan 25, 2011 00:47

I just saw that "good boy" reply you just left me, @IvoFlipse... >.>

Ivo Flipse

yes you are ;)

studiohack

merge this dupe's with the original? then delete the dupe?

36

Q: Screenshot Taking Tools

Possible Duplicate: Screenshot utilities for Windows What are the good screenshot taking tools available (open source and commercial)?

tools screenshot

Ivo Flipse

now get back to your rep-hunting!

2

Mark Szymanski

growls

Ivo Flipse

down boy

Mark Szymanski

Jan 25, 2011 00:49

facepaws

Oh. Yeah.

facepalms

TomWij

@IvoFlipse What about this one?

data.stackexchange.com/superuser/q/65891/…

The WHERE clause has been changed to check if it is unanswered.

studiohack

this one is answered: superuser.com/questions/31492/video-streaming

and it is on @TomWij's list

or newest query

TomWij

@studiohack: No, that's unanswered. As there are no upvotes or accept marks given...

studiohack

ahhh! so that's what you mean by ananswered.

kill this one

0

Q: Virtual PC and DPCs

In my environment, we're using VPC images for several users. Some users are seeing "Not Responding" messages from their VPC image for long periods of time. When exploring this in ProcessExplorer on the host machine, we see the process "DPCs" (Deferred Procedure Calls) taking up gobs of processor...

virtual-pc dpc

TomWij

Actually, unanswered is pretty ambiguous...

@IvoFlipse: What type of unanswered questions does Area 51 (or your stats) base itself on? The one I think about?

studiohack

Jan 25, 2011 00:53

this one is downvoted, but some answers may be the same between OP and dupe...so delete w/o merging?

Ivo Flipse

no accepted answer

studiohack

-4

Q: What's your preferred hex editor/viewer (any platform)?

Possible Duplicate: Hex Editors for Windows? community wiki I don't do much of it, but... I'm on Windows and use XVI32. Not the prettiest. Edit: see also, Hex Editors for Windows?, What is a good Windows hex editor / viewer? [SO]

software-rec favorites list

Ivo Flipse

preferably ignore questions closed as duplicates

because dupes aren't always a bad thing

studiohack

no upvotes, but 3 answers on this one...

-3

Q: 4 Browsers on a Single Machine

I have 4 browsers installed on my PC. IE8 Firefox (Default) Safari Opera My problem is that sometimes the other browsers don't work. Is there anyone that could explain why?

windows browser

TomWij

Hmm

Ivo Flipse

Jan 25, 2011 00:54

but downvoted dupes (because they suck that is) can go too

studiohack

okay, will do @IvoFlipse

TomWij

But would the stats count them in or not?

Ivo Flipse

oh and best to just flag them

because I'm going to try and wrap my work up and go to bed :P

count which in?

after I delete they don't exist anymore

TomWij

duplicate questions which are unanswered

studiohack

okay

Ivo Flipse

Jan 25, 2011 00:55

at least not in the new queries

I think closed questions are expelled too

because we can't answer them anymore

you might want to ask it on MSO though

studiohack

right...off-topic/subjective etc

KronoS

we should probably divide this up @studiohack @IvoFlipse @TomWij

studiohack

okay @KronoS

like how?

currently getting the easy ones out, by looking at the ones with low votes, -1 or lower

KronoS

One takes the more recent the other takes latest?

studiohack

on @TomWij's query?

TomWij

Jan 25, 2011 00:57

@IvoFlipse: Gonna leave the unanswered check as is, multiple Meta.SO questions verify it is not accepted + no upvotes.

studiohack

btw @IvoFlipse: I only have a set number of inform mod flags...

Ivo Flipse

then create a question on Meta.SU

KronoS

and how recent do we want to go?

2010 too recent?

Ivo Flipse

and you keep a list of questions that should be deleted

start with 2009

and link to this conversation + the query your using

studiohack

okay, can I create a post, and you make it CW, so that @KronoS and others can edit and add posts?

KronoS

Jan 25, 2011 00:59

gets ready to work his butt off again for @IvoFlipse

Ivo Flipse

then I can just open all those links and delete them

yeah

but you can all add your own answer with questions too if you feel like it

though perhaps better we don't

because it will become harder to keep track of what has been closed :\

studiohack

0

Q: Questions for deletion

Questions that should be deleted, as per moderator approval.

discussion

so create new post for each new question that should be deleted?

@IvoFlipse

TomWij

@KronoS: Given the current filter limits there are 500 unanswered questions from 2009. Afterwards we'll need to discuss how recent we will go or perhaps increase the filter limits to show more crappy questions.

Ivo Flipse

no, create a list of questions you want delete in one answer

studiohack

oh, okay...

Ivo Flipse

Jan 25, 2011 01:02

something else that would trigger crap is users with only 1 question

KronoS

I'm assuming we mark as low quality? @IvoFlipse

Ivo Flipse

that qualifies for all the other points off course

yes, but if you run out of flags @KronoS you can use the meta question to list them

KronoS

we should also write a script that somehow searches a few words from the body with a gmail search... to filter out the spammers.

got it

studiohack

1

Q: Experience with Nuance PDF Converter Professional 6 or alternatives?

This is really a question on behalf of someone who asks me for IT advice. They've been offered a reduced rate purchase of Nuance PDF Converter Professional 6 as they're an Omnipage user, and asked me whether it was any good. That's obviously a somewhat open and subjective question, so more to...

pdf convert

closed as subjective or delete?

KronoS

i got 14 left...

studiohack

Jan 25, 2011 01:03

i only have 12

@KronoS: we opened a question on meta (SU) for questions that should be deleted

Ivo Flipse

it's gone @studiohack

studiohack

I'm enjoying this -

Ivo Flipse

somebody just needs to add some more info to that MSU question ;P

studiohack

okay, like what?

TomWij

@IvoFlipse: Editing it atm.

studiohack

Jan 25, 2011 01:04

this question is only for @KronoS, @IvoFlipse etc

? joking lol

@IvoFlipse: let me know when you leave for good, and I'll stop posting links in here

unless you want them going to Meta starting now?

0

Q: Can not mount disc from cdrecord in sao mode

Possible Duplicate: Can not mount disc from cdrecord in sao mode I tried to burn a livecd iso with my DVD-RW, and it seems it can not burn with cdrecord command in default tao mode. Then I switched to sao mode, it was burned. But it seems I can not get the burned disc mounted. moun...

linux

Ivo Flipse

start now

because nobody will ever be able to read this transcript :P

KronoS

oh also do we just flag.. or vote to close and flag?

studiohack

flag is quicker @KronoS

@IvoFlipse: my question is blank

KronoS

lol wow we got Jeff's attention right away

2

@studiohack do you want me to flag those you just posted?

I've still a got a few left

studiohack

no, @IvoFlipse is going to go through and delete later

Root Access

Participants