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='2017-06-21' AND s.location='Long Marston - Rail Live 2017' 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 2017 - Photos and Sightings Report

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.

Quattro Plant (inc AB2000)

TXM Plant

Readypower Rail Services

Total Rail Solutions (TRS)

Story Contracting

Balfour Beatty Rail Services

QTS Group

Geismar

TRAC Engineering Ltd

McCulloch Rail

VolkerRail

R. Bance & Co

Torrent Trackside / Vp plc

SPL Powerlines

Aquarius Railroad Technologies

Van Elle Rail

Pro Rail Services

Road Rail Cranes

Fitzgerald Plant Services

Sonic Rail Services

Capel Rail Services

Railcare

Rhomberg Sersa

Force One

Chieftain

OSL Rail

Zetica Rail

SRS Sjolanders (Sweden)

* unknown owner