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 FROM lxkj_archives as a join lxkj_article_type_ids as i ON i.article_id=a.ID where (instr(a.Property_Ch,"c")>0 and i.type_id in (30)) and a.ViewFlagCh=1 ORDER BY a.Order ASC, a.ID DESC  limit 4