string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 550 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 450 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 443 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 279 " string(843) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 26 " Transportation & Mobility | Genesis

Transportation & Mobility

Portfolio

Transportation & Mobility

Portfolio

View Project Archive >
Services::__set_state(array( ))