wrong sql sentence!select l.*,c.wjm,c.cname from `links` l  left join `column` as c on c.id = l.CID where ( 1 ) and l.CID="28" and l.flag="0" order by l.l_xh asc,l.l_pubdate desc limit 10