User -> Group

User from Group xy

https://intermediate.intra.politaktiv.org/linkeddata-liferay/page/User_/230092

Join two mapped entities

map:User_group a d2rq:PropertyBridge; d2rq:belongsToClassMap map:User; d2rq:property vocab:Group ; d2rq:refersToClassMap map:Group ; d2rq:join "User.userId <= Users_Groups.userGroupId"; d2rq:join "Users_Groups.userGroupId => Group.groupId"; .

Group Blaubeuren

https://intermediate.intra.politaktiv.org/linkeddata-liferay/page/Group_/226376

Joining Element

https://intermediate.intra.politaktiv.org/linkeddata-liferay/page/Users_Groups/226376/230092

Query

SELECT DISTINCT * WHERE { ?user rdf:type vocab:User . ?user vocab:UseremailAddress ?email . ?user vocab:UseruserId ?user_id . ?group rdf:type vocab:Group . ?group vocab:GroupfriendlyURL ?group_url . ?group vocab:GroupgroupId ?group_id . ?group vocab:Group__friendlyURL"/blaubeuren". ?user_group rdf:type vocab:Users_Groups . ?user_group vocab:Users_Groups_groupId ?group_id . ?user_group vocab:Users_Groups_userId ?user_id . } LIMIT 1000