CONSTRUCT from virtual graph

2 views
Skip to first unread message

PaulZH

unread,
Jan 27, 2017, 3:51:18 AM1/27/17
to Stardog
SELECT *
WHERE { GRAPH <virtual://cbb> {
  FILTER (isLiteral(?object))
  <http://id.milieuinfo.be/cbb/exploitant/01788186000016#id> ?outgoingpredicate ?outgoingobject .
  FILTER (isURI(?outgoingobject))
  OPTIONAL {
  }
}}

returns results.

CONSTRUCT {
  <http://id.milieuinfo.be/cbb/exploitant/01788186000016#id> ?outgoingpredicate ?outgoingobject .
}
WHERE { GRAPH <virtual://cbb> {
  FILTER (isLiteral(?object))
  <http://id.milieuinfo.be/cbb/exploitant/01788186000016#id> ?outgoingpredicate ?outgoingobject .
  FILTER (isURI(?outgoingobject))
  OPTIONAL {
  }
}} 

gives a server error. Logs attached.

The same query on materialised triples work.

Paul

stardog.log

Jess Balint

unread,
Jan 27, 2017, 8:37:02 AM1/27/17
to sta...@clarkparsia.com
Hi Paul,

Does "query explain" also return an error on the CONSTRUCT query?

Jess

--
-- --
You received this message because you are subscribed to the C&P "Stardog" group.
To post to this group, send email to sta...@clarkparsia.com
To unsubscribe from this group, send email to
stardog+unsubscribe@clarkparsia.com
For more options, visit this group at
http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

PaulZH

unread,
Jan 27, 2017, 9:23:55 AM1/27/17
to Stardog
No,

I do get the query plan. And the query also works from cli. The query with the server error was fired from the web interface, not cli.








The Query Plan:




Reduced [#1]


`─ Projection(?yjbiettw AS ?subject, ?predicate, ?object;


   +─         ?yjbiettw AS ?subject, ?outgoingpredicate AS ?predicate, ?outgoingobject AS ?object;


   +─         ?incomingsubject AS ?subject, ?mubzzqcc AS ?predicate, ?yjbiettw AS ?object) [#1]


   `─ Service <virtual://cbb>


      {


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/title' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", ('http://data.kbodata.be/organisation/' || qview1."kbonr") || '#id') AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."naam" IS NOT NULL AND


         qview1."kbonr" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/title' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", 'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."naam" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://www.w3.org/2000/01/rdf-schema#label' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", ('http://data.kbodata.be/organisation/' || qview1."kbonr") || '#id') AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."kbonr" IS NOT NULL AND


         qview1."naam" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://www.w3.org/2000/01/rdf-schema#label' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", 'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."naam" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/identifier' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbo_nummer" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", ('http://data.kbodata.be/organisation/' || qview1."kbonr") || '#id') AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."kbonr" IS NOT NULL AND


         qview1."kbo_nummer" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/identifier' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbo_nummer" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", 'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."kbo_nummer" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/identifier' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbonr" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", ('http://data.kbodata.be/organisation/' || qview1."kbonr") || '#id') AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."kbonr" IS NOT NULL


         UNION ALL


         SELECT


            1 AS "predicateQuestType", NULL AS "predicateLang", 'http://purl.org/dc/terms/identifier' AS "predicate",


            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbonr" AS "object",


            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang", 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",


            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang", 'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",


            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang", ('http://id.milieuinfo.be/cbb/exploitatie/' || qview2."exploitatienr") || '#id') AS "incomingsubject",


            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang", 'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",


            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang", ('http://id.milieuinfo.be/cbb/exploitant/' || CAST('01788186000016' AS VARCHAR(10485760))) || '#id') AS "yjbiettw"


          FROM


         


                 (


                 "public"."exploitant_view" qview1


                 LEFT OUTER JOIN


                 "public"."exploitatie_view" qview2


                 ON


                 (qview2."exploitantnr" = '01788186000016') AND


                 qview2."exploitatienr" IS NOT NULL


                  )


         WHERE


         (qview1."exploitantnr" = '01788186000016') AND


         qview1."kbonr" IS NOT NULL


      }



Jess Balint

unread,
Jan 27, 2017, 10:44:36 AM1/27/17
to sta...@clarkparsia.com
Can you append "LIMIT 1" to your query and try to "explain" it again? The web console adds a LIMIT to the query. I suspect this is what's causing the problem.

Jess

stardog+unsubscribe@clarkparsia.com

Paul Hermans

unread,
Jan 27, 2017, 10:46:15 AM1/27/17
to sta...@clarkparsia.com
That's the culprit, indeed.
Solved.

Paul

On 27 Jan 2017, 16:44 +0100, Jess Balint <je...@stardog.com>, wrote:
Can you append "LIMIT 1" to your query and try to "explain" it again? The web console adds a LIMIT to the query. I suspect this is what's causing the problem.

Jess
On Fri, Jan 27, 2017 at 8:23 AM, PaulZH <pa...@proxml.be> wrote:
No,

I do get the query plan. And the query also works from cli. The query with the server error was fired from the web interface, not cli.

TheQueryPlan:



Reduced[#1]

`─ Projection(?yjbiettw AS ?subject, ?predicate, ?object;

   +─         ?yjbiettw AS ?subject, ?outgoingpredicate AS ?predicate, ?outgoingobject AS ?object;

   +─         ?incomingsubject AS ?subject, ?mubzzqcc AS ?predicate, ?yjbiettw AS ?object) [#1]

   `─Service<virtual://cbb>

      {

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/title' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",('http://data.kbodata.be/organisation/'|| qview1."kbonr")||'#id') AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."naam" IS NOT NULL AND

         qview1."kbonr" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/title' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."naam" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://www.w3.org/2000/01/rdf-schema#label' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",('http://data.kbodata.be/organisation/'|| qview1."kbonr")||'#id') AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."kbonr" IS NOT NULL AND

         qview1."naam" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://www.w3.org/2000/01/rdf-schema#label' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."naam" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."naam" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/identifier' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbo_nummer" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",('http://data.kbodata.be/organisation/'|| qview1."kbonr")||'#id') AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."kbonr" IS NOT NULL AND

         qview1."kbo_nummer" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/identifier' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbo_nummer" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."kbo_nummer" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/identifier' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbonr" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/2000/01/rdf-schema#seeAlso' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",('http://data.kbodata.be/organisation/'|| qview1."kbonr")||'#id') AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

          FROM

         

                 (

                 "public"."exploitant_view" qview1

                 LEFT OUTER JOIN

                 "public"."exploitatie_view" qview2

                 ON

                 (qview2."exploitantnr"='01788186000016') AND

                 qview2."exploitatienr" IS NOT NULL

                  )

         WHERE

         (qview1."exploitantnr"='01788186000016') AND

         qview1."kbonr" IS NOT NULL

         UNION ALL

         SELECT

            1 AS "predicateQuestType", NULL AS "predicateLang",'http://purl.org/dc/terms/identifier' AS "predicate",

            7 AS "objectQuestType", NULL AS "objectLang", qview1."kbonr" AS "object",

            1 AS "outgoingpredicateQuestType", NULL AS "outgoingpredicateLang",'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS "outgoingpredicate",

            1 AS "outgoingobjectQuestType", NULL AS "outgoingobjectLang",'http://id.milieuinfo.be/def#Exploitant' AS "outgoingobject",

            1 AS "incomingsubjectQuestType", NULL AS "incomingsubjectLang",('http://id.milieuinfo.be/cbb/exploitatie/'|| qview2."exploitatienr")||'#id') AS "incomingsubject",

            1 AS "mubzzqccQuestType", NULL AS "mubzzqccLang",'http://www.w3.org/ns/org#siteOf' AS "mubzzqcc",

            1 AS "yjbiettwQuestType", NULL AS "yjbiettwLang",('http://id.milieuinfo.be/cbb/exploitant/'|| CAST('01788186000016' AS VARCHAR(10485760)))||'#id') AS "yjbiettw"

You received this message because you are subscribed to a topic in the Google Groups "Stardog" group.
To unsubscribe from this topic, visit https://groups.google.com/a/clarkparsia.com/d/topic/stardog/-1wxw1Fv_Jk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to stardog+u...@clarkparsia.com.
Reply all
Reply to author
Forward
0 new messages