SQL query to get projects list where user added personally. Not in group.

[Timofei Popov]

Hello, everybody.

I need a SQL query to get project lists, where user been added personally. Not in the group, project role, or some. 

If u don't know, how make it throw SQL query, maybe you know how do this in other ways?

[Alexey Matveev · Accepted solution]

Hello,

Try like this

select * from schemepermissions where perm_type = 'user'