ERROR´╝ÜMDB2 Error: syntax error
_doQuery: [Error message: Could not execute statement] [Last executed query: select l_all.p_parent_tname, l_all.parent_tname, l_all.tid, l_all.tlabel, l_all.tname, l_all.tlead, l_all.tleft, l_all.dbody, l_all.idx, l_all.lecturer_img, l_all.instructor, l_all.instructor_title from (select each_p_parent.tname as p_parent_tname, each_parent.tname as parent_tname, node.tid, node.tlabel, node.tname, node.tlead, node.tleft, detail.dbody, '1' as idx, file.fname as lecturer_img, opt3_1.ovalue as instructor, opt3_2.ovalue as instructor_title from d_title_pc_p as node left outer join d_detail_pc_p detail on node.tid = detail.tid left outer join ( select b.* from d_title_pc_p a, d_title_pc_p b where b.tleft between a.tleft and a.tright and (a.tid = '100004') ) family on node.tleft between family.tleft and family.tright left outer join d_title_pc_p as parent on node.tleft between parent.tleft and parent.tright left outer join d_title_pc_p each_parent on each_parent.tleft < node.tleft and each_parent.tleft = ( select max(tleft) from d_title_pc_p where node.tleft > tleft and node.tleft < tright ) left outer join d_title_pc_p each_p_parent on each_p_parent.tleft < each_parent.tleft and each_p_parent.tleft = ( select max(tleft) from d_title_pc_p where each_parent.tleft > tleft and each_parent.tleft < tright ) left outer join d_file_pc_p as file on node.tid = file.tid and file.fuse = 3 and file.fname ~ 'jpg|jpeg|gif|png' left outer join d_option_pc_p as opt3_1 on node.tid = opt3_1.tid and opt3_1.oid = 'instructor1' left outer join d_option_pc_p as opt3_2 on node.tid = opt3_2.tid and opt3_2.oid = 'instructor1_title' left outer join d_option_pc_p as opt on node.tid = opt.tid and opt.oid = 'flg_new' where 1 = 1 and detail.tid is not null and dstartdate <= '2017-12-15 11:32:59' and (denddate is null or denddate >= '2017-12-15 11:32:59') and node.tpublishflg = 1 and opt3_1.ovalue is not nulland (parent.tid = '100044' OR parent.tid = '100062' OR parent.tid = '100063' OR parent.tid = '100036' OR parent.tid = '100043' OR parent.tid = '100040' OR parent.tid = '100031' OR parent.tid = '100024' OR parent.tid = '100011' OR parent.tid = '100066' OR parent.tid = '100058' OR parent.tid = '100009' OR parent.tid = '100013' OR parent.tid = '100060' OR parent.tid = '100041' OR parent.tid = '100046' OR parent.tid = '100012' OR parent.tid = '100065' OR parent.tid = '100050' OR parent.tid = '100053' OR parent.tid = '100038' OR parent.tid = '100056' OR parent.tid = '100055' OR parent.tid = '100028' OR parent.tid = '100032' OR parent.tid = '100034' OR parent.tid = '100054' OR parent.tid = '100067' OR parent.tid = '100033' OR parent.tid = '100035' OR parent.tid = '100047' OR parent.tid = '100057' OR parent.tid = '100045' OR parent.tid = '100037' OR parent.tid = '100051' OR parent.tid = '100049' OR parent.tid = '100029' OR parent.tid = '100026' OR parent.tid = '100010' OR parent.tid = '100064' OR parent.tid = '100048' OR parent.tid = '100061' OR parent.tid = '100042' OR parent.tid = '100023' OR parent.tid = '100059' OR parent.tid = '100039' OR parent.tid = '100027' OR parent.tid = '100052' OR parent.tid = '100030' OR parent.tid = '100025' ) union select each_p_parent.tname as p_parent_tname, each_parent.tname as parent_tname, node.tid, node.tlabel, node.tname, node.tlead, node.tleft, detail.dbody, '2' as idx, file.fname as lecturer_img, opt4_1.ovalue as instructor, opt4_2.ovalue as instructor_title from d_title_pc_p as node left outer join d_detail_pc_p detail on node.tid = detail.tid left outer join ( select b.* from d_title_pc_p a, d_title_pc_p b where b.tleft between a.tleft and a.tright and (a.tid = '100004') ) family on node.tleft between family.tleft and family.tright left outer join d_title_pc_p as parent on node.tleft between parent.tleft and parent.tright left outer join d_title_pc_p each_parent on each_parent.tleft < node.tleft and each_parent.tleft = ( select max(tleft) from d_title_pc_p where node.tleft > tleft and node.tleft < tright ) left outer join d_title_pc_p each_p_parent on each_p_parent.tleft < each_parent.tleft and each_p_parent.tleft = ( select max(tleft) from d_title_pc_p where each_parent.tleft > tleft and each_parent.tleft < tright ) left outer join d_file_pc_p as file on node.tid = file.tid and file.fuse = 4 and file.fname ~ 'jpg|jpeg|gif|png' left outer join d_option_pc_p as opt4_1 on node.tid = opt4_1.tid and opt4_1.oid = 'instructor2' left outer join d_option_pc_p as opt4_2 on node.tid = opt4_2.tid and opt4_2.oid = 'instructor2_title' left outer join d_option_pc_p as opt on node.tid = opt.tid and opt.oid = 'flg_new' where 1 = 1 and detail.tid is not null and dstartdate <= '2017-12-15 11:32:59' and (denddate is null or denddate >= '2017-12-15 11:32:59') and node.tpublishflg = 1 and opt4_1.ovalue is not nulland (parent.tid = '100044' OR parent.tid = '100062' OR parent.tid = '100063' OR parent.tid = '100036' OR parent.tid = '100043' OR parent.tid = '100040' OR parent.tid = '100031' OR parent.tid = '100024' OR parent.tid = '100011' OR parent.tid = '100066' OR parent.tid = '100058' OR parent.tid = '100009' OR parent.tid = '100013' OR parent.tid = '100060' OR parent.tid = '100041' OR parent.tid = '100046' OR parent.tid = '100012' OR parent.tid = '100065' OR parent.tid = '100050' OR parent.tid = '100053' OR parent.tid = '100038' OR parent.tid = '100056' OR parent.tid = '100055' OR parent.tid = '100028' OR parent.tid = '100032' OR parent.tid = '100034' OR parent.tid = '100054' OR parent.tid = '100067' OR parent.tid = '100033' OR parent.tid = '100035' OR parent.tid = '100047' OR parent.tid = '100057' OR parent.tid = '100045' OR parent.tid = '100037' OR parent.tid = '100051' OR parent.tid = '100049' OR parent.tid = '100029' OR parent.tid = '100026' OR parent.tid = '100010' OR parent.tid = '100064' OR parent.tid = '100048' OR parent.tid = '100061' OR parent.tid = '100042' OR parent.tid = '100023' OR parent.tid = '100059' OR parent.tid = '100039' OR parent.tid = '100027' OR parent.tid = '100052' OR parent.tid = '100030' OR parent.tid = '100025' ) union select each_p_parent.tname as p_parent_tname, each_parent.tname as parent_tname, node.tid, node.tlabel, node.tname, node.tlead, node.tleft, detail.dbody, '3' as idx, file.fname as lecturer_img, opt6_1.ovalue as instructor, opt6_2.ovalue as instructor_title from d_title_pc_p as node left outer join d_detail_pc_p detail on node.tid = detail.tid left outer join ( select b.* from d_title_pc_p a, d_title_pc_p b where b.tleft between a.tleft and a.tright and (a.tid = '100004') ) family on node.tleft between family.tleft and family.tright left outer join d_title_pc_p as parent on node.tleft between parent.tleft and parent.tright left outer join d_title_pc_p each_parent on each_parent.tleft < node.tleft and each_parent.tleft = ( select max(tleft) from d_title_pc_p where node.tleft > tleft and node.tleft < tright ) left outer join d_title_pc_p each_p_parent on each_p_parent.tleft < each_parent.tleft and each_p_parent.tleft = ( select max(tleft) from d_title_pc_p where each_parent.tleft > tleft and each_parent.tleft < tright ) left outer join d_file_pc_p as file on node.tid = file.tid and file.fuse = 6 and file.fname ~ 'jpg|jpeg|gif|png' left outer join d_option_pc_p as opt6_1 on node.tid = opt6_1.tid and opt6_1.oid = 'instructor3' left outer join d_option_pc_p as opt6_2 on node.tid = opt6_2.tid and opt6_2.oid = 'instructor3_title' left outer join d_option_pc_p as opt on node.tid = opt.tid and opt.oid = 'flg_new' where 1 = 1 and detail.tid is not null and dstartdate <= '2017-12-15 11:32:59' and (denddate is null or denddate >= '2017-12-15 11:32:59') and node.tpublishflg = 1 and opt6_1.ovalue is not nulland (parent.tid = '100044' OR parent.tid = '100062' OR parent.tid = '100063' OR parent.tid = '100036' OR parent.tid = '100043' OR parent.tid = '100040' OR parent.tid = '100031' OR parent.tid = '100024' OR parent.tid = '100011' OR parent.tid = '100066' OR parent.tid = '100058' OR parent.tid = '100009' OR parent.tid = '100013' OR parent.tid = '100060' OR parent.tid = '100041' OR parent.tid = '100046' OR parent.tid = '100012' OR parent.tid = '100065' OR parent.tid = '100050' OR parent.tid = '100053' OR parent.tid = '100038' OR parent.tid = '100056' OR parent.tid = '100055' OR parent.tid = '100028' OR parent.tid = '100032' OR parent.tid = '100034' OR parent.tid = '100054' OR parent.tid = '100067' OR parent.tid = '100033' OR parent.tid = '100035' OR parent.tid = '100047' OR parent.tid = '100057' OR parent.tid = '100045' OR parent.tid = '100037' OR parent.tid = '100051' OR parent.tid = '100049' OR parent.tid = '100029' OR parent.tid = '100026' OR parent.tid = '100010' OR parent.tid = '100064' OR parent.tid = '100048' OR parent.tid = '100061' OR parent.tid = '100042' OR parent.tid = '100023' OR parent.tid = '100059' OR parent.tid = '100039' OR parent.tid = '100027' OR parent.tid = '100052' OR parent.tid = '100030' OR parent.tid = '100025' ) ) as l_all group by l_all.p_parent_tname, l_all.parent_tname, l_all.tid, l_all.tlabel, l_all.tname, l_all.tlead, l_all.tleft, l_all.dbody, l_all.idx, l_all.lecturer_img, l_all.instructor, l_all.instructor_title order by l_all.tleft, l_all.idx ] [Native message: ERROR: syntax error at or near "nulland" LINE 56: and opt3_1.ovalue is not nulland (parent.tid = '100044' OR p... ^]