SELECT s.*,v.vehicletype_id,v.euro5,v.euro,c.title as company_name,c.short_title, v.vehicle_type, v.conversion, v.slug, /*IF(v.vehicletype_id<=2, 'a', c.title)*/ c.title as sortie, c.ireland, v.tl_prefix, v.photo as photoV, if(v.item_section='otp',0,1) as item_order, if(v.tl_prefix='DR',1,0) as isDR FROM sightings s JOIN vehicles v ON v.item_section=s.item_section AND v.item_id=s.item_id JOIN companies c ON v.company_id=c.id WHERE s.users_id=1 AND s.sighting_date='2014-06-19' AND s.location='Long Marston - Rail Live 2014' ORDER BY s.location asc,/*v.item_section ASC, v.vehicletype_id ASC, */c.ireland asc, company_size desc,sortie ASC, item_order asc, isDR DESC, v.item_section ASC, v.vehicletype_id ASC, v.otpID ASC, v.euro ASC, s.title asc LIMIT 0,1000

Long Marston - Rail Live 2014 - Photos and Sightings Report

This page shows all sightings on Thursday at the Rail Live 2014 exhibition at Long Marston.

The Wednesday list is slightly different. Road Rail Cranes' 919082 was present but left overnight so wasn't there on Thursday.

Most of the Keltbray fleet were in their compound rather than part of the main exhibition. Only E1106, E1300, E1317 & E1355 were on display.

Archived Event Report
This event was a long time ago. Some machines may have since changed owner, been decommissioned, exported or scrapped.

If you would like to add your sightings then please login.

Network Rail

Quattro Plant (inc AB2000)

** Preserved Vehicles

TXM Plant

Readypower Rail Services

A.P.Webb Plant Hire

Story Contracting

Balfour Beatty Rail Services

QTS Group

Geismar

TRAC Engineering Ltd

McCulloch Rail

VolkerRail

Stobart Rail

L&W Contractors

Colas Rail

R. Bance & Co

Keltbray Rail

SRS Rail System

Keltbray Electrification

Bradshaw

SPL Powerlines

Aquarius Railroad Technologies

SES Rail

Van Elle Rail

Aspin Foundations

Swietelsky Babcock Rail (SBRail)

Lundy Projects

Fitzgerald Plant Services

Rexquote

Defence Rail and Container Services

Capel Rail Services

Avondale

Complete Drain Clearance

Neotec

Stagecoach Supertram Maintenance Ltd

Heathrow Rail Engineering

Rail-Ability Ltd

Omnicom Engineering

South Cave Unimogs

Breffni Hire Plant

GT Railservice (Germany)

RENS (Netherlands)

Weedfree (Hungary)

** Decommissioned / Scrapped / Exported / No Rail Wheels