/tpcDB/nation/name
/tpcNestedDB/suppliers/supplier/nation
${0}
/tpcDB/nation/name
/tpcNestedDB/customers/customer/cnation
${0}
/tpcDB/part/name
/tpcNestedDB/suppliers/supplier/part/name
${0}
/tpcDB/region/name
/tpcNestedDB/suppliers/supplier/region
${0}
/tpcDB/customer/name
/tpcNestedDB/customers/customer/name
${0}
/tpcDB/supplier/name
/tpcNestedDB/suppliers/supplier/name
${0}
/tpcDB/order/orderkey
/tpcNestedDB/suppliers/supplier/part/order/orderkey
${0}
/tpcDB/order/status
/tpcNestedDB/suppliers/supplier/part/order/status
${0}
/tpcDB/region
/tpcNestedDB/suppliers/supplier
$s0/name = $t0/region
/tpcDB/part
/tpcNestedDB/suppliers/supplier
$t0/part
$s0/name = $t1/name
/tpcDB/nation
/tpcDB/region
$s0/regionkey = $s1/regionkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s0/name = $t0/nation AND $s1/name = $t0/region AND $s0/name = $t3/cnation
/tpcDB/supplier
/tpcDB/nation
/tpcDB/region
$s1/nationkey = $s0/nationkey AND $s1/regionkey = $s2/regionkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s0/name = $t0/name AND $s1/name = $t0/nation AND $s2/name = $t0/region AND $s1/name = $t3/cnation
/tpcDB/customer
/tpcDB/nation
/tpcDB/region
$s1/nationkey = $s0/nationkey AND $s1/regionkey = $s2/regionkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s1/name = $t0/nation AND $s2/name = $t0/region AND $s0/name = $t3/name AND $s1/name = $t3/cnation
/tpcDB/order
/tpcDB/customer
/tpcDB/nation
/tpcDB/region
$s2/regionkey = $s3/regionkey AND $s0/custkey = $s1/custkey AND $s2/nationkey = $s1/nationkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s2/name = $t0/nation AND $s3/name = $t0/region AND $s0/status = $t2/status AND $s0/orderkey = $t2/orderkey AND $s1/name = $t3/name AND $s2/name = $t3/cnation
/tpcDB/partsupp
/tpcDB/part
/tpcDB/supplier
/tpcDB/nation
/tpcDB/region
$s3/regionkey = $s4/regionkey AND $s3/nationkey = $s2/nationkey AND $s1/partkey = $s0/partkey AND $s0/suppkey = $s2/suppkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s2/name = $t0/name AND $s3/name = $t0/nation AND $s4/name = $t0/region AND $s1/name = $t1/name AND $s3/name = $t3/cnation
/tpcDB/lineitem
/tpcDB/part
/tpcDB/supplier
/tpcDB/order
/tpcDB/customer
/tpcDB/nation
/tpcDB/region
/tpcDB/nation
/tpcDB/region
$s0/suppkey = $s2/suppkey AND $s3/custkey = $s4/custkey AND $s7/nationkey = $s2/nationkey AND $s7/regionkey = $s8/regionkey AND $s5/regionkey = $s6/regionkey AND $s5/nationkey = $s4/nationkey AND $s1/partkey = $s0/partkey AND $s3/orderkey = $s0/orderkey
/tpcNestedDB/suppliers/supplier
$t0/part
$t1/order
/tpcNestedDB/customers/customer
$t2/custID = $t3/custID
$s2/name = $t0/name AND $s7/name = $t0/nation AND $s6/name = $t0/region AND $s1/name = $t1/name AND $s3/status = $t2/status AND $s3/orderkey = $t2/orderkey AND $s4/name = $t3/name AND $s7/name = $t3/cnation