SELECT DISTINCT(a.ID), a.ID,a.Title_Ch,a.Title_En,a.Image_Ch,a.Image_En,a.link_url,a.Order,a.SortID,a.SortPath,a.Type,a.img_url,a.ViewFlagCh,a.ViewFlagEn,a.Reg_Date,a.Content_Tn,a.Content_Tn_En,a.param1,a.param2 FROM lxkj_archives as a join lxkj_article_type_ids as i ON i.article_id=a.ID where (a.ViewFlagCh=1 and i.type_id in (11)) ORDER BY a.Order ASC, a.ID DESC  limit 5