SELECT DISTINCT n.name FROM dbm_nodes n JOIN dbm_nodes join_0_n ON n.id=join_0_fv_0.type JOIN dbm_nfv_disc join_0_fv_0 ON join_0_fv_0.node_id=join_0_n.id WHERE (join_0_n.parent_id=1927 AND join_0_fv_0.isactive=1) ORDER BY n.name
Unknown column 'join_0_fv_0.type' in 'on clause'