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