can you tell me the query to show all the sites that belong to a user? I have looked the tables isp_nodes and isp_dep but i didn´t find the relation of the sites with the users
the table isp_dep is a cros table. so it e.g. lonks users to websites. the website is here the parent while the user is the child. so the relation: isp_isp_web.doc_id = isp_dep.parent_doc_id isp_isp_web.doctype_id = isp_dep.parent_doctype_id isp_dep.child_doc_id = isp_isp_user.doc_id isp_dep.child_doctype_id = isp_isp_user.doctype_id will list you all users of a website
