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, 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 WHERE s.users_id=28 AND s.sighting_date='2018-06-20' AND s.location='Long Marston - Rail Live 2018' 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 2018 - Photos and Sightings Report

Two McCulloch TRTs for export to America are not listed as they had no numbers.

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 AB2K)

TXM Plant

Readypower Rail Services

Total Rail Solutions (TRS)

A.P.Webb Plant Hire

Balfour Beatty Rail Services


QTS Group

McCulloch Rail


TRAC Engineering Ltd

L&W Contractors

R. Bance & Co

Torrent Trackside / Vp plc


SRS Rail System

SPL Powerlines

Aquarius Railroad Technologies

Van Elle Rail

Swietelsky Babcock Rail (SBRail)

Pro Rail Services

Fitzgerald Plant Services

Sonic Rail Services

Capel Rail Services


Force One

Alun Griffiths

Complete Drain Clearance



Strata Geotechnics