Region:  
Systematic:   Full Simple
MySQL error: Unknown column 'c.PARENTID' in 'field list'

show sql text »
1: SELECT c.ID, c.OBJID, c.NAME, c.NAME1, c.PARENTID, c.PARENTOBJID, c.DESCRIPTION,
2: au.NAME AUNAME, au.ID AUID, c.AYEAR, c.ABRACK, c.AYEARREM, c.ORIGGEN, c.ORIGSUBGEN,
3: gn.ID GNID, gn.NAME GNNAME, sgn.ID SGNID, sgn.NAME SGNNAME, c.RANK,
4: (SELECT COUNT(*) FROM classes c1 WHERE c1.PARENTOBJID=c.OBJID
5: ) CNT,
6: (SELECT COUNT(*) FROM articles a1 WHERE a1.CLASSID=c.ID) PHOCNT
7: FROM classes c
8: LEFT JOIN c_author au ON au.ID=c.AUTHORID
9: LEFT JOIN classes gn ON gn.OBJID =
10: (CASE WHEN c.RANK IN (2,3,4,5)
11: THEN (SELECT t.POBJID
12: FROM classobj_tree t
13: WHERE t.OBJID=c.OBJID AND t.PRANK IN (7,8))
14: ELSE NULL
15: END)
16: LEFT JOIN classes sgn ON sgn.OBJID =
17: (CASE WHEN c.RANK IN (2,3,4,5)
18: THEN (SELECT t.POBJID
19: FROM classobj_tree t
20: WHERE t.OBJID=c.OBJID AND t.PRANK=6)
21: ELSE NULL
22: END)
23: WHERE 0=0 AND c.TAXON=1 AND (c.PARENTOBJID IS NULL OR c.PARENTOBJID = 0)
24: ORDER BY c.SORTORDER, c.RANK DESC, gn.NAME, sgn.NAME, c.NAME, c.NAME1, c.ID
25: