Back
· Refresh
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY c1.RANK DESC, c1.NAME, c1.ID' at line 8
SELECT c.ID, c.OBJID, c.RANK, c.NAME,
c1.ID ID1, c1.OBJID OBJID1, c1.RANK RANK1, c1.NAME NAME1,
c1.NAME1 NAME_RU
FROM classes c
JOIN classobj_tree t ON t.OBJID=c.OBJID
JOIN classes c1 ON c1.OBJID=t.POBJID
WHERE c.ID=
ORDER BY c1.RANK DESC, c1.NAME, c1.ID
1:
2: SELECT c.ID, c.OBJID, c.RANK, c.NAME,
3: c1.ID ID1, c1.OBJID OBJID1, c1.RANK RANK1, c1.NAME NAME1,
4: c1.NAME1 NAME_RU
5: FROM classes c
6: JOIN classobj_tree t ON t.OBJID=c.OBJID
7: JOIN classes c1 ON c1.OBJID=t.POBJID
8: WHERE c.ID=
9: ORDER BY c1.RANK DESC, c1.NAME, c1.ID
10:
