select de.TimeStamp, gt.Name, det.Name, de.ReasonData
 from DeviceEvent de
 join DeviceEventType det on det.id=de.DeviceEventTypeId
 join Device d on d.id = de.DeviceId
 join GamingTable gt on gt.DeviceId = d.id
where det.Name like 'V%'
order by TimeStamp desc