select v.*,c.channel_name from strl_videos v left join strl_channel_video cv on v.video_id=cv.video_id left join strl_channels c on cv.channel_id=c.channel_id where v.isblock="N" and c.channel_id= and v.video_language="E"order by video_id desc