SELECT DISTINCT Title_Ch,Title_En FROM lxkj_archives where (instr(SortPath,",42,")>0 and ViewFlagCh=1) 
 ORDER BY `Order` ASC, `ID` DESC