Hello.
I have the query
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX crm2: <http://sp7.ru/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?toUri ?fromUri WHERE {
graph ?g {
?ownership1 crm2:own_who ?legal_entity_owners.
?ownership1 crm2:own_what ?legal_entity. }
filter (?g = <http://egrul.ru/>)
?legal_entity_owners crm2:pr ?res1pr.
graph ?a {
?legal_entity_owners crm2:name ?name.
?legal_entity_owners crm2:secondname ?secondname.}
filter (?a = <http://egrul-name.ru/>)
?affiliation crm2:aff_legal_entity ?legal_entity.
?affiliation crm2:aff_organization ?company.
?ownership2 crm2:own_who ?companys_owners.
?ownership2 crm2:own_what ?company.
?companys_owners crm2:pr ?res2pr.
?companys_owners crm2:name ?name.
?companys_owners crm2:secondname ?secondname.
FILTER (?legal_entity_owners != ?companys_owners)
BIND(IF(xsd:integer(?res1pr) >= xsd:integer(?res2pr), ?legal_entity_owners, ?companys_owners) as ?toUri)
BIND(IF(xsd:integer(?res1pr) < xsd:integer(?res2pr), ?legal_entity_owners, ?companys_owners) as ?fromUri)
} LIMIT 1
Sparql endpoint gives a fast response in any format (about 250ms-1.5s):
@prefix ns0: <http://sp7.ru/ontology/> .
_:_ res:solution [
res:binding [ res:variable "toUri" ; res:value ns0:ei_human_503108557068 ] ;
res:binding [ res:variable "fromUri" ; res:value ns0:ei_human_feec55030ea4de946983184a55f2889e ] ] .
But ISQL-v
doesn’t give any result too long (for 2 hours)
virtuoso version:
Version 7.2.6-rc1.3230-pthreads as of Aug 9 2019 (e2a413e)
virtuoso.ini
:
[Database]
DatabaseFile = /var/lib/virtuoso-opensource-7/db/virtuoso.db
ErrorLogFile = /var/lib/virtuoso-opensource-7/db/virtuoso.log
LockFile = /var/lib/virtuoso-opensource-7/db/virtuoso.lck
TransactionFile = /var/lib/virtuoso-opensource-7/db/trxlog/virtuoso20190904090128.trx
xa_persistent_file = /var/lib/virtuoso-opensource-7/db/virtuoso.pxa
;DatabaseFile = /var/lib/virtuoso/virtuoso.db
;ErrorLogFile = /var/lib/virtuoso/virtuoso.log
;LockFile = /var/lib/virtuoso/virtuoso.lck
;TransactionFile = /var/lib/virtuoso/trxlog/virtuoso20181220201625.trx
;xa_persistent_file = /var/lib/virtuoso/virtuoso.pxa
ErrorLogLevel = 7
FileExtend = 200
MaxCheckpointRemap = 500000
Striping = 0
TempStorage = TempDatabase
#TransactionFile = virtuoso20190522051400.trx
[TempDatabase]
DatabaseFile = /var/lib/virtuoso-opensource-7/db/virtuoso-temp.db
TransactionFile = /var/lib/virtuoso-opensource-7/db/virtuoso-temp.trx
;DatabaseFile = /var/lib/virtuoso/virtuoso-temp.db
;TransactionFile = /var/lib/virtuoso/virtuoso-temp.trx
MaxCheckpointRemap = 2000
Striping = 0
;
; Server parameters
;
[Parameters]
DefaultIsolation = 2
ServerPort = 1111
LiteMode = 0
DisableUnixSocket = 1
DisableTcpSocket = 0
;SSLServerPort = 2111
;SSLCertificate = cert.pem
;SSLPrivateKey = pk.pem
;X509ClientVerify = 0
;X509ClientVerifyDepth = 0
;X509ClientVerifyCAFile = ca.pem
TransactionAfterImageLimit = 99999999
MaxClientConnections = 100
CheckpointInterval = 60
O_DIRECT = 0
CaseMode = 2
MaxStaticCursorRows = 5000
CheckpointAuditTrail = 1
AllowOSCalls = 0
SchedulerInterval = 10
;DirsAllowed = ., /usr/share/virtuoso/vad, /import, /EGRUL
DirsAllowed = ., /usr/share/virtuoso-opensource-7/vad, /import, /EGRUL
ThreadCleanupInterval = 1
ThreadThreshold = 10
ResourcesCleanupInterval = 1
FreeTextBatchSize = 100000
SingleCPU = 0
VADInstallDir = /usr/share/virtuoso-opensource-7/vad/
;VADInstallDir = /usr/share/virtuoso/vad/
PrefixResultNames = 0
RdfFreeTextRulesSize = 100
IndexTreeMaps = 256
;IndexTreeMaps = 256
MaxMemPoolSize = 6000000000
;MaxMemPoolSize = 200000000
PrefixResultNames = 0
MacSpotlight = 0
IndexTreeMaps = 64
MaxQueryMem = 32G ; memory allocated to query processor
;HashJoinSpace = 8G
VectorSize = 10000 ; initial parallel query vector (array of query operations) size
MaxVectorSize = 3500000 ; query vector size threshold.
AdjustVectorSize = 0
ThreadsPerQuery = 32
AsyncQueueMaxThreads = 32
TraceOn = user_log, failed_log, user_names, compile, ddl_log, client_sql, errors, dsn, sql_send, transact, remote_transact, exec, soap, cursor
;;
;; When running with large data sets, one should configure the Virtuoso
;; process to use between 2/3 to 3/5 of free system memory and to stripe
;; storage on all available disks.
;;
;; Uncomment next two lines if there is 2 GB system memory free
;NumberOfBuffers = 170000
;MaxDirtyBuffers = 130000
;; Uncomment next two lines if there is 4 GB system memory free
;NumberOfBuffers = 340000
; MaxDirtyBuffers = 250000
;; Uncomment next two lines if there is 8 GB system memory free
;NumberOfBuffers = 680000
;MaxDirtyBuffers = 500000
;; Uncomment next two lines if there is 16 GB system memory free
;NumberOfBuffers = 1360000
;MaxDirtyBuffers = 1000000
;; Uncomment next two lines if there is 32 GB system memory free
;NumberOfBuffers = 2720000
;MaxDirtyBuffers = 2000000
;; Uncomment next two lines if there is 48 GB system memory free
;NumberOfBuffers = 4000000
;MaxDirtyBuffers = 3000000
;; Uncomment next two lines if there is 64 GB system memory free
;NumberOfBuffers = 5450000
;MaxDirtyBuffers = 4000000
;;
;; Note the default settings will take very little memory
;; but will not result in very good performance
;;
NumberOfBuffers = 20710000
MaxDirtyBuffers = 15200000
;NumberOfBuffers = 7425000
;MaxDirtyBuffers = 5568750
[HTTPServer]
ServerPort = 8190
SSLPort = 8890
SSLCertificate = /data/ssl/fullchain.pem
SSLPrivateKey = /data/ssl/privkey.pem
X509ClientVerify = 0
ServerRoot = /var/lib/virtuoso-opensource-7/vsp
;ServerRoot = /USR/lib/virtuoso/vsp
MaxClientConnections = 10
DavRoot = DAV
EnabledDavVSP = 0
HTTPProxyEnabled = 0
TempASPXDir = 0
DefaultMailServer = localhost:25
MaxKeepAlives = 10
KeepAliveTimeout = 10
MaxCachedProxyConnections = 10
ProxyConnectionCacheTimeout = 15
HTTPThreadSize = 680000;280000
HttpPrintWarningsInOutput = 0
Charset = UTF-8
;HTTPLogFile = /var/log/virtuoso/http.log
MaintenancePage = atomic.html
EnabledGzipContent = 1
[AutoRepair]
BadParentLinks = 0
[Client]
SQL_PREFETCH_ROWS = 100
SQL_PREFETCH_BYTES = 16000
SQL_QUERY_TIMEOUT = 0
SQL_TXN_TIMEOUT = 0
;SQL_NO_CHAR_C_ESCAPE = 1
;SQL_UTF8_EXECS = 0
;SQL_NO_SYSTEM_TABLES = 0
;SQL_BINARY_TIMESTAMP = 1
;SQL_ENCRYPTION_ON_PASSWORD = -1
[VDB]
ArrayOptimization = 0
NumArrayParameters = 10
VDBDisconnectTimeout = 1000
KeepConnectionOnFixedThread = 0
[Replication]
;ServerName = db-CE05D567F527
;ServerEnable = 1
;QueueMax = 50000
;
; Striping setup
;
; These parameters have only effect when Striping is set to 1 in the
; [Database] section, in which case the DatabaseFile parameter is ignored.
;
; With striping, the database is spawned across multiple segments
; where each segment can have multiple stripes.
;
; Format of the lines below:
; Segment<number> = <size>, <stripe file name> [, <stripe file name> .. ]
;
; <number> must be ordered from 1 up.
;
; The <size> is the total size of the segment which is equally divided
; across all stripes forming the segment. Its specification can be in
; gigabytes (g), megabytes (m), kilobytes (k) or in database blocks
; (b, the default)
;
; Note that the segment size must be a multiple of the database page size
; which is currently 8k. Also, the segment size must be divisible by the
; number of stripe files forming the segment.
;
; The example below creates a 200 meg database striped on two segments
; with two stripes of 50 meg and one of 100 meg.
;
; You can always add more segments to the configuration, but once
; added, do not change the setup.
;
[Striping]
Segment1 = 100M, db-seg1-1.db, db-seg1-2.db
Segment2 = 100M, db-seg2-1.db
;...
;[TempStriping]
;Segment1 = 100M, db-seg1-1.db, db-seg1-2.db
;Segment2 = 100M, db-seg2-1.db
;...
;[Ucms]
;UcmPath = <path>
;Ucm1 = <file>
;Ucm2 = <file>
;...
[Zero Config]
ServerName = virtuoso (CE05D567F527)
;ServerDSN = ZDSN
;SSLServerName =
;SSLServerDSN =
[Mono]
;MONO_TRACE = Off
;MONO_PATH = <path_here>
;MONO_ROOT = <path_here>
;MONO_CFG_DIR = <path_here>
;virtclr.dll =
[URIQA]
DynamicLocal = 0
DefaultHost = localhost:8890
[SPARQL]
;ExternalQuerySource = 1
;ExternalXsltSource = 1
;DefaultGraph = http://localhost:8890/dataspace
;ImmutableGraphs = http://localhost:8890/dataspace
ResultSetMaxRows = 1000
MaxQueryCostEstimationTime = 60000 ; in seconds
MaxQueryExecutionTime = 0 ; in seconds
DefaultQuery = PREFIX crm2: <http://sp7.ru/ontology/> SELECT * WHERE { ?a ?sp crm2:Organization. ?sp rdf:singletonPropertyOf rdf:type. } LIMIT 100
DeferInferenceRulesInit = 0 ; controls inference rules loading
;PingService = http://rpc.pingthesemanticweb.com/
[Plugins]
LoadPath = /usr/lib/virtuoso-opensource-7/hosting
;LoadPath = /usr/lib/virtuoso/hosting
Load1 = plain, wikiv
Load2 = plain, mediawiki
Load3 = plain, creolewiki
Load4 = plain, im
;Load5 = plain, wbxml2
;Load6 = plain, hslookup
;Load7 = attach, libphp5.so
;Load8 = Hosting, hosting_php.so
;Load9 = Hosting,hosting_perl.so
;Load10 = Hosting,hosting_python.so
;Load11 = Hosting,hosting_ruby.so
;Load12 = msdtc,msdtc_sample
DEBUG REPORT from endpoint:
SPARQL query after parsing, optimization, and converting back into SPARQL
SELECT DISTINCT ?toUri
?fromUri
WHERE {
{ SELECT ?g
?ownership1
?legal_entity_owners
?legal_entity
?res1pr
?a
?name
?secondname
?affiliation
?company
?ownership2
?companys_owners
?res2pr
( if( <http://www.w3.org/2001/XMLSchema#integer>( ?res2pr) <= <http://www.w3.org/2001/XMLSchema#integer>( ?res1pr), ?legal_entity_owners, ?companys_owners) AS ?toUri)
( if( <http://www.w3.org/2001/XMLSchema#integer>( ?res1pr) < <http://www.w3.org/2001/XMLSchema#integer>( ?res2pr), ?legal_entity_owners, ?companys_owners) AS ?fromUri)
WHERE {
GRAPH ?g { ?ownership1 <http://sp7.ru/ontology/own_who> ?legal_entity_owners ;
<http://sp7.ru/ontology/own_what> ?legal_entity . } ?legal_entity_owners <http://sp7.ru/ontology/pr> ?res1pr .
GRAPH ?a { ?legal_entity_owners <http://sp7.ru/ontology/name> ?name ;
<http://sp7.ru/ontology/secondname> ?secondname . } ?affiliation <http://sp7.ru/ontology/aff_legal_entity> ?legal_entity ;
<http://sp7.ru/ontology/aff_organization> ?company . ?ownership2 <http://sp7.ru/ontology/own_who> ?companys_owners ;
<http://sp7.ru/ontology/own_what> ?company . ?companys_owners <http://sp7.ru/ontology/pr> ?res2pr ;
<http://sp7.ru/ontology/name> ?name ;
<http://sp7.ru/ontology/secondname> ?secondname . }
OFFSET 0 }
FILTER (?g = <http://egrul.ru/>)
FILTER (?a = <http://egrul-name.ru/>)
FILTER ( ?legal_entity_owners != ?companys_owners ) }
LIMIT 1
SPARQL query translated to SQL
For security reasons, code responsible for graph-level security is not generated and some account-specific data are intentionally made wrong.
SELECT __ro2sq ("s_33_24_rbc"."toUri") AS "toUri", __ro2sq ("s_33_24_rbc"."fromUri") AS "fromUri" FROM (SELECT DISTINCT TOP 1 "s_32_23"."toUri" AS "toUri",
"s_32_23"."fromUri" AS "fromUri"
FROM (
SELECT "s_10_2_t1"."G" AS "g",
"s_10_2_t1"."S" AS "ownership1",
"s_32_22_t4"."S" AS "legal_entity_owners",
"s_32_22_t5"."O" AS "legal_entity",
"s_32_22_t4"."O" AS "res1pr",
"s_15_7_t3"."G" AS "a",
"s_32_22_t10"."O" AS "name",
"s_32_22_t11"."O" AS "secondname",
"s_32_22_t5"."S" AS "affiliation",
"s_32_22_t6"."O" AS "company",
"s_32_22_t7"."S" AS "ownership2",
"s_32_22_t7"."O" AS "companys_owners",
"s_32_22_t9"."O" AS "res2pr",
case when ( lte ( CAST ( __ro2sq ( "s_32_22_t9"."O") AS INTEGER), CAST ( __ro2sq ( "s_32_22_t4"."O") AS INTEGER))) then ( "s_32_22_t4"."S") else ( "s_32_22_t7"."O") end AS "toUri",
case when ( lt ( CAST ( __ro2sq ( "s_32_22_t4"."O") AS INTEGER), CAST ( __ro2sq ( "s_32_22_t9"."O") AS INTEGER))) then ( "s_32_22_t4"."S") else ( "s_32_22_t7"."O") end AS "fromUri"
FROM DB.DBA.RDF_QUAD AS "s_10_2_t0"
INNER JOIN DB.DBA.RDF_QUAD AS "s_10_2_t1"
ON (
"s_10_2_t1"."G" = "s_10_2_t0"."G"
AND
"s_10_2_t1"."S" = "s_10_2_t0"."S")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t4"
ON (
"s_32_22_t4"."S" = "s_10_2_t0"."O")
INNER JOIN DB.DBA.RDF_QUAD AS "s_15_7_t2"
ON (
"s_32_22_t4"."S" = "s_15_7_t2"."S"
AND
"s_15_7_t2"."S" = "s_10_2_t0"."O")
INNER JOIN DB.DBA.RDF_QUAD AS "s_15_7_t3"
ON (
"s_32_22_t4"."S" = "s_15_7_t3"."S"
AND
"s_15_7_t3"."S" = "s_15_7_t2"."S"
AND
"s_15_7_t3"."S" = "s_10_2_t0"."O"
AND
"s_15_7_t3"."G" = "s_15_7_t2"."G")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t5"
ON (
"s_32_22_t5"."O" = "s_10_2_t1"."O")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t6"
ON (
"s_32_22_t5"."S" = "s_32_22_t6"."S")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t7"
ON (1)
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t8"
ON (
"s_32_22_t6"."O" = "s_32_22_t8"."O"
AND
"s_32_22_t7"."S" = "s_32_22_t8"."S")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t9"
ON (
"s_32_22_t7"."O" = "s_32_22_t9"."S")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t10"
ON (
"s_32_22_t7"."O" = "s_32_22_t10"."S"
AND
"s_32_22_t9"."S" = "s_32_22_t10"."S"
AND
"s_32_22_t10"."O" = "s_15_7_t2"."O")
INNER JOIN DB.DBA.RDF_QUAD AS "s_32_22_t11"
ON (
"s_32_22_t7"."O" = "s_32_22_t11"."S"
AND
"s_32_22_t9"."S" = "s_32_22_t11"."S"
AND
"s_32_22_t10"."S" = "s_32_22_t11"."S"
AND
"s_32_22_t11"."O" = "s_15_7_t3"."O")
WHERE
"s_10_2_t0"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/own_who' , 1))
AND
"s_10_2_t1"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/own_what' , 1))
AND
"s_32_22_t4"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/pr' , 1))
AND
"s_15_7_t2"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/name' , 1))
AND
"s_15_7_t3"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/secondname' , 1))
AND
"s_32_22_t5"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/aff_legal_entity' , 1))
AND
"s_32_22_t6"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/aff_organization' , 1))
AND
"s_32_22_t7"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/own_who' , 1))
AND
"s_32_22_t8"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/own_what' , 1))
AND
"s_32_22_t9"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/pr' , 1))
AND
"s_32_22_t10"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/name' , 1))
AND
"s_32_22_t11"."P" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://sp7.ru/ontology/secondname' , 1))
OPTION (QUIETCAST)
) AS "s_32_23"
WHERE
( "s_32_23"."g" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://egrul.ru/' , 1)))
AND
( "s_32_23"."a" = __i2idn ( /* UNAME as sqlval */ __bft ( 'http://egrul-name.ru/' , 1)))
AND
( "s_32_23"."legal_entity_owners" <> "s_32_23"."companys_owners")
OPTION (QUIETCAST)) AS "s_33_24_rbc"
SQL execution plan
{
Subquery 27
{
RDF_QUAD_POGS 2.6e+07 rows(t3.O$34, t3.G$33, t3.S$32)
inlined P = IRI_ID"...own_who"
RDF_QUAD 1 rows(t7.S$39, t7.G$38, t7.O$37)
inlined P = IRI_ID"...secondname" , S = cast$150 G = IRI_ID"..."
RDF_QUAD 1 rows(t6.S$43, t6.O$42)
inlined P = IRI_ID"...name" , S = k_t3.O$162 G = t7.G$38
RDF_QUAD 1 rows(t5.S$47, t5.O$46)
inlined P = IRI_ID"...pr" , S = k_t3.O$173
RDF_QUAD_POGS 24 rows(t14.S$50)
P = IRI_ID"...secondname" , O = k_t7.O$184
RDF_QUAD 5.5e-07 rows(t13.S$53)
inlined P = IRI_ID"...name" , S = t14.S$50 , O = k_t6.O$194
RDF_QUAD 1 rows(t12.S$57, t12.O$56)
inlined P = IRI_ID"...pr" , S = t13.S$53
Precode:
0: __all_eq$59 := Call __all_eq (t3.G$33, IRI_ID"..." )
5: BReturn 0
RDF_QUAD_POGS 1.7 rows(t10.O$63, t10.S$62)
P = IRI_ID"...own_who" , O = cast$211
END Node
After test:
0: if (t5.S$47 = t10.O$63) then 5 else 4 unkn 5
4: BReturn 1
5: BReturn 0
RDF_QUAD 1 rows(t4.O$66)
inlined P = IRI_ID"...own_what" , S = k_t3.S$227 G = k___all_eq$231
RDF_QUAD_POGS 6.1 rows(t8.S$69)
P = IRI_ID"...aff_legal_entity" , O = cast$239
RDF_QUAD 1 rows(t9.O$72)
inlined P = IRI_ID"...aff_organization" , S = t8.S$69
RDF_QUAD_POGS 5.9e-08 rows()
inlined P = IRI_ID"...own_what" , O = cast$255 , S = k_t10.S$259
After code:
0: __ro2sq$78 := Call __ro2sq (t5.O$46)
5: _cvt$80 := Call _cvt (<tag 193 flag 0>, __ro2sq$78)
10: __ro2sq$82 := Call __ro2sq (t12.O$56)
15: _cvt$84 := Call _cvt (<tag 193 flag 0>, __ro2sq$82)
20: lt$86 := Call lt (_cvt$80, _cvt$84)
25: if ( 0 = lt$86) then 34 else 29 unkn 34
29: callretSearchedCASE$76 := := artm t5.S$47
33: Jump 38 (level=0)
34: callretSearchedCASE$76 := := artm t10.O$63
38: __ro2sq$90 := Call __ro2sq (t12.O$56)
43: _cvt$92 := Call _cvt (<tag 193 flag 0>, __ro2sq$90)
48: __ro2sq$94 := Call __ro2sq (t5.O$46)
53: _cvt$96 := Call _cvt (<tag 193 flag 0>, __ro2sq$94)
58: lte$98 := Call lte (_cvt$92, _cvt$96)
63: if ( 0 = lte$98) then 72 else 67 unkn 72
67: callretSearchedCASE$88 := := artm t5.S$47
71: Jump 76 (level=0)
72: callretSearchedCASE$88 := := artm t10.O$63
76: BReturn 0
Distinct (callretSearchedCASE$88, callretSearchedCASE$76)
skip node 1 <none> set_no$30
After code:
0: toUri$28 := := artm callretSearchedCASE$88
4: fromUri$29 := := artm callretSearchedCASE$76
8: BReturn 0
Subquery Select(toUri$28, fromUri$29)
}
After code:
0: toUri$116 := Call __ro2sq (toUri$28)
5: fromUri$118 := Call __ro2sq (fromUri$29)
10: BReturn 0
Select (toUri$116, fromUri$118)
}
Internal optimizer data
These data are primarily for OpenLink support, to get additional details about the query processing.
QUERY: (line 33) REQUEST TOP NODE (SELECT DISTINCT result-mode):
RETVALS: ARRAY OF NODES with 2 children: {
(line 6) VARIABLE: notNULL reference exported
NAME: UNAME `toUri' SELECT ID: STRING `s_33_24' TABLE ID: LONG 0 EQUIV: LONG 48
(line 6) VARIABLE: notNULL reference exported
NAME: UNAME `fromUri' SELECT ID: STRING `s_33_24' TABLE ID: LONG 0 EQUIV: LONG 49
}
RETVALS SELECT ID: STRING `s_33_24'
SOURCES: EMPTY ARRAY
PATTERN: (line 33) GRAPH PATTERN:WHERE gp
MEMBERS: ARRAY OF NODES with 1 children: {
(line 32) GRAPH PATTERN:SELECT result-mode
MEMBERS: EMPTY ARRAY
SUBQUERY: (line 32) REQUEST TOP NODE (SELECT result-mode):
VALMODE FOR RETVALS: STRING `AUTO'
RETVALS: ARRAY OF NODES with 15 children: {
(line 0) ALIAS:
ALIAS NAME: UNAME `g'
VALUE: (line 32) VARIABLE: notNULL IRI reference exported
NAME: UNAME `g' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 26
(line 0) ALIAS:
ALIAS NAME: UNAME `ownership1'
VALUE: (line 32) VARIABLE: notNULL reference exported
NAME: UNAME `ownership1' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 27
(line 0) ALIAS:
ALIAS NAME: UNAME `legal_entity_owners'
VALUE: (line 32) VARIABLE: notNULL reference exported
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 5
(line 0) ALIAS:
ALIAS NAME: UNAME `legal_entity'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `legal_entity' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 13
(line 0) ALIAS:
ALIAS NAME: UNAME `res1pr'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `res1pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 6
(line 0) ALIAS:
ALIAS NAME: UNAME `a'
VALUE: (line 32) VARIABLE: notNULL IRI reference exported
NAME: UNAME `a' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 28
(line 0) ALIAS:
ALIAS NAME: UNAME `name'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `name' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 23
(line 0) ALIAS:
ALIAS NAME: UNAME `secondname'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `secondname' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 25
(line 0) ALIAS:
ALIAS NAME: UNAME `affiliation'
VALUE: (line 32) VARIABLE: notNULL reference exported
NAME: UNAME `affiliation' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 12
(line 0) ALIAS:
ALIAS NAME: UNAME `company'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `company' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 15
(line 0) ALIAS:
ALIAS NAME: UNAME `ownership2'
VALUE: (line 32) VARIABLE: notNULL reference exported
NAME: UNAME `ownership2' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 17
(line 0) ALIAS:
ALIAS NAME: UNAME `companys_owners'
VALUE: (line 32) VARIABLE: notNULL reference exported
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 18
(line 0) ALIAS:
ALIAS NAME: UNAME `res2pr'
VALUE: (line 32) VARIABLE: notNULL exported
NAME: UNAME `res2pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 21
(line 30) ALIAS:
ALIAS NAME: UNAME `toUri'
VALUE: (line 30) BUILT-IN CALL:if
ARGUMENT: ARRAY OF NODES with 3 children: {
(line 30) OPERATOR EXPRESSION (boolean operation '<='):
LEFT: (line 30) FUNCALL:
FUNCTION NAME: UNAME `xpath:http://www.w3.org/2001/XMLSchema#:integer'
ARGUMENT: (line 30) VARIABLE: notNULL exported
NAME: UNAME `res2pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 21
RIGHT: (line 30) FUNCALL:
FUNCTION NAME: UNAME `xpath:http://www.w3.org/2001/XMLSchema#:integer'
ARGUMENT: (line 30) VARIABLE: notNULL exported
NAME: UNAME `res1pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 6
(line 30) VARIABLE: notNULL reference exported
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 5
(line 30) VARIABLE: notNULL reference exported
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 18
}
(line 31) ALIAS:
ALIAS NAME: UNAME `fromUri'
VALUE: (line 31) BUILT-IN CALL:if
ARGUMENT: ARRAY OF NODES with 3 children: {
(line 31) OPERATOR EXPRESSION (boolean operation '<'):
LEFT: (line 31) FUNCALL:
FUNCTION NAME: UNAME `xpath:http://www.w3.org/2001/XMLSchema#:integer'
ARGUMENT: (line 31) VARIABLE: notNULL exported
NAME: UNAME `res1pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 6
RIGHT: (line 31) FUNCALL:
FUNCTION NAME: UNAME `xpath:http://www.w3.org/2001/XMLSchema#:integer'
ARGUMENT: (line 31) VARIABLE: notNULL exported
NAME: UNAME `res2pr' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 21
(line 31) VARIABLE: notNULL reference exported
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 5
(line 31) VARIABLE: notNULL reference exported
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: LONG 0 EQUIV: LONG 18
}
}
RETVALS SELECT ID: STRING `s_32_22'
SOURCES: EMPTY ARRAY
PATTERN: (line 32) GRAPH PATTERN:WHERE gp
MEMBERS: ARRAY OF NODES with 12 children: {
(line 8) TRIPLE:
GRAPH: (line 7) VARIABLE: notNULL+ IRI+ reference+ exported (graph)
NAME: UNAME `g' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t0' EQUIV: LONG 26
SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `ownership1' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t0' EQUIV: LONG 27
PREDICATE: (line 8) QNAME:
IRI: UNAME `http://sp7.ru/ontology/own_who'
OBJECT: (line 8) VARIABLE: notNULL+ reference exported (object)
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t0' EQUIV: LONG 5
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_10_2_t0'
(line 9) TRIPLE:
GRAPH: (line 7) VARIABLE: notNULL+ IRI+ reference+ exported (graph)
NAME: UNAME `g' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t1' EQUIV: LONG 26
SUBJECT: (line 9) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `ownership1' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t1' EQUIV: LONG 27
PREDICATE: (line 9) QNAME:
IRI: UNAME `http://sp7.ru/ontology/own_what'
OBJECT: (line 9) VARIABLE: notNULL+ exported (object)
NAME: UNAME `legal_entity' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_10_2_t1' EQUIV: LONG 13
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_10_2_t1'
(line 11) TRIPLE:
GRAPH: (line 11) BLANK NODE: NAME: STRING `_::default_11_3' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t4'
SUBJECT: (line 11) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t4' EQUIV: LONG 5
PREDICATE: (line 11) QNAME:
IRI: UNAME `http://sp7.ru/ontology/pr'
OBJECT: (line 11) VARIABLE: notNULL+ exported (object)
NAME: UNAME `res1pr' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t4' EQUIV: LONG 6
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t4'
(line 13) TRIPLE:
GRAPH: (line 12) VARIABLE: notNULL+ IRI+ reference+ exported (graph)
NAME: UNAME `a' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t2' EQUIV: LONG 28
SUBJECT: (line 13) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t2' EQUIV: LONG 5
PREDICATE: (line 13) QNAME:
IRI: UNAME `http://sp7.ru/ontology/name'
OBJECT: (line 13) VARIABLE: notNULL+ exported (object)
NAME: UNAME `name' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t2' EQUIV: LONG 23
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_15_7_t2'
(line 14) TRIPLE:
GRAPH: (line 12) VARIABLE: notNULL+ IRI+ reference+ exported (graph)
NAME: UNAME `a' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t3' EQUIV: LONG 28
SUBJECT: (line 14) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t3' EQUIV: LONG 5
PREDICATE: (line 14) QNAME:
IRI: UNAME `http://sp7.ru/ontology/secondname'
OBJECT: (line 14) VARIABLE: notNULL+ exported (object)
NAME: UNAME `secondname' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_15_7_t3' EQUIV: LONG 25
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_15_7_t3'
(line 17) TRIPLE:
GRAPH: (line 17) BLANK NODE: NAME: STRING `_::default_17_8' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t5'
SUBJECT: (line 17) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `affiliation' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t5' EQUIV: LONG 12
PREDICATE: (line 17) QNAME:
IRI: UNAME `http://sp7.ru/ontology/aff_legal_entity'
OBJECT: (line 17) VARIABLE: notNULL+ exported (object)
NAME: UNAME `legal_entity' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t5' EQUIV: LONG 13
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t5'
(line 18) TRIPLE:
GRAPH: (line 18) BLANK NODE: NAME: STRING `_::default_18_10' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t6'
SUBJECT: (line 18) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `affiliation' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t6' EQUIV: LONG 12
PREDICATE: (line 18) QNAME:
IRI: UNAME `http://sp7.ru/ontology/aff_organization'
OBJECT: (line 18) VARIABLE: notNULL+ exported (object)
NAME: UNAME `company' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t6' EQUIV: LONG 15
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t6'
(line 20) TRIPLE:
GRAPH: (line 20) BLANK NODE: NAME: STRING `_::default_20_12' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t7'
SUBJECT: (line 20) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `ownership2' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t7' EQUIV: LONG 17
PREDICATE: (line 20) QNAME:
IRI: UNAME `http://sp7.ru/ontology/own_who'
OBJECT: (line 20) VARIABLE: notNULL+ reference exported (object)
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t7' EQUIV: LONG 18
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t7'
(line 21) TRIPLE:
GRAPH: (line 21) BLANK NODE: NAME: STRING `_::default_21_14' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t8'
SUBJECT: (line 21) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `ownership2' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t8' EQUIV: LONG 17
PREDICATE: (line 21) QNAME:
IRI: UNAME `http://sp7.ru/ontology/own_what'
OBJECT: (line 21) VARIABLE: notNULL+ exported (object)
NAME: UNAME `company' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t8' EQUIV: LONG 15
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t8'
(line 23) TRIPLE:
GRAPH: (line 23) BLANK NODE: NAME: STRING `_::default_23_16' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t9'
SUBJECT: (line 23) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t9' EQUIV: LONG 18
PREDICATE: (line 23) QNAME:
IRI: UNAME `http://sp7.ru/ontology/pr'
OBJECT: (line 23) VARIABLE: notNULL+ exported (object)
NAME: UNAME `res2pr' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t9' EQUIV: LONG 21
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t9'
(line 24) TRIPLE:
GRAPH: (line 24) BLANK NODE: NAME: STRING `_::default_24_18' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t10'
SUBJECT: (line 24) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t10' EQUIV: LONG 18
PREDICATE: (line 24) QNAME:
IRI: UNAME `http://sp7.ru/ontology/name'
OBJECT: (line 24) VARIABLE: notNULL+ exported (object)
NAME: UNAME `name' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t10' EQUIV: LONG 23
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t10'
(line 25) TRIPLE:
GRAPH: (line 25) BLANK NODE: NAME: STRING `_::default_25_20' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t11'
SUBJECT: (line 25) VARIABLE: notNULL+ reference+ exported (subject)
NAME: UNAME `companys_owners' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t11' EQUIV: LONG 18
PREDICATE: (line 25) QNAME:
IRI: UNAME `http://sp7.ru/ontology/secondname'
OBJECT: (line 25) VARIABLE: notNULL+ exported (object)
NAME: UNAME `secondname' SELECT ID: STRING `s_32_22' TABLE ID: STRING `s_32_22_t11' EQUIV: LONG 25
SELECT ID: STRING `s_32_22'
TABLE ID: STRING `s_32_22_t11'
}
FILTERS: EMPTY ARRAY
SELECT ID: STRING `s_32_22'
EQUIVS: 4 5 6 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
OFFSET: LONG 0
FILTERS: EMPTY ARRAY
SELECT ID: STRING `s_32_23'
EQUIVS: 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
}
FILTERS: ARRAY OF NODES with 1 children: {
(line 28) OPERATOR EXPRESSION (boolean operation '!='):
LEFT: (line 28) VARIABLE: notNULL reference exported
NAME: UNAME `legal_entity_owners' SELECT ID: STRING `s_33_24' TABLE ID: LONG 0 EQUIV: LONG 46
RIGHT: (line 28) VARIABLE: notNULL reference exported
NAME: UNAME `companys_owners' SELECT ID: STRING `s_33_24' TABLE ID: LONG 0 EQUIV: LONG 47
}
SELECT ID: STRING `s_33_24'
EQUIVS: 44 45 46 47 48 49
LIMIT: LONG 1
EQUIVS:
#0: merged and destroyed
#1: merged and destroyed
#2: merged and destroyed
#3: merged and destroyed
#4: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_11_3 in s_32_22_t4; notNULL IRI reference)
#5: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 4 gspo, 3 const, 0 opt, 0 subq: legal_entity_owners in s_32_22_t4 s_32_22 s_32_22 s_32_22 s_15_7_t3 s_15_7_t2 s_10_2_t0; notNULL reference exported)
#6: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 3 const, 0 opt, 0 subq: res1pr in s_32_22_t4 s_32_22 s_32_22 s_32_22; notNULL exported)
#7: merged and destroyed
#8: merged and destroyed
#9: merged and destroyed
#10: merged and destroyed
#11: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_17_8 in s_32_22_t5; notNULL IRI reference)
#12: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: affiliation in s_32_22_t5 s_32_22_t6 s_32_22; notNULL reference exported)
#13: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: legal_entity in s_32_22_t5 s_32_22 s_10_2_t1; notNULL exported)
#14: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_18_10 in s_32_22_t6; notNULL IRI reference)
#15: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: company in s_32_22_t6 s_32_22_t8 s_32_22; notNULL exported)
#16: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_20_12 in s_32_22_t7; notNULL IRI reference)
#17: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: ownership2 in s_32_22_t7 s_32_22_t8 s_32_22; notNULL reference exported)
#18: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 4 gspo, 3 const, 0 opt, 0 subq: companys_owners in s_32_22_t7 s_32_22_t9 s_32_22_t10 s_32_22_t11 s_32_22 s_32_22 s_32_22; notNULL reference exported)
#19: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_21_14 in s_32_22_t8; notNULL IRI reference)
#20: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_23_16 in s_32_22_t9; notNULL IRI reference)
#21: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 3 const, 0 opt, 0 subq: res2pr in s_32_22_t9 s_32_22 s_32_22 s_32_22; notNULL exported)
#22: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_24_18 in s_32_22_t10; notNULL IRI reference)
#23: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: name in s_32_22_t10 s_32_22 s_15_7_t2; notNULL exported)
#24: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 0 const, 0 opt, 0 subq: _::default_25_20 in s_32_22_t11; notNULL IRI reference)
#25: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: secondname in s_32_22_t11 s_32_22 s_15_7_t3; notNULL exported)
#26: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: g in s_32_22 s_10_2_t1 s_10_2_t0; notNULL IRI reference exported)
#27: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: ownership1 in s_32_22 s_10_2_t1 s_10_2_t0; notNULL reference exported)
#28: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 2 gspo, 1 const, 0 opt, 0 subq: a in s_32_22 s_15_7_t3 s_15_7_t2; notNULL IRI reference exported)
#29: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: g in; notNULL IRI reference exported)
#30: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: ownership1 in; notNULL reference exported)
#31: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: legal_entity_owners in; notNULL reference exported)
#32: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: legal_entity in; notNULL exported)
#33: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: res1pr in; notNULL exported)
#34: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: a in; notNULL IRI reference exported)
#35: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: name in; notNULL exported)
#36: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: secondname in; notNULL exported)
#37: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: affiliation in; notNULL reference exported)
#38: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: company in; notNULL exported)
#39: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: ownership2 in; notNULL reference exported)
#40: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: companys_owners in; notNULL reference exported)
#41: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 1 subq: res2pr in; notNULL exported)
#42: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: toUri in; notNULL reference)
#43: ( 0 subv (0 bindings, 0 nest.opt.), 1 recv, 0 gspo, 0 const, 0 opt, 1 subq: fromUri in; notNULL reference)
#44: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 0 subq: g in; notNULL! fixed! IRI reference exported; fixed UNAME 'http://egrul.ru/')
#45: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 0 const, 0 opt, 0 subq: a in; notNULL! fixed! IRI reference exported; fixed UNAME 'http://egrul-name.ru/')
#46: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 1 const, 0 opt, 0 subq: legal_entity_owners in s_33_24; notNULL reference exported)
#47: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 1 const, 0 opt, 0 subq: companys_owners in s_33_24; notNULL reference exported)
#48: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 1 const, 0 opt, 0 subq: toUri in s_33_24; notNULL reference exported)
#49: ( 1 subv (1 bindings, 0 nest.opt.), 0 recv, 0 gspo, 1 const, 0 opt, 0 subq: fromUri in s_33_24; notNULL reference exported)
Why isql-v
have different results?