[Using Sakai] Help with SQL-Query

[mail at nicolaslehmann.de]

Hi at all,

I have a problem with a SQL query on the sakai 2.9.2 database.

I want to select all teaching assistents with the related tutorium that lead a tutorium in a course site.

The problem with my query is that if a student is a teaching assistent in another course site he/she is also listed in my resultset, eventhough he/she is just a student in the course site I want to query on.
I have not the proper connection between the relations...

Can someone post me the right query?

Here is my wrong query:
SELECT DISTINCT `sakai_site`.`TITLE`, `sakai_user`.`FIRST_NAME`, `sakai_user`.`LAST_NAME`, `sakai_site_group`.`TITLE`, `sakai_site_group_property`.`VALUE`
FROM `sakai_site`, `sakai_site_user`, `sakai_user`, `sakai_realm_rl_gr`, `sakai_site_group`, `sakai_site_group_property`
WHERE 
  /* site – user connection */
      `sakai_site`.`SITE_ID` = `sakai_site_user`.`SITE_ID`
  AND `sakai_user`.`USER_ID` = `sakai_site_user`.`USER_ID`
  AND `sakai_user`.`USER_ID` =  `sakai_realm_rl_gr`.`USER_ID` 
  AND `sakai_realm_rl_gr`.`ROLE_KEY` =  '15'
  /* site – group connection */
  AND `sakai_site`.`SITE_ID` = `sakai_site_group_property`.`SITE_ID`
  AND `sakai_site_group_property`.`NAME` = 'sections_location'
  AND `sakai_site`.`SITE_ID` = `sakai_site_group`.`SITE_ID`
  AND `sakai_site_group`.`GROUP_ID` = `sakai_site_group`.`GROUP_ID`
  AND `sakai_site_group`.`GROUP_ID` =`sakai_site_group_property`.`GROUP_ID`
  /* select the site I want the teaching assistents from */
  AND `sakai_site`.`SITE_ID` = '02fa3924-72e7-4407-803c-6b0c529fbb92'
ORDER BY sakai_site.TITLE ASC

Thanks for any help!

Greeting from Berlin
Nicolas Lehmann
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20130704/81b70412/attachment.html