SELECT a.muxdeleted, a.streamassetid, a.playbackid, e.streamEventId, e.streamEventTitle,a.playbackid,a.thumbnail,e.streamEventDescription, e.isppv, s.sportname, e.startdt as eventdt, a.isverified, a.youTubeId FROM streamEvents e LEFT JOIN sports s ON s.sportid = e.sportid, streamAssets a WHERE e.streameventid = '28257' AND e.streameventid = a.streameventid AND e.isactive = 1 AND a.isactive = 1 AND e.ishidden <> 1 ORDER BY a.streamAssetID