Any question answered...

What size Hexlox do I need for a Pro PLT stem and seatpost?

Don't have them with me to check

Any tips on making a bike look less attractive to thieves? On my current to do list is wrap the top and down tubes in inner tubes and duct taping any other logos. Anything else? I hear there are such things as poo stickers.

Why not just use the real thing?

Never clean it. Lots of reflective vinyl?

A shit paint job?

I've just found this:

Why?

Because they're technically better, carbon discs have been used in motor sports for a while now. I think they dispurse heat better .

But carbon rims offer worse braking than alloy ones. How come its different for rotors?

mudguards

does anyone here live in Barnoldswick?

I've seen one like that at the shops, paint job like that and you don't even need to use 2 locks or anything.

1 Attachment

Same one surely. Though they've lost the Cunt from the rear

Any question answered...

What happened to the cunt?

What happened to the cunt?

One of Life's many unanswered questions

I think Velocio banned him a few days ago.

ROW...............ID..................TYPE............SEQ
1.....................1.....................inc...............A
2.....................5.....................exc...............B
3.....................7.....................inc...............C
4.....................7.....................exc...............C

I have a table like this; how do I get only the records that for a given ID and SEQ have either both inc and exc or just inc?

A join? A group by?

in this example, Rows 1,3,4 are all good

That's @reeen 's bike.

Because they're technically better, carbon discs have been used in motor sports for a while now. I think they dispurse heat better .

Better in the very limited sense of providing more power at high temperature compared with ductile iron. Modulation is worse, thermal conductivity is worse, dealing with contamination is worse, wet/dry change is worse, even the hot/cold change is worse, it just goes in the opposite direction which is great for very high energy systems. On a bicycle, carbon brakes are a terrible idea. There's not enough energy to get them up to operating temperature, and they get destroyed quickly by dirt and cold application. Bicycles are not brake-limited, most of the time they are not even grip-limited, they are balance-limited. Stainless steel rotors (which are themselves slightly worse as brakes than ductile iron) provide all the stopping power you'll ever need and throw in decent modulation and great service life in difficult conditions.

Based on brake temperature tests carried out by Hydraulic Press Channel and temperature/wear graphs for Airbus aircraft wheel brakes, it looks like a bicycle might be the best possible way to destroy carbon brakes quickly, since the rotor temperature under braking is always nicely on the steep rise in wear rate from fully cold to the peak wear rate temperature (150±50°C, depending on the exact composition), but never gets past the peak onto the rapid drop off in wear rate which occurs at high temperatures (>250-350°C, depending on the exact composition). Racing cars and motorbikes use shrouded rotors to prevent the temperature dropping into the danger zone in the relative short times between hard brake applications. Cyclists don't brake hard enough or often enough to maintain proper brake temperature, even if you added enough shrouding to dwarf the small weight advantage of carbon over steel rotors.

I'm a much nicer guy now ;)

I suspect it'll be a group by with a having clause, e.g.

(Without access to anything to try it on...)

select ROW, ID, TYPE, SEQ, count(*) as c from blah group by ID,SEQ having ( c = 1 and TYPE = 'inc' ) or c = 2;

(This kind of assumes that Type is either 'inc' or 'exc'. )

Ha!
FWIW I didn’t mean shit as in a badly done paint job, it’s impressive ;)

No worries, didn't think you did. Thanks.

Thanks. Got distracted by Halloween so will investigate this tomorrow

Actually, that won't work as one of the rows of a inc/exc is lost by the group by.

Assuming the primary key combo for an entity is a combination of SEQ and ID then:-

select * from blah where SEQ+ID in ( select SEQ+ID from blah where TYPE='inc' );

should do it, but it's far from efficient.