'ello.

systematic downvoting is an issue. If one person targets gnat for downvotes, then its bad. gnat doesn't exactly target his downvotes to a person.

I'm wondering if Vance would appricate a modern html update to his Advanced SCM branching page. I glanced at the html and it was indeed 1998 MS Frontpage generated... fairly clean for MS, but none the less a 15 year old html file.

@YannisRizos wind power reduces local wind speeds which reduce temperature distributions and can cause local warming. I am not sure how much of an effect this has. The buildings in a city have a much larger effect than a wind farm.

Wherever one harnesses some energy gradient, there are effects to the local environment (be it top of ocean / bottom of ocean temperature, or waves, or tides, or wind, or solar...)

There, cleaned up that query and made it a bit more useful...

data.stackexchange.com/stackoverflow/query/102718/…

@JimmyHoffa I intended it to be customizable for that. I use it with min 0, max 5, length 250 to find marginal ones that should be downvoted to make them deletable. I think some 10k users have poked it with min -5, max -1, length 250 to find deletable ones.

There's also a non-link filtering version. data.stackexchange.com/programmers/query/102768/…

I'm trying to think through a "find open questions with more than threshold questions where the median answer length is less than threshold and the median score is less than threshold" - those questions waiting for some person to come along and think they are adding something to it.

I understand the desire - its the same as the one "there is wrong or missing information on a wikipedia page - I need to fix it." However, an old question that looks like a wikipedia page with missing information is likely a bad question to ask in the first place. Not always, but its something that should be found before people make the mistake of trying to add to it.

Titled "Bonding" - alt text "I'm trying to build character but Eclipse is really confusing"

@gnat you've been verbed.

@psr which form of gnat have you pulled?

@psr Have you seen my DE queries to find marginal short answers?

I'm still working on the "lots of questions, open, low median answer size, low median rep." query

Lots of answers...

Trying to find those old subjective questions that attract new users who don't know they are not good questions to answer... and serve as examples to new users of "but this question is still open."

@psr True. The median tests in there are trying to find where there are many short, low voted answers. These are the ones that are most likely lists of resources. People with a helpful wiki mentality feel the need to make the materials in the answers complete (its a good thing on other web 2.0 sites). On a Q&A site, that is not as helpful.

@Morons excellent

many thanks for doing this

again?

kk

@Morons fixed

DataExplorer knowledgeable people - data.stackexchange.com/programmers/query/102768/… - at the bottom of that result set is a link to "Small C Projects" and my query says its "Open" (or rather, not closed). Yet going to programmers.stackexchange.com/q/62502/40980 shows it is closed. What did I get wrong in the query?

  CASE WHEN q.closedDate is null
    THEN 'Closed'
    ELSE ''
  END as Closed,

I'm not filtering, I'm just indicating...

@MichaelT I was banging my head against a CASE last night

@JimmyHoffa I'm currently torturing myself with Joins

@JimmyHoffa it's SQL Zoo so it's default to MySQL but I can change the engine

and outer is a "not" of inner?

@psr so left and right are both types of outer

Inner Join = Intersection

Left Join = A union (A intersection B)

Right Join = B union (A intersection B)

Outer Join = A Union B

Left Excluding = A - (A intersection B)

Right Excluding = B - (A intersection B)

Outer Excluding = A Union B - (A intersection B)