SELECT s.*,v.vehicletype_id,v.euro5,v.euro,c.title as company_name,c.short_title,
/*IF(v.vehicletype_id<=2, 'a', c.title)*/
c.title as sortie,
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.