select a.Ne_ID,a.Ne_Title,a.Ne_State,a.Ne_Gourl,a.Ne_Pic,a.Ne_subTitle,a.Ne_VideoPlayModel,c.Sort from TB_3D_List a left join TB_3D_MenuClass b on a.Ne_Class=b.N_ID left join TB_3D_List_Sort c on a.ne_id=c.ObjctID and c.FromID=152 and c.Model='Class' and c.ByClass is null where b.N_Code like '100116100%' and a.Ne_ClassIDArry like '%152,%' and a.Ne_State=0 and a.Ne_VideoPlayModel=1 order by c.Sort,a.Ne_ID asc
