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='2015-09-16' AND s.location='Long Marston - RAIL2015' 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 - RAIL2015 - Photos and Sightings Report

This page shows all sightings on Wednesday at the RAIL2015 exhibition at Long Marston.

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

Geismar

TRAC Engineering Ltd

R. Bance & Co

Aquarius Railroad Technologies

Capel Rail Services

ABC Electrification (Alstom, Babcock & Costain JV)

Complete Drain Clearance

** Decommissioned / Scrapped / Exported / No Rail Wheels