SELECT videos_list_intl.description AS desc_intl, videos_list_intl.subs, video_list.vid, video_list.name, video_list.description, video_list.low_file, video_list.high_file, video_list.visibility, video_list.added_at, video_list.drm_file, video_list.active 
FROM video_list 
FULL JOIN videos_list_intl 
ON video_list.vid = videos_list_intl.vid 
WHERE

 (video_list.active = 1 AND (videos_list_intl.lang='0' OR videos_list_intl.lang IS NULL))

  OR

 (video_list_intl.active = 1)
ORDER BY name DESC;