---+++Community (Group Mode) Applications Data Space PREFIX sioc: PREFIX sioct: PREFIX foaf: SELECT DISTINCT ?fname, ?msn, ?post WHERE { ?forum a sioc:Community . ?forum sioc:has_part ?parentf . ?parentf sioc:container_of ?post. optional { ?post foaf:maker ?maker }. optional { ?maker foaf:name ?fname } . optional { ?maker foaf:msnChatID ?msn } . } ---+++++Sample Data (Live Query Results) * View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0APREFIX+sioct%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Ftypes%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+DISTINCT+%3Ffname%2C+%3Fmsn%2C+%3Fpost%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fforum+a+sioc%3ACommunity+.%0D%0A++++%3Fforum+sioc%3Ahas_part+%3Fparentf+.%0D%0A++++%3Fparentf+sioc%3Acontainer_of+%3Fpost.%0D%0A++++optional+%7B+%3Fpost+foaf%3Amaker+%3Fmaker+%7D.%0D%0A++++optional+%7B+%3Fmaker+foaf%3Aname+%3Ffname+%7D+.%0D%0A++++optional+%7B+%3Fmaker+foaf%3AmsnChatID+%3Fmsn+%7D+.%0D%0A++%7D&format=text%2Fhtml&debug=on][(via SPARQL Protocol URL)]] * View Query Results [[http://demo.openlinksw.com/view/?format=application%2Frdf%2Bxml&maxrows=50&query=%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0APREFIX%20sioct%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Ftypes%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20DISTINCT%20%3Ffname%2C%20%3Fmsn%2C%20%3Fpost%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fforum%20a%20sioc%3ACommunity%20.%0A%20%20%20%20%3Fforum%20sioc%3Ahas_part%20%3Fparentf%20.%0A%20%20%20%20%3Fparentf%20sioc%3Acontainer_of%20%3Fpost.%0A%20%20%20%20optional%20%7B%20%3Fpost%20foaf%3Amaker%20%3Fmaker%20%7D.%0A%20%20%20%20optional%20%7B%20%3Fmaker%20foaf%3Aname%20%3Ffname%20%7D%20.%0A%20%20%20%20optional%20%7B%20%3Fmaker%20foaf%3AmsnChatID%20%3Fmsn%20%7D%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=][(via iSPARQL Results URL)]] * View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0APREFIX%20sioct%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Ftypes%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20DISTINCT%20%3Ffname%2C%20%3Fmsn%2C%20%3Fpost%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fforum%20a%20sioc%3ACommunity%20.%0A%20%20%20%20%3Fforum%20sioc%3Ahas_part%20%3Fparentf%20.%0A%20%20%20%20%3Fparentf%20sioc%3Acontainer_of%20%3Fpost.%0A%20%20%20%20optional%20%7B%20%3Fpost%20foaf%3Amaker%20%3Fmaker%20%7D.%0A%20%20%20%20optional%20%7B%20%3Fmaker%20foaf%3Aname%20%3Ffname%20%7D%20.%0A%20%20%20%20optional%20%7B%20%3Fmaker%20foaf%3AmsnChatID%20%3Fmsn%20%7D%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=][(via iSPARQL Visual Query Editor URL)]]