Message: select d.DocumentID,d.Subject,d.DisplayTypeID,d.ReplyMode from CustomFieldVals cfv LEFT JOIN DocumentObjects d ON cfv.AssocDataID = d.DocumentID LEFT JOIN DocViewable dv ON dv.DocumentID = cfv.AssocDataID
LEFT JOIN GroupViewable gv ON gv.DocumentID = d.DocumentID where cfv.DataID = '3' AND d.DataID = '1' AND cfv.TextData = 1 AND ( dv.UserID = 0 OR dv.UserID = 0 OR gv.GroupID IN ( 0 ) ) group by DocumentID order by d.Level,d.DocumentID
Error:
Errno: