Milan/Da/NPD_atomic_test/queries/atomic-Area.qpair

name=Atomic query: <http://sws.ifi.uio.no/vocab/npd-v2#Area>
orderNum=3
sql=SELECT COUNT(*) FROM (SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/quadrant/', CAST(TABLE1.qdrName AS CHARACTER VARYING)) AS x FROM apaAreaNet TABLE1 WHERE TABLE1.qdrName IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/licence/', CAST(TABLE1.prlNpdidLicence AS CHARACTER VARYING), '/block/', CAST(TABLE1.blcName AS CHARACTER VARYING), '/polyno/', CAST(TABLE1.prlAreaPolyPolyNo AS CHARACTER VARYING), '/history/', CAST(TABLE1.prlAreaPolyDateValidFrom AS CHARACTER VARYING), '/', CAST(TABLE1.prlAreaPolyDateValidTo AS CHARACTER VARYING)) AS x FROM prlAreaSplitByBlock TABLE1 WHERE TABLE1.blcName IS NOT NULL AND TABLE1.prlAreaPolyDateValidFrom IS NOT NULL AND TABLE1.prlAreaPolyDateValidTo IS NOT NULL AND TABLE1.prlAreaPolyPolyNo IS NOT NULL AND TABLE1.prlNpdidLicence IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/licence/', CAST(TABLE1.prlNpdidLicence AS CHARACTER VARYING), '/block/', CAST(TABLE1.prlAreaPolyBlockName AS CHARACTER VARYING), '/polyno/', CAST(TABLE1.prlAreaPolyPolyNo AS CHARACTER VARYING), '/history/', CAST(TABLE1.prlAreaPolyDateValidFrom AS CHARACTER VARYING), '/', CAST(TABLE1.prlAreaPolyDateValidTo AS CHARACTER VARYING)) AS x FROM licence_area_poly_hst TABLE1 WHERE TABLE1.prlAreaPolyBlockName IS NOT NULL AND TABLE1.prlAreaPolyPolyNo IS NOT NULL AND TABLE1.prlNpdidLicence IS NOT NULL AND TABLE1.prlAreaPolyDateValidFrom IS NOT NULL AND TABLE1.prlAreaPolyDateValidTo IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/survey/', CAST(TABLE1.seaSurveyName AS CHARACTER VARYING), '/multiline') AS x FROM seaMultiline TABLE1 WHERE TABLE1.seaSurveyName IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/mainarea/', CAST(TABLE1.apaAreaGross_id AS CHARACTER VARYING)) AS x FROM apaAreaGross TABLE1 WHERE TABLE1.apaAreaGross_id IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/licence/', CAST(TABLE1.prlNpdidLicence AS CHARACTER VARYING), '/area/', CAST(TABLE1.prlArea_id AS CHARACTER VARYING), '/history/', CAST(TABLE1.prlAreaPolyDateValidFrom AS CHARACTER VARYING), '/', CAST(TABLE1.prlAreaPolyDateValidTo AS CHARACTER VARYING)) AS x FROM prlArea TABLE1 WHERE TABLE1.prlArea_id IS NOT NULL AND TABLE1.prlAreaPolyDateValidFrom IS NOT NULL AND TABLE1.prlAreaPolyDateValidTo IS NOT NULL AND TABLE1.prlNpdidLicence IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/quadrant/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING)) AS x FROM wellbore_development_all TABLE1 WHERE TABLE1.wlbNamePart1 IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/quadrant/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING)) AS x FROM wellbore_exploration_all TABLE1 WHERE TABLE1.wlbNamePart1 IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/quadrant/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING)) AS x FROM wellbore_shallow_all TABLE1 WHERE TABLE1.wlbNamePart1 IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/discovery/', CAST(TABLE1.dscNpdidDiscovery AS CHARACTER VARYING), '/area/hctype/', CAST(TABLE1.dscHcType AS CHARACTER VARYING)) AS x FROM dscArea TABLE1 WHERE TABLE1.dscHcType IS NOT NULL AND TABLE1.dscNpdidDiscovery IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/survey/', CAST(TABLE1.seaSurveyName AS CHARACTER VARYING), '/area') AS x FROM seaArea TABLE1 WHERE TABLE1.seaSurveyName IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/baa/', CAST(TABLE1.baaNpdidBsnsArrArea AS CHARACTER VARYING), '/polygon/', CAST(TABLE1.baaNpdidBsnsArrAreaPoly AS CHARACTER VARYING)) AS x FROM baaArea TABLE1 WHERE TABLE1.baaNpdidBsnsArrArea IS NOT NULL AND TABLE1.baaNpdidBsnsArrAreaPoly IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/baa/', CAST(TABLE1.baaNpdidBsnsArrArea AS CHARACTER VARYING), '/block/', CAST(TABLE1.baaAreaPolyBlockName AS CHARACTER VARYING), '/polyno/', CAST(TABLE1.baaAreaPolyNo AS CHARACTER VARYING), '/history/', CAST(TABLE1.baaAreaPolyDateValidFrom AS CHARACTER VARYING), '/', CAST(TABLE1.baaAreaPolyDateValidTo AS CHARACTER VARYING)) AS x FROM bsns_arr_area_area_poly_hst TABLE1 WHERE TABLE1.baaAreaPolyBlockName IS NOT NULL AND TABLE1.baaAreaPolyNo IS NOT NULL AND TABLE1.baaNpdidBsnsArrArea IS NOT NULL AND TABLE1.baaAreaPolyDateValidFrom IS NOT NULL AND TABLE1.baaAreaPolyDateValidTo IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/quadrant/', CAST(TABLE1.qdrName AS CHARACTER VARYING), '/block/', CAST(TABLE1.blkName AS CHARACTER VARYING), '/award/', CAST(TABLE1.prvName AS CHARACTER VARYING), '/area/', CAST(TABLE1.apaAreaNet_id AS CHARACTER VARYING)) AS x FROM apaAreaNet TABLE1 WHERE TABLE1.blkName IS NOT NULL AND TABLE1.prvName IS NOT NULL AND TABLE1.apaAreaNet_id IS NOT NULL AND TABLE1.qdrName IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/discovery/', CAST(TABLE1.dscNpdidDiscovery AS CHARACTER VARYING), '/area/hctype/', CAST(TABLE1.dscHcType AS CHARACTER VARYING)) AS x FROM fldArea TABLE1 WHERE TABLE1.dscHcType IS NOT NULL AND TABLE1.dscNpdidDiscovery IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/block/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING), '/', CAST(TABLE1.wlbNamePart2 AS CHARACTER VARYING)) AS x FROM wellbore_shallow_all TABLE1 WHERE TABLE1.wlbNamePart1 IS NOT NULL AND TABLE1.wlbNamePart2 IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/block/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING), '/', CAST(TABLE1.wlbNamePart2 AS CHARACTER VARYING)) AS x FROM wellbore_exploration_all TABLE1 WHERE TABLE1.wlbNamePart1 IS NOT NULL AND TABLE1.wlbNamePart2 IS NOT NULL UNION ALL SELECT CONCAT('http://sws.ifi.uio.no/data/npd-v2/block/', CAST(TABLE1.wlbNamePart1 AS CHARACTER VARYING), '/', CAST(TABLE1.wlbNamePart2 AS CHARACTER VARYING)) AS x FROM wellbore_development_all TABLE1 WHERE TABLE1.wlbNamePart2 IS NOT NULL AND TABLE1.wlbNamePart1 IS NOT NULL) AS T
sparql=SELECT (COUNT(*) AS ?count) { ?x a <http://sws.ifi.uio.no/vocab/npd-v2#Area> } 
entityIdCols=
entityIdVars=
categories=class, join-0, union-17