学生工作部

sql:select r.*,c.catid,c.title,c.stype1,c.stype2,c.stype3,c.stype4,c.link,c.addtime,c.thumb from edufe_recommend r inner join edufe_content c on c.id=r.contentid and c.status=99 where r.typeid= and r.status=99 order by listorder desc,c.addtime desc LIMIT 3 error:["42000",1064,"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and r.status=99 order by listorder desc,c.addtime desc LIMIT 3' at line 1"]

sql:select r.*,c.catid,c.title,c.stype1,c.stype2,c.stype3,c.stype4,c.link,c.addtime,c.thumb from edufe_recommend r inner join edufe_content c on c.id=r.contentid and c.status=99 where r.typeid= and r.status=99 order by listorder desc,c.addtime desc LIMIT 1 error:["42000",1064,"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and r.status=99 order by listorder desc,c.addtime desc LIMIT 1' at line 1"]

sql:SELECT c.*,l.cid FROM edufe_recommend r INNER JOIN edufe_content c ON c.id = r.contentid INNER JOIN edufe_content_rel l ON c.id = l.contentid AND c.STATUS = 99 WHERE r.typeid = AND r.STATUS = 99 ORDER BY l.listorder DESC, c.addtime DESC LIMIT 1,4 error:["42000",1064,"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND r.STATUS = 99 ORDER BY\tl.listorder DESC, c.addtime DESC \tLIMIT 1,4' at line 5"]

sql:SELECT c.*,l.cid FROM edufe_recommend r INNER JOIN edufe_content c ON c.id = r.contentid INNER JOIN edufe_content_rel l ON c.id = l.contentid AND c.STATUS = 99 WHERE r.typeid = AND r.STATUS = 99 ORDER BY l.listorder DESC, c.addtime DESC LIMIT 5,4 error:["42000",1064,"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND r.STATUS = 99 ORDER BY\tl.listorder DESC, c.addtime DESC \tLIMIT 5,4' at line 5"]