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=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.