{ "meta": { "stats": { "requestFetchMs": 55, "vectorPreparationMs": 0, "requestPreparationMs": 0, "vectorResolutionMs": 0, "vectorBuildingMs": -1, "enhanceMs": 0 }, "resolvedPaths": [ "projectFeatured/projectConsortiaOrganizationRoleStage/consortia", "projectFeatured/model", "projectFeatured/projectProvince/province", "projectFeatured/projectCity/city", "projectFeatured/stage", "projectFeatured/projectCostBenefit", "projectFeatured/organization", "projectFeatured/project" ], "relations": [ { "mapping": "projectFeatured=>project", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `project_description_ext2`.`refinance_descr` `refinanceNotes`, `project_description_ext2`.`proj_descr_short` `description`, `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`vfm_date` `vfmDate`, `projects`.`year_psc` `yearPsc`, `projects`.`vfm_used` `vfmUsed`, `projects`.`year_debt` `yearDebt`, `projects`.`construct_jobs` `constructJobs`, `projects`.`year_cost_capital` `yearCostCapital`, `projects`.`greenfield_id` `greenfieldId`, `projects`.`preferred_consortia_id` `preferredConsortiaId`, `projects`.`year_fed_funding` `yearFedFunding`, `projects`.`project_id` `id`, `projects`.`year_prov_funding` `yearProvFunding`, `projects`.`year_cost_agreement` `yearCostAgreement`, `projects`.`construct_jobs_after` `constructJobsAfter`, `projects`.`cost_capital` `costCapital`, `projects`.`year_psc_cost` `yearPscCost`, `projects`.`projectname` `name`, `projects`.`year_project_cost` `yearProjectCost`, `projects`.`psc_cost` `pscCost`, `projects`.`stage_id` `stageId`, `projects`.`active` `active`, `projects`.`desc_other_funding` `descOtherFunding`, `projects`.`com_fin_time` `comFinTime`, `projects`.`process_advisor` `processAdvisor`, `projects`.`owner_organization_id` `ownerId`, `projects`.`year_muni_funding` `yearMuniFunding`, `projects`.`desc_psc` `descPsc`, `projects`.`consortia_id` `consortiaId`, `projects`.`psc` `psc`, `projects`.`procure_time_actual` `procureTimeActual`, `projects`.`is_horizontal` `isHorizontal`, `projects`.`cost_savings` `costSavings`, `projects`.`project_cost` `projectCost`, `projects`.`desc_psc_cost` `descPscCost`, `projects`.`post_construction_term` `postConstructionTerm`, `projects`.`tender_type_id` `tenderTypeId`, `projects`.`next_stage_id` `nextStageId`, `projects`.`year_other_funding` `yearOtherFunding`, `projects`.`desc_cost_capital` `descCostCapital`, `projects`.`desc_debt` `descDebt`, `projects`.`desc_muni_funding` `descMuniFunding`, `projects`.`fin_subcompletion_time` `finSubcompletionTime`, `projects`.`customers` `customers`, `projects`.`desc_fed_funding` `descFedFunding`, `projects`.`desc_cost_savings` `descCostSavings`, `projects`.`year_cost_savings` `yearCostSavings`, `projects`.`jobs` `jobs`, `projects`.`desc_equity` `descEquity`, `projects`.`desc_prov_funding` `descProvFunding`, `projects`.`model_id` `modelId`, `projects`.`sub_sector_id` `subSectorId`, `projects`.`desc_project_cost` `descProjectCost`, `projects`.`ontime_construction` `ontimeConstruction`, `projects`.`cost_agreement` `costAgreement`, `projects`.`sector_id` `sectorId`, `projects`.`year_equity` `yearEquity` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description_ext1` ON `projects`.`project_id` = `project_description_ext1`.`project_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id" }, { "mapping": "projectProvince=>province", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_province`.`index` `projectProvinceId`, `provinces`.`province_id` `id`, `provinces`.`name` `name` FROM `project_province` joinProject_province JOIN `provinces` ON `joinProject_province`.`province_id` = `provinces`.`province_id` WHERE `joinProject_province`.`index` IN (9222) ", "ingestionMs": "0" }, "keyPath": "project_province.province_id -> provinces.province_id" }, { "mapping": "projectFeatured=>projectProvince", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_province`.`project_id` `projectId`, `project_province`.`province_id` `provinceId`, `project_province`.`index` `id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_province` ON `joinProjects`.`project_id` = `project_province`.`project_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_province.project_id" }, { "mapping": "projectConsortiaOrganizationRoleStage=>consortia", "query": { "resultCount": "6", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `consortia`.`imis_id` `imisId`, `consortia`.`name` `name`, `consortia`.`consortia_id` `id`, `consortia`.`url` `url`, `joinProject_consortia_organization_role_stage`.`mapping_id` `projectConsortiaOrganizationRoleStageId` FROM `project_consortia_organization_role_stage` joinProject_consortia_organization_role_stage JOIN `consortia` ON `joinProject_consortia_organization_role_stage`.`consortia_id` = `consortia`.`consortia_id` WHERE `joinProject_consortia_organization_role_stage`.`mapping_id` IN (7525,7577,7578,7579,7580,7581) ", "ingestionMs": "0" }, "keyPath": "project_consortia_organization_role_stage.consortia_id -> consortia.consortia_id" }, { "mapping": "projectFeatured=>stage", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `stages`.`stage` `name`, `stages`.`stage_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `stages` ON `joinProjects`.`stage_id` = `stages`.`stage_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> stages.stage_id" }, { "mapping": "projectFeatured=>projectCostBenefit", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`project_id` `id` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description` ON `projects`.`project_id` = `project_description`.`project_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id" }, { "mapping": "projectFeatured=>organization", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `organization`.`sponsor` `sponsor`, `organization`.`type_id` `typeId`, `organization`.`imis_id` `imisId`, `organization`.`organization_id` `id`, `organization`.`name` `name` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `organization` ON `joinProjects`.`owner_organization_id` = `organization`.`organization_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> organization.organization_id" }, { "mapping": "projectFeatured=>projectCity", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `project_city`.`project_id` `projectId`, `project_city`.`index` `id`, `project_city`.`city_id` `cityId`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_city` ON `joinProjects`.`project_id` = `project_city`.`project_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_city.project_id" }, { "mapping": "projectCity=>city", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `cities`.`city_name` `name`, `cities`.`province_id` `provinceId`, `cities`.`city_id` `id`, `joinProject_city`.`index` `projectCityId` FROM `project_city` joinProject_city JOIN `cities` ON `joinProject_city`.`city_id` = `cities`.`city_id` WHERE `joinProject_city`.`index` IN (8707) ", "ingestionMs": "0" }, "keyPath": "project_city.city_id -> cities.city_id" }, { "mapping": "projectFeatured=>projectConsortiaOrganizationRoleStage", "query": { "resultCount": "6", "generationMs": "0", "executionMs": "5", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_consortia_organization_role_stage`.`project_id` `projectId`, `project_consortia_organization_role_stage`.`role_id` `roleId`, `project_consortia_organization_role_stage`.`stage_id` `stageId`, `project_consortia_organization_role_stage`.`mapping_id` `id`, `project_consortia_organization_role_stage`.`organization_id` `organizationId`, `project_consortia_organization_role_stage`.`consortia_id` `consortiaId` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_consortia_organization_role_stage` ON `joinProjects`.`project_id` = `project_consortia_organization_role_stage`.`project_id` AND `project_consortia_organization_role_stage`.`stage_id` = '30' WHERE `project_consortia_organization_role_stage`.`stage_id` = '30' AND `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_consortia_organization_role_stage.project_id" }, { "mapping": "=>projectFeatured", "query": { "resultCount": "1", "generationMs": "1", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `project_featured`.`note` `note`, `project_featured`.`project_id` `projectId`, `project_featured`.`start` `start`, `project_featured`.`end` `end`, `project_featured`.`id` `id` FROM `project_featured` ", "ingestionMs": "0" } }, { "mapping": "projectFeatured=>model", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `models`.`model_name` `name`, `models`.`model_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `models` ON `joinProjects`.`model_id` = `models`.`model_id` WHERE `joinProject_featured`.`id` IN (13) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> models.model_id" } ] }, "projectFeatured": { "stage": { "project_id": 719, "name": "Operational", "projectFeaturedId": 13, "id": 14 }, "projectCostBenefit": { "projectFeaturedId": 13, "id": 719 }, "projectCity": { "project_id": 719, "city": { "projectCityId": 8707, "name": "Markham", "id": 73 }, "projectFeaturedId": 13, "cityId": 73, "id": 8707, "projectId": 719 }, "organization": { "sponsor": false, "project_id": 719, "imisId": 248, "projectFeaturedId": 13, "name": "York University ", "typeId": 1, "id": 4596 }, "project": { "sectorId": 8, "modelId": 22, "costSavings": 95000000, "active": true, "marketValue": 95000000, "vfmUsed": false, "ownerId": 4596, "costAgreement": 95000000, "isHorizontal": false, "procureTimeActual": "334", "projectFeaturedId": 13, "name": "The Quad at York University", "id": 719, "subSectorId": 88, "comFinTime": "1949", "stageId": 14, "nextStageId": 15, "finSubcompletionTime": "609" }, "model": { "project_id": 719, "name": "Design-Build-Finance-Maintain-Operate", "projectFeaturedId": 13, "id": 22 }, "projectProvince": { "province": { "projectProvinceId": 9222, "name": "Ontario", "id": 9 }, "project_id": 719, "projectFeaturedId": 13, "id": 9222, "projectId": 719, "provinceId": 9 }, "id": 13, "projectId": 719, "projectConsortiaOrganizationRoleStages": [ { "organizationId": 317, "project_id": 719, "roleId": 356, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7525, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7525, "id": 1069 }, "stageId": 30 }, { "organizationId": 2009, "project_id": 719, "roleId": 2, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7577, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7577, "id": 1069 }, "stageId": 30 }, { "organizationId": 4597, "project_id": 719, "roleId": 356, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7578, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7578, "id": 1069 }, "stageId": 30 }, { "organizationId": 4598, "project_id": 719, "roleId": 205, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7579, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7579, "id": 1069 }, "stageId": 30 }, { "organizationId": 642, "project_id": 719, "roleId": 240, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7580, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7580, "id": 1069 }, "stageId": 30 }, { "organizationId": 4598, "project_id": 719, "roleId": 240, "projectFeaturedId": 13, "consortiaId": 1069, "id": 7581, "projectId": 719, "consortia": { "name": "Forum-Campus Suites ", "projectConsortiaOrganizationRoleStageId": 7581, "id": 1069 }, "stageId": 30 } ] } }