select sdprojectm0_.ProjectID as col_0_0_ from sd_project_master sdprojectm0_ cross join sd_project_roles sdprojectr1_ cross join sd_project_roles_details sdprojectr2_ where sdprojectr2_.UserID=? and sdprojectr2_.ProjectRoleID=sdprojectr1_.ProjectRoleID and sdprojectr1_.ProjectID=sdprojectm0_.ProjectID and sdprojectm0_.Status=0 group by sdprojectm0_.ProjectID |
1
|
9
|
1
|
|
0.00
|