1.9JTD 16V Sportwagon here. Currently being very well behaved and in my good books, so on the plus side its lovely to drive, plenty powerful enough for me, reasonably economical, looks good.

It has however generated a big pile of bills while I’ve had it so do take a thorough look at history and think about what may be lurking. Some have been typical wear and tear for its age (e.g. radiator exhaust etc) but I’ve had an alternator die (difficult job to change, earlier cars had very reliable Bosch units that outlasted the car, later ones like mine had cheaper Denso one), assorted turbo control system problems, and hard to track down battery discharge.

Minor niggles – seems to eat bulbs, sportwagon is not that spacious an estate. Diesel is also a 36k cambelt interval BTW.

I add butter when mashing to avoid them being too dry. Depending on exactly what approach you are taking to carb cutting (sounds like avoiding processed stuff) then a little boiled sweet potato added when mashing is _really_ tasty. IMO etc.

These guys are in Chichester, not used them I’ve just had the bookmark sat around for when I get round to sorting out my dull black chinese import.

http://www.fatcreations.com/%5B/url%5D

Curious to know what sort of price ranges you get offered.

Surely you should get in touch with him and ask him for a copy, asking for a free copy isn’t on

Even though he made it freely available in the first place. Anyhow, apply some common sense terms to google and get the RST version of the PDF on the first page of results.

http://www.jamesrichmond.com/misc/iDaveDiet-RST.pdf

Got some because it was on sale in LBS – probably should have thought about that more!

Couldn’t even get tyres to seal in the garage. It was so thick I think you would need to spread it across the tyre by hand to get it to work, and it seemed to have a _lot_ of ammonia in it which is not going to be good for tyres.

3/4 full bottle sat in my garage for anyone that would like it. Back to Stans and far less grief now.

Interesting – I saw an obtuse comment on Twitter about it and assumed Bell had bought RF!

My steel diamond frame is the 23″ TT version (which I think is the same as the current single size, at the time I bought there were 23″ and 24″ options ). I am 5’10 with 32″ inside leg; I have a Thomson layback seatpost and have run both 90 and 100mm stems. Jeff encouraged me to try a short stem, and its great for hooning around the local woods but for long rides I prefer 100mm.

EBB – wherever it needs to be for correct singlespeed chain tension!

G.

Plus with the RS4 you wouldn’t have to worry about the depreciation?

No, just the bills, based on a friends experience :)

Sounds like the shifter or cable run is sticking – if you click the “mouse ear” and release, it should pop back the rest position and the gear should shift. I’ve had 5 or 6 different campag shifters over the years and that has always been the case.

If you have to pull it back, something is wrong.

If they just decimated everything and the farmers livelihood, even more would swap to supporting the Taliban, who would allow them to grow what they want

Actually the Taliban were reported as banning the growth of poppies. It became more prevalent again after they were ousted. Just one more part of the big mess.

I did it on my cross bike (with slicks) one year – normally take a bog standard road bike though. You see people on all sorts of things, of all sorts of vintages, so just take something that isn’t going to fall apart with a bit of vibration :)

The saturday route used to be more or less the same as the race route, but with a bit of cycle path action in places. Now that there are finishing circuits that repeat some of the hellingen, it is a bit different (not bothered to actually look at the differences).

I’ll be there on the 134km ride, ti Serotta, pink and blue JMJ Cycles jersey if the weather is nice!

Anybody on a Shand and would like to share the experience?

No, but very tempted too.

Recently I’ve been mostly kicking myself for not just ordering one at Bespoked last year, and letting myself get run around by a singularly useless framebuilder for another year instead. And now the waiting list has got rather long :(

But in this case the efficiency is probably mostly from working out the 2 load ids in one go (albeit that is me second guessing the optimiser on a DB I don’t work with :) ). Once you have that, the rest of the query is trivial and just needs the appropriate indexes on loadId if (as it sounds) the tables are large.

You only need the specific data types if there are other types you are excluding from the query (e.g. “DEF”)

CTE = Common Table Expression = the WITH bit. Its just funky syntax for generating a dynamic table ahead of the main query. In this example you can just do it inside the query as per the second example. It comes in quite handy if you need to evaluate hierarchies and then join against those.

‘IN’, rather than ‘=’.

Yes but you will only get one loadId, not one for each type with your query. You can do that if you group by the type.

Not touched DB2 in years, but a quick google suggests it has a similar CTE syntax. Its probably overkill in this case and you could actually rewrite it like this (I rewrote both in terms of tables in a db here and they each give the same results).

There’s a reasonable chance it will help the query optimiser do a decent job and it is at least more readable when you come back to it in 12 months :)

If you do use the CTE version, it needs the group by statement at the bottom of this query adding to it. Add an additional WHERE clause to filter the accounts as per your initial post.

SELECT latestLoadIds.data_type, COUNT(Account_Unique_ID)
FROM Account A
JOIN
(
SELECT MAX LoadId, data_type FROM RefData_Load_Log
WHERE b.data_type IN ( “ABC”, “XYZ” )
GROUP BY data_type
) latestLoadIds ON latestLoadIds.loadId = A.LoadId
GROUP BY latestLoadIds.data_type

A CTE might be a bit more efficient again if using a recent version of SQL server. Presumably you need data type in the result too?

Something like this (untested)

;WITH latestLoadIds (LoadId, data_type) AS
(
SELECT MAX LoadId, data_type FROM RefData_Load_Log
WHERE b.data_type IN ( “ABC”, “XYZ” )
GROUP BY data_type
)
SELECT latestLoadIds.data_type, COUNT(Account_Unique_ID)
FROM Account A
JOIN latestLoadIds ON latestLoadIds.loadId = A.LoadId

Bucklers Hard in Hampshire can’t remember the company

Liquid Logistics (think they are associated with NF Adventures)

I did one of their days out in the purbecks which was a nice easy intro. Just need to convince myself I would use a kayak if I bought one now!

I picked up a pair of nice light carbon tub wheels for the same reason a couple of years back.

First set of tubular wheels I’ve had, I’ve used tub tape rather than getting messy with glue and found it all pretty simple. No hassle with getting them on straight, not shifted one while riding, and can get them changed without any tears.

Can we have a fix so that the login is persistent as well, please (or is it just me?)

Me too – randomly forgets about me, and all of a sudden my system grinds to a halt if I open more than a couple of tabs with STW in them (and its not a slow laptop!)

The shop is closed I believe. Yup, says so here:

http://www.theholeytrail.co.uk/%5B/url%5D

Actually, the latest versions of SP will let multiple users simultaneously edit documents too, like to see DropBox help with that :)

(Not especially a SP fan BTW, spend more time swearing at it from a developer perspective than actually using it)

But if you don’t put the effort in to make it suit your business, then yes its an expensive alternative to a shared drive.

Version control, metadata, workflow, search

They are all, more or less, race tyres not commuting tyres. Or are you just showing off about your weather and road quality :)

Stopped using Michelin Pro-Race because I got them fatally cut too often round here
I have Conti gatorskins on one bike for commuting reliability but I don’t find them all that grippy.
I have Michelin Lithions on another because they were cheap and they seem durable.
Continental Grand Prix 4 season in 28mm would be a nice comfy fancier option

[Edit, none of those in blue though. I’ve had blue tyres, always decided in the end it looked naff :)]

I imagine there is some small print there somewhere regarding airport taxes …

Dammit. With a little more time I would be racing around to put together a plan for a return to Nepal!

I had a front light sorted twice via wiggle. The first which came with a faulty spring they replaced, then when that developed issues it went back to Exposure and was repaired. But has since gone flakey again.

So Wiggle are pretty good, but I’ve gone off using Exposure as I like to be able to depend on a light!

Maybe talk to Ben @ Kinetics about this approach – looks more promising than trying to make a convincing bond for a shim

https://twitter.com/bencooper/status/406468597054464001

Yup – normally just before or after the finish line you will find lots of bottle/food stashes.

I survived 4 hours on a rigid SS last year. JFDI.

How easy would it be to chop the post and use a standard seat post and collar?

Trouble is you don’t know for sure that the internal profile is a standard size for a seatpost …

Kill people?

For example:

http://www.bbc.co.uk/news/world-africa-21381773

Been similar problems in Pakistan too.

Aside from the points above about fuel above, don’t forget the bit in the advert about how far they have to walk just to get the unsafe water. Aside from clean water the other goal is to provide more local supply.

Quite amazed how well the course held up, even if it did get a lot tougher with lots of wheels and rising temperatures.

Great to start under blue skies and sunshine, and to have no body or bike issues this round. First ride on my SS for a while was a bit of a shock to my legs though!

Lets hope they do the same magic with course/weather for the next round.

Both great, though I only spend a couple of days around Bormio. Personally I would be straight to the Dolomites as for me the scenery just edges it. You could put together epic routes from either location.

A few photos from each here : http://www.flickr.com/photos/garyhill/sets/72157608391168444/%5B/url%5D

Motorola Moto G is worth a look, £160 for the 16Gb version. Pleased with mine – 4.5″ screen, battery life seems ok to me but I couldn’t tell you what the camera is like. Its not super small, but more compact than most.

Just to help OP get excited about the Red Sea, some snaps from the trip I got back from at the weekend:

by Gary Hill[/url], on Flickr

Occasional here – currently maybe one trip a year as a nice alternative to a riding trip. PADI AOW and 83 dives now having just got back from a week on a liveaboard from Hurghada clocking up another 20

I am kind of tempted to try and sneak in some UK diving next year though – I’ve done no UK diving to date other than on PADI courses.

I had a long term ankle problem that I just couldn’t shift (admittedly I was doing a couple of nights of judo a week with it heavily strapped) for around 18 months. GP was fairly useless with advice but on a tip from someone who had similar problems I got a wobble board to work on proprioception. I threw away my strapping after 2 weeks.

Its still occasionally troublesome but the point being, it is the type of issue that can drag on without achieving a full recovery, but if you can identify the right kind of proactive measure for your particular injury the improvement can be massive.

Medium timbuk2 here – about 16 years old I think and daily commuting for at least 10 of those. Still waterproof based on todays ride.

The medium one would probably be a tight squeeze for what you listed though I’ve been known to strap forks and all sorts to mine to ride home.

There is a group test in issue 30 of the magazine if you have a pile of them in a corner somewhere – has a lot of the bags mentioned above in it.

I got a 2012 Element at a good price when Evans were clearing out their stock. A few sneaky upgrades to shed a little weight and its great and lives up to all the positive reviews. Would love an Altitude too but that might be slightly extravagant!